Concurrent programs run within last 24 hours
– This displays concurrent programs run within last 24 hours excluding sysadmin.
– Bobby A.
– 17-Mar-07
– con_prg_last_24hours.sql
Concurrent programs run within for last 24 hours excluding sysadmin.
idbasolutions.com Apr 2008
set linesize 130
column PROGRAM format a37
column REQUESTOR format a15
column duration format a15
select REQUEST_ID,REQUESTOR,
to_char(ACTUAL_START_DATE,’hh24:mi dd-mon-yy’) started,
to_char(ACTUAL_COMPLETION_DATE,’hh24:mi dd-mon-yy’) completed,
to_char(((((ACTUAL_COMPLETION_DATE-ACTUAL_START_DATE)*24*60*60)/60)/60),’99D99′) duration,
PROGRAM
from FND_CONC_REQ_SUMMARY_V,dual
where PHASE_CODE=’C’
and REQUESTOR <> ‘SYSADMIN’
and to_date(ACTUAL_COMPLETION_DATE) between to_date(sysdate-1) and to_date(SYSDATE)
order by 5 desc
/