Checking last run of a Concurrent Program along with Processed time

SELECT DISTINCT c.USER_CONCURRENT_PROGRAM_NAME,
            round(((a.actual_completion_date-a.actual_start_date)*24*60*60/60),2) AS Process_time,
           
a.request_id,a.parent_request_id,To_Char(a.request_date,’DD-MON-YY
HH24:MI:SS’),To_Char(a.actual_start_date,’DD-MON-YY HH24:MI:SS’),
  To_Char(a.actual_completion_date,’DD-MON-YY HH24:MI:SS’), (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       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
—          trunc(a.actual_completion_date) = ’20-MAY-2016′
c.USER_CONCURRENT_PROGRAM_NAME=’Incentive Compensation Analytics – ODI’ —  and argument_text like  ‘%, , , , ,%’;
—          and status_code!=’C’
  • April 26, 2016 | 14 views