Query To Find Scheduled Concurrent Request

SELECT cr.request_id,
Decode(cp.user_concurrent_program_name, ‘Report Set’, ‘Report Set:’
|| cr.description,
cp.user_concurrent_program_name)
NAME,
argument_text,
cr.resubmit_interval,
Nvl2(cr.resubmit_interval, ‘PERIODICALLY’,
Nvl2(cr.release_class_id, ‘ON SPECIFIC DAYS’, ‘ONCE’))
schedule_type,
Decode(Nvl2(cr.resubmit_interval, ‘PERIODICALLY’,
Nvl2(cr.release_class_id, ‘ON SPECIFIC DAYS’, ‘ONCE’)),
‘PERIODICALLY’, ‘EVERY ‘
|| cr.resubmit_interval
|| ‘ ‘
|| cr.resubmit_interval_unit_code
|| ‘FROM’
|| cr.resubmit_interval_type_code
|| ‘OF PREV RUN’,
‘ONCE’,
‘AT:’
||
To_char(cr.requested_start_date, ‘DD-MON-RR HH24:MI’),
‘EVERY: ‘
||
fcr.class_info)
SCHEDULE,
fu.user_name,
requested_start_date
FROM apps.fnd_concurrent_programs_tl cp,
apps.fnd_concurrent_requests cr,
apps.fnd_user fu,
apps.fnd_conc_release_classes fcr
WHERE cp.application_id = cr.program_application_id
AND cp.concurrent_program_id = cr.concurrent_program_id
AND cr.requested_by = fu.user_id
AND cr.phase_code = ‘P’
AND cr.requested_start_date > SYSDATE
AND cp.LANGUAGE = ‘US’
AND fcr.release_class_id(+) = cr.release_class_id
AND fcr.application_id(+) = cr.release_class_app_id;