Concurrent Program - Query to find Status of requests

The following query will give you the list of concurrent programs that run today with the statuses/name of the concurrent program/request id/log/outfilenames and the argument text as well.

SELECT DISTINCT fcp.user_concurrent_program_name,

fcp.concurrent_program_name,

fcr.request_id,

fcr.request_date,

flv.meaning status,

fcr.status_code,

fcr.completion_text,

fcr.logfile_name,

fcr.outfile_name,

fcr.argument_text

FROM apps.fnd_concurrent_programs_vl fcp,

apps.fnd_concurrent_requests fcr,

apps.fnd_lookup_values flv

WHERE fcr.concurrent_program_id = fcp.concurrent_program_id

AND trunc(fcr.last_update_date) = trunc(SYSDATE)

AND flv.lookup_code = fcr.status_code

AND flv.lookup_type = 'CP_STATUS_CODE'

AND flv.language = 'US'

ORDER BY fcr.request_date,

fcr.request_id DESC;

Concurrent Program - Query to find Status of requests

Question and Comments