Concurrent Program Execution Details

SELECT prog.concurrent_program_id
     , prog.concurrent_program_name
     , prog.user_concurrent_program_name
     , req.request_id
     , to_char(req.actual_start_date ,'DD-MON-YYYY HH24:MI:SS') actual_start_date
     , to_char(req.actual_completion_date ,'DD-MON-YYYY HH24:MI:SS') actual_completion_date 
     , FLOOR((actual_completion_date - actual_start_date)*24) || ':' ||
              FLOOR(((actual_completion_date - actual_start_date)*24 -
              FLOOR((actual_completion_date - actual_start_date)*24)
                     )*60) ||':' ||
                      FLOOR(((actual_completion_date - actual_start_date)*24*60-
                              FLOOR((actual_completion_date - actual_start_date)*24*60)
             )*60
            ) Duration
     , argument_text
     , usr.user_name
     , resp.responsibility_name
  FROM apps.fnd_concurrent_programs_vl prog
     , apps.fnd_concurrent_requests    req
     , apps.fnd_responsibility_vl    resp
     , apps.fnd_user                   usr
 WHERE (prog.user_concurrent_program_name = 'Workflow Background Process' OR
        prog.user_concurrent_program_name like 'Workflow Background Process' OR
        prog.concurrent_program_name like 'APPBCF' )
   AND prog.concurrent_program_id        = req.concurrent_program_id
   AND prog.application_id               = req.program_application_id
   AND req.responsibility_id             = resp.responsibility_id
   AND req.responsibility_application_id = resp.application_id
   AND req.requested_by                  = usr.user_id
   /* AND argument_text like '%OEO%' */
   AND req.actual_start_date > sysdate -10
 ORDER BY prog.user_concurrent_program_name
        , req.actual_start_date DESC