Long Running Requests ( SQL Script)

SQL script  Long Running Requests

set lines 130

column start_time format a15

column USER_CONCURRENT_PROGRAM_NAME format a40

select b.REQUEST_ID, a.USER_CONCURRENT_PROGRAM_NAME, b.phase_code,

       (sysdate - b.actual_start_date) * 24 "running",

       to_char(b.request_date, 'mm/dd/yyyy hh24:mi') "request_date",

       to_char(b.actual_start_date, 'mm/dd/yyyy hh24:mi') "start_time"

   from APPS.FND_CONCURRENT_PROGRAMS_VL a,

       APPS.FND_CONCURRENT_REQUESTS b

 where a.CONCURRENT_PROGRAM_ID = b.CONCURRENT_PROGRAM_ID

   and a.APPLICATION_ID = b.PROGRAM_APPLICATION_ID

   and b.STATUS_CODE = 'R'

   and b.PHASE_CODE = 'R'

   and ((sysdate - b.actual_start_date) * 24) > 4

   and a.CONCURRENT_PROGRAM_ID NOT IN(36887,43393,38121,42789,31556);