Query to find parameters of a concurrent request

Query to find parameters of a concurrent request

In this post , We will be discuss about query to find parameters of a concurrent request. This sql query will help to extract the submitted concurrent requests parameters in oracle apps. We will get to know , which are the parameters used in the concurrent requests while submitting these requests. Here below is the detail about Query to find parameters of a concurrent request.

Query to find parameters of a concurrent request

3 Important Table used by Query to find parameters of a concurrent request

1.fnd_concurrent_programs_vl

2.fnd_concurrent_requests

3.fnd_lookup_values   

Detail SQL Query to find parameters of a concurrent request

SELECT DISTINCT fcp.user_concurrent_program_name,

                fcp.concurrent_program_name,

                fcr.request_id,

                fcr.request_date,

                flv.meaning status,

                fcr.status_code,

                fcr.logfile_name,

                fcr.outfile_name,

                fcr.argument_text "Program Parameters",

                 fcr.completion_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