Concurrent Program Status Code & Phase Code meaning, SQL
Concurrent Program Status Code & Phase Code meaning
STATUS_CODE:
A - Waiting
B - Resuming
C - Normal
D - Cancelled
E - Error
F - Scheduled
G - Warning
H - On Hold
I - Normal
M - No Manager
Q - Standby
R - Normal
S - Suspended
T - Terminating
U - Disabled
W - Paused
X - Terminated
Z - Waiting
PHASE_CODE:
C - Completed
I - Inactive
P - Pending
R - Running
SQL:
SELECT user_concurrent_program_name,
DECODE (phase_code,
'C', 'Completed',
'I', 'Inactive',
'P', 'Pending',
'R', 'Running') Phase,
DECODE (status_code,
'A', 'Waiting''B',
'Resuming''C', 'Normal''D',
'Cancelled''E', 'Error''F',
'Scheduled''G', 'Warning''H',
'On Hold''I', 'Normal''M',
'No Manager''Q', 'Standby''R',
'Normal''S', 'Suspended''T',
'Terminating''U', 'Disabled''W',
'Paused''X', 'Terminated''Z',
'Waiting') status,
actual_start_date,
actual_completion_date,
completion_text,
argument_text,
requestor--, cp.*
FROM fnd_conc_req_summary_v cp
STATUS_CODE:
A - Waiting
B - Resuming
C - Normal
D - Cancelled
E - Error
F - Scheduled
G - Warning
H - On Hold
I - Normal
M - No Manager
Q - Standby
R - Normal
S - Suspended
T - Terminating
U - Disabled
W - Paused
X - Terminated
Z - Waiting
PHASE_CODE:
C - Completed
I - Inactive
P - Pending
R - Running
SQL:
SELECT user_concurrent_program_name,
DECODE (phase_code,
'C', 'Completed',
'I', 'Inactive',
'P', 'Pending',
'R', 'Running') Phase,
DECODE (status_code,
'A', 'Waiting''B',
'Resuming''C', 'Normal''D',
'Cancelled''E', 'Error''F',
'Scheduled''G', 'Warning''H',
'On Hold''I', 'Normal''M',
'No Manager''Q', 'Standby''R',
'Normal''S', 'Suspended''T',
'Terminating''U', 'Disabled''W',
'Paused''X', 'Terminated''Z',
'Waiting') status,
actual_start_date,
actual_completion_date,
completion_text,
argument_text,
requestor--, cp.*
FROM fnd_conc_req_summary_v cp
No comments:
Post a Comment