Query to get concurrent program schedule details

Query to get concurrent program schedule details

In this post , We will be discuss about query to get concurrent program schedule details. This query will help to extract the list of all the scheduled concurrent programs in oracle apps. We will get to know about the informations about the concurrent programs which are schedule in system. This is one of the useful sql query for concurrent programs. Here below is the complete detail about query to get concurrent program schedule details. 

Important Tables used by Query to get concurrent program schedule details

1.fnd_concurrent_programs_vl

2.fnd_concurrent_requests

3.fnd_lookup_values     

Detail SQL Query to get concurrent program schedule details

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,

                 TO_CHAR(fcr.request_date, 'DD-MON-YYYY HH24:MI:SS') requested

     , TO_CHAR(fcr.requested_start_date, 'DD-MON-YYYY HH24:MI:SS') requested_start  

     , TO_CHAR((fcr.requested_start_date), 'HH24:MI:SS') start_time

  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 fcr.phase_code = 'P'

   AND flv.language = 'US'

 ORDER BY fcr.request_date desc