Query to find submitted Concurrent Request Details in Oracle EBS R12

 --Query to find submitted Concurrent Request Details

SELECT rq.parent_request_id                      "Parent Req. ID",
       rq.request_id                             "Req. ID",
       tl.user_concurrent_program_name           "Program Name",
       rq.actual_start_date                      "Start Date",
       rq.actual_completion_date                 "Completion Date",
       (SELECT meaning
        FROM   apps.fnd_lookups
        WHERE  lookup_type = 'CP_STATUS_CODE'
               AND lookup_code = rq.status_code) status_code,
       (SELECT meaning
        FROM   apps.fnd_lookups
        WHERE  lookup_type = 'CP_PHASE_CODE'
               AND lookup_code = rq.phase_code)  phase_code,
       rq.argument_text                          parameter,
       Round(( rq.actual_completion_date - rq.actual_start_date ) * 1440, 2)
                                                 "Runtime (in Minutes)",
       Round(( ( rq.actual_completion_date - rq.actual_start_date ) * 1440 ) /
             60, 2)
                                                 "Runtime (in Hrs)",
       (SELECT user_name
               ||' - '
               ||email_address
        FROM   fnd_user
        WHERE  user_id = rq.requested_by)        run_by
FROM   applsys.fnd_concurrent_programs_tl tl,
       applsys.fnd_concurrent_requests rq
WHERE  tl.application_id = rq.program_application_id
       AND tl.concurrent_program_id = rq.concurrent_program_id
       AND tl.LANGUAGE = Userenv('LANG')
       AND rq.actual_start_date IS NOT NULL
       --AND      rq.actual_completion_date IS NOT NULL 
       --AND      rq.status_code = 'E' --Status : C-Normal,E-Error,D-Cancelled 
       AND tl.user_concurrent_program_name IN ( '-----------------------' )
ORDER  BY 1 DESC;