Concurrent Request History Info

Concurrent Requests history:

alter session set NLS_DATE_FORMAT = 'DD-MON-YY HH24:MI';

select REQUESTOR,REQUEST_ID,ACTUAL_START_DATE,ACTUAL_COMPLETION_DATE,(ACTUAL_COMPLETION_DATE-ACTUAL_START_DATE)*24*60 time,USER_CONCURRENT_PROGRAM_NAME,PHASE_CODE,STATUS_CODE from apps.fnd_conc_req_summary_v
where ACTUAL_START_DATE >= '27-APR-2012 01:00'
and  ACTUAL_START_DATE <= '27-APR-2012 04:00'
order by ACTUAL_START_DATE asc

select REQUESTOR,count(1) from apps.fnd_conc_req_summary_v  
where ACTUAL_START_DATE >= '27-APR-2012 01:00'  
and  ACTUAL_START_DATE <= '27-APR-2012 04:00'  
group by REQUESTOR


select REQUESTOR,USER_CONCURRENT_PROGRAM_NAME,ARGUMENT_TEXT from apps.fnd_conc_req_summary_v  
where ACTUAL_START_DATE >= '27-APR-2012 01:00'  
and  ACTUAL_START_DATE <= '27-APR-2012 04:00'
order by REQUESTOR

UR's Key Run ;-)