Query To Check Scheduled Concurrent Requests

SELECT fcr.request_id,
fcr.parent_request_id,
fu.user_name, requestor,
To_char(fcr.requested_start_date, ‘MON-DD-YYYY HH24:MM:SS’) START_DATE,
fr.responsibility_key
responsibility,
fcp.concurrent_program_name,
fcpt.user_concurrent_program_name,
Decode(fcr.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,
Decode(fcr.phase_code, ‘C’, ‘Completed’,
‘I’, ‘Inactive’,
‘P’, ‘Pending’,
‘R’, ‘Running’) phase,
fcr.completion_text
FROM fnd_concurrent_requests fcr,
fnd_concurrent_programs fcp,
fnd_concurrent_programs_tl fcpt,
fnd_user fu,
fnd_responsibility fr
WHERE fcr.status_code IN ( ‘Q’, ‘I’ )
AND fcr.hold_flag = ‘N’
AND fcr.requested_start_date > SYSDATE
AND fu.user_id = fcr.requested_by
AND fcr.concurrent_program_id = fcp.concurrent_program_id
AND fcr.concurrent_program_id = fcpt.concurrent_program_id
AND fcr.responsibility_id = fr.responsibility_id
ORDER BY fcr.requested_start_date,
fcr.request_id;