How to know the concurrent request details using Request id in oracle apps R12

Below script to find the concurrent request details using Request Id.

Script:

set head off
set verify off
set echo off
set pages 1500
set linesize 100
set lines 120
prompt
prompt Request_ID
prompt ==================================
select /*+ CHOOSE*/
'Session  Id.............................................: '||s.sid,
'Serial Num..............................................: '||s.serial#,
'User Name ..............................................: '||s.username,
'Session Status .........................................: '||s.status,
'Client Process Id on Client Machine ....................: '||'*'||s.process||'*'  Client,
'Server Process ID ......................................: '||p.spid Server,
'Sql_Address ............................................: '||s.sql_address,
'Sql_hash_value .........................................: '||s.sql_hash_value,
'Schema Name ..... ......................................: '||s.SCHEMANAME,
'Program  ...............................................: '||s.program,
'Module .................................................: '|| s.module,
'Action .................................................: '||s.action,
'Terminal ...............................................: '||s.terminal,
'Client Machine .........................................: '||s.machine,
'LAST_CALL_ET ...........................................: '||s.last_call_et,
'S.LAST_CALL_ET/3600 ....................................: '||s.last_call_et/3600,
'E.SQL_TEXT .............................................: '||E.SQL_TEXT
from v$session s, v$process p, V$SQL E
where p.addr=s.paddr AND s.SQL_ADDRESS = E.ADDRESS and
s.sid in (SELECT d.sid FROM apps.fnd_concurrent_requests a,
apps.fnd_concurrent_processes b, v$process c,v$session d
WHERE a.controlling_manager = b.concurrent_process_id
AND c.pid = b.oracle_process_id
AND b.session_id=d.audsid
AND a.request_id = &Request_ID);

Output:


Enter value for request_id: 31321705

Session  Id.............................................: 2289
Serial Num..............................................: 8075
User Name ..............................................: APPS
Session Status .........................................: ACTIVE
Client Process Id on Client Machine ....................: *57551*
Server Process ID ......................................: 4203
Sql_Address ............................................: 00000006B1BC9010
Sql_hash_value .........................................: 3255635558
Schema Name ..... ......................................: APPS
Program  ...............................................: STANDARD@erpappsp1 (TNS V1-V3)
Module .................................................: CSICORSY
Action .................................................: Concurrent Request
Terminal ...............................................:
Client Machine .........................................: erpappsp1
LAST_CALL_ET ...........................................: 287646
S.LAST_CALL_ET/3600 ....................................: 79.9016666666666666666666666666666666667
E.SQL_TEXT .............................................: BEGIN CSI_DIAGNOSTICS_PKG.IB_SYNC(:errbuf,:rc,:A0,:A1,:A2); EN

D;