Query to find concurrent request ID using SID in R12

 Query to find concurrent request ID using SID in 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');