-- Concurrent request performance and queue analysis
-- Alan Telford 06 Aug 2019
-- Oracle EBS R12.1.3
SELECT
  requested_start_date,
  actual_start_date,
  actual_completion_date,
  requested_start_date,
  round(24 *(actual_start_date - requested_start_date),2)*60 queue_time,
  round(24*(actual_completion_date - actual_start_date),2)*60 run_time_min,
  priority,
  concurrent_program_id
   ,ARGUMENT_TEXT
   , requestor
   , program_short_name
   , program
FROM
  fnd_conc_req_summary_v
WHERE
 -- updat the concurrent short program name as appropriate
  program_short_name = 'GLPPOSS'
  AND actual_start_date > SYSDATE - 0.5
order by
  actual_start_date;