Schedule Program Query in Oracle APPS

SELECT fcr.request_id,
DECODE (fcpt.user_concurrent_program_name,
‘Report Set’, ‘Report Set:’ || fcr.description,
fcpt.user_concurrent_program_name
) conc_prog_name,
argument_text PARAMETERS,
NVL2 (fcr.resubmit_interval,
‘PERIODICALLY’,
NVL2 (fcr.release_class_id, ‘ON SPECIFIC DAYS’, ‘ONCE’)
) prog_schedule_type,
DECODE (NVL2 (fcr.resubmit_interval,
‘PERIODICALLY’,
NVL2 (fcr.release_class_id, ‘ON SPECIFIC DAYS’, ‘ONCE’)
),
‘PERIODICALLY’, ‘EVERY ‘
|| fcr.resubmit_interval
|| ‘ ‘
|| fcr.resubmit_interval_unit_code
|| ‘ FROM ‘
|| fcr.resubmit_interval_type_code
|| ‘ OF PREV RUN’,
‘ONCE’, ‘AT :’
|| TO_CHAR (fcr.requested_start_date, ‘DD-MON-RR HH24:MI’),
‘EVERY: ‘ || fcrc.class_info
) prog_schedule,
fu.user_name user_name,
requested_start_date start_date
FROM apps.fnd_concurrent_programs_tl fcpt,
apps.fnd_concurrent_requests fcr,
apps.fnd_user fu,
apps.fnd_conc_release_classes fcrc
WHERE fcpt.application_id = fcr.program_application_id
AND fcpt.concurrent_program_id = fcr.concurrent_program_id
AND fcr.requested_by = fu.user_id
AND fcr.phase_code = ‘P’
AND fcr.requested_start_date > SYSDATE
AND fcpt.LANGUAGE = ‘US’
AND fcrc.release_class_id(+) = fcr.release_class_id
AND fcrc.application_id(+) = fcr.release_class_app_id;

Advertisements