Tags

, ,

Here is the query to fetch concurrent program run and the various status:

SELECT request_id,
program,
requestor,
request_date,
actual_start_date,
actual_completion_date,
ROUND ( (actual_completion_date – actual_start_date) * 24 * 60, 2)
total_duration_mins,
DECODE (phase_code,
‘C’, ‘Completed’,
‘I’, ‘Inactive’,
‘P’, ‘Pending’,
‘R’, ‘Running’)
phase_code,
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_code,
argument_text,
program_short_name
FROM apps.FND_CONC_REQ_SUMMARY_V
WHERE TRUNC (actual_start_date) = TRUNC (SYSDATE)
ORDER BY status_code;

Advertisements