Query To Get Oracle SID Details for a Given Concurrent Request ID

Download(sidfrmreqid.sql)

REM +======================================================================+
REM                    
REM File Name: sidfrmreqid.sql
REM 
REM Description:
REM   Query To Get Oracle SID Details for a Given Concurrent Request ID
REM   
REM Notes:
REM   Usage: sqlplus "/ as sysdba" @sidfrmreqid.sql 
REM 
REM Input Required:
REM    REQID : Concurrent Request ID
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 a.request_id in ('&REQID')
   AND s.paddr = c.addr
         AND a.oracle_process_id = c.spid
         AND a.phase_code = UPPER ('R');