Select request_id,oracle_process_id,phase_code,status_code from
apps.fnd_concurrent_requests where status_code=’R’
where request_id in(Request_ID #1,Request_ID #2,Request_ID #3);select r.request_id,
r.oracle_process_id spid,
r.oracle_session_id,s.inst_id,
r.os_process_id process,
s.sid,
s.serial#,
s.status,to_char(logon_time,’YYYYMMDD HH24:MI:SS’) time,s.program,s.sql_address,
s.paddr
from apps.fnd_concurrent_requests r,
gv$session s
where r.request_id =31082866
and r.oracle_session_id = s.audsid(+);
Thank you
Osama Mustafa