— Find the SID for the running queries

SELECT v.user_name “USER_NAME”,r.request_id “Request ID”, u.USER_CONCURRENT_PROGRAM_NAME “USER_CONCURRENT_PROGRAM_NAME”,
s.sid “Session ID”
FROM applsys.fnd_concurrent_requests r,
 applsys.fnd_concurrent_queues_tl qt,
 applsys.fnd_concurrent_queues q,
 applsys.fnd_concurrent_processes p,
 apps.fnd_concurrent_programs_vl u,
 applsys.fnd_user v,
 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
 AND u.CONCURRENT_PROGRAM_ID=r.CONCURRENT_PROGRAM_ID
 AND v.user_id=r.REQUESTED_BY
 /