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; |
Question and Comments
The gadget spec URL could not be found