Friday, April 28, 2017

Query to Get Concurrent Program Process Details

SELECT DISTINCT
  c.USER_CONCURRENT_PROGRAM_NAME,
  ROUND(((sysdate-a.actual_start_date)*24*60*60/60),2) AS Process_time,
  a.request_id,
  a.parent_request_id,
  a.request_date,
  a.actual_start_date,
  a.actual_completion_date,
  (a.actual_completion_date- a.request_date)*24*60*60 AS end_to_end,
  (a.actual_start_date     - a.request_date)*24*60*60 AS lag_time,
  d.user_name,
  a.phase_code,
  a.status_code,
  a.argument_text,
  a.priority
FROM
  apps.fnd_concurrent_requests a,
  apps.fnd_concurrent_programs b,
  apps.FND_CONCURRENT_PROGRAMS_TL c,
  apps.fnd_user d
WHERE 1=1
  AND a.concurrent_program_id =b.concurrent_program_id
  AND b.concurrent_program_id =c.concurrent_program_id
  AND a.requested_by =d.user_id
  AND status_code='P'
  AND c.USER_CONCURRENT_PROGRAM_NAME LIKE 'RS%'
ORDER BY Process_time DESC;


No comments:

Post a Comment

Best Blogger TipsGet Flower Effect