Query to checking last run of a concurrent program along with processed time. useful to find the details of concurrent programs which run daily and comparison purpose

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) = '24-aug-2005'

       AND c.user_concurrent_program_name = 'incentive compensation analytics - odi'

       --  and argument_text like  '%, , , , ,%';

       --  and status_code!='c'