How to find concurrent request ID using SID in 11i/R12

 

Use below query to find the concurrent request ID using SID in oracle applications 11i/R12

SELECT s.inst_id,a.request_id,s.sid,s.serial#,c.spid
FROM apps.fnd_concurrent_requests a, gv$process c, gv$session s
WHERE s.sid in ('&SID')
AND s.paddr = c.addr
AND a.oracle_process_id = c.spid
AND a.phase_code = UPPER ('R');

Thanks for going through the post..................