Query To Get Concurrent Request ID for a Given Oracle SID

Download(reqidfrmsid.sql)

REM +======================================================================+
REM                    
REM File Name: reqidfrmsid.sql
REM 
REM Description:
REM   Query To Get Concurrent Request ID for a Given Oracle SID
REM   
REM Notes:
REM   Usage: sqlplus "/ as sysdba" @reqidfrmsid.sql 
REM 
REM Input Required:
REM    SID : Oracle SID
REM   
REM +======================================================================+

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');