Concurrent Request History

col PROGRAM for a30
col REQUESTOR for a15
set linesize 400
set pagesize 400
set feedback on
col Start_Time for a20
col End_Time for a20
col phase for a15
select request_id,
fu.user_name requestor,
ctl.user_concurrent_program_name program,
to_char(actual_start_date,'DD-MON-RR HH24:MI') Start_Time,
to_char(actual_completion_date,'DD-MON-RR HH24:MI') End_Time,
((nvl(actual_completion_date,sysdate)-actual_start_date)*1440) Total_Time,
decode(a.phase_code,'R','Running','P','Inactive','C','Completed',
              a.phase_code) phase,
decode(a.status_code,'E','Error',   'C','Normal',    'X','Terminated',
                            'Q','On Hold', 'D','Cancelled', 'G','Warning',
                            'R','Normal',  'W', 'Paused',
                            a.status_code) status
from APPLSys.fnd_Concurrent_requests a,APPLSys.fnd_concurrent_processes b
    ,applsys.fnd_concurrent_queues q
    ,APPLSys.fnd_concurrent_programs c
    ,APPLSys.fnd_concurrent_programs_tl ctl,APPLsys.fnd_user fu
where a.controlling_manager = b.concurrent_process_id
  and a.concurrent_program_id = c.concurrent_program_id
  and a.program_application_id = c.application_id
  and b.queue_application_id = q.application_id
  and b.concurrent_queue_id = q.concurrent_queue_id
  and ctl.concurrent_program_id = c.concurrent_program_id
  and ctl.language = 'US'
  and fu.user_id = a.requested_by
  and  ctl.user_concurrent_program_name LIKE '%ProgramName%'
  ORDER BY Start_Time;