Query to find the concurrent program details with request id

Query to find the concurrent program details with request id

In this post , we will be discuss about Query to find the concurrent program details with request id. This sql query will help to extract the list of concurrent program details concurrent request details. We will get the complete information about concurrent program and concurrent request details. Here below is the detail about Query to find the concurrent program details with request id.

Query to find the concurrent program details with request id

3 Important Table used by query to find the concurrent program details with request id

1.fnd_concurrent_programs_vl

2.fnd_concurrent_requests

3.fnd_lookup_values

Detail SQL Query to find the concurrent program details with request id

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 desc