— check currently running requests

SELECT a.request_id, d.sid, d.serial# ,d.osuser,d.process , c.SPID
 FROM apps.fnd_concurrent_requests a,
 apps.fnd_concurrent_processes b,
 v$process c,
 v$session d
 WHERE a.controlling_manager = b.concurrent_process_id
 AND c.pid = b.oracle_process_id
 AND b.session_id=d.audsid
 AND a.phase_code = ‘R’
AND a.request_id in (SELECT r.request_id
 FROM applsys.fnd_concurrent_requests r,
 applsys.fnd_concurrent_queues_tl qt,
 applsys.fnd_concurrent_queues q,
 applsys.fnd_concurrent_processes p,
 v$session s
 WHERE r.controlling_manager=p.concurrent_process_id
 AND q.application_id=p.queue_application_id
 AND q.concurrent_queue_id=p.concurrent_queue_id
 AND qt.application_id=q.application_id
 AND qt.concurrent_queue_id=q.concurrent_queue_id
 AND r.phase_code=’R’
AND qt.language in (‘US’)
AND p.session_id=s.audsid)
 /