Thursday, March 23, 2017

Concurrent Program Status Code & Phase Code meaning, SQL

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

No comments:

Post a Comment

Oracle Fusion - Cost Lines and Expenditure Item link in Projects

SELECT   ccd.transaction_id,ex.expenditure_item_id,cacat.serial_number FROM fusion.CST_INV_TRANSACTIONS cit,   fusion.cst_cost_distribution_...