REM
REM DBAToolZ NOTE:
REM	This script was obtained from DBAToolZ.com
REM	It's configured to work with SQL Directory (SQLDIR).
REM	SQLDIR is a utility that allows easy organization and
REM	execution of SQL*Plus scripts using user-friendly menu.
REM	Visit DBAToolZ.com for more details and free SQL scripts.
REM
REM
REM File:
REM     a_conc_reqd.sql
REM
REM <SQLDIR_GRP>APPS_CONC_MAN</SQLDIR_GRP>
REM
REM Author:
REM     Vitaliy Mogilevskiy (vit100gain@earthlink.net)
REM
REM Purpose:
REM     <SQLDIR_TXT>
REM     Prints concurrent request ID, ORA_PID, ORA_SID
REM	log and output files for a given APPS REQid
REM     </SQLDIR_TXT>
REM
REM Usage:
REM     a_conc_reqd.sql
REM
REM Example:
REM     a_conc_reqd.sql
REM
REM
REM History:
REM     10-18-2001      VMOGILEV        Created
REM
REM

select /*+ ORDERED */
       req.request_id
,      req.oracle_process_id
,      ses.sid
,      ses.serial#
,      ses.program
,      req.logfile_name log
,      req.outfile_name out
from  v$process pid
,     v$session ses
--,     apps.fnd_concurrent_processes prc
,     apps.FND_CONCURRENT_REQUESTS req
where req.request_id = &request_id
--and   req.controlling_manager = prc.concurrent_process_id
--and   prc.CONCURRENT_QUEUE_ID = q_id
--and   req.oracle_process_id IS NOT NULL
and   req.oracle_process_id = pid.spid(+)
and   pid.addr = ses.paddr(+)
/