Untitled

Query for Scheduled request start on prior run less than 5 mins

select cs.request_id,cs.concurrent_program_id,cs.program,cs.argument_text,cr.resubmit_interval_type_code,cs.requestor,resubmit_interval,resubmit_interval_unit_code from fnd_concurrent_requests cr,fnd_conc_req_summary_v cs where
 cs.phase_code=’P’
and cs.status_code in (‘I’,’Q’)
and
resubmit_interval_type_code=’START’ and cr.request_id=cs.request_id
and resubmit_interval_unit_code=’MINUTES’ and resubmit_interval<5