Check Concurrent Job Status Running

2:41 AM Hendry 0 Comments

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 REQUEST_DATE like'%06-NOV-%' 

 ORDER BY fcr.request_date,

          fcr.request_id DESC;