Query To Check Total Scheduled Requests
SELECT request_id, id,
Nvl(meaning, ‘UNKNOWN’),status,
user_concurrent_program_name, pname,
To_char(request_date, ‘DD-MON-RR HH24:MI:SS’), submitted,
To_char(requested_start_date, ‘DD-MON-RR HH24:MI:SS’) requested
FROM fnd_concurrent_requests fcr,
fnd_lookups fl,
fnd_concurrent_programs_vl fcpv
WHERE phase_code = ‘P’
AND (fcr.requested_start_date >= SYSDATE
OR status_code = ‘P’)
AND lookup_type = ‘CP_STATUS_CODE’
AND lookup_code = status_code
AND fcr.concurrent_program_id = fcpv.concurrent_program_id
AND fcr.program_application_id = fcpv.application_id
ORDER BY pname,
request_date;