Concurrent request details

set line 300
set pages 200
select r.request_id, s.inst_id,s.sid, s.serial#, s.status,
 substr(r.oracle_process_id, 1, 13) "REQUEST OS",
 r.status_code,r.phase_code, substr(fp.OS_PROCESS_ID, 1, 13) "CM OS ID"
from apps.fnd_concurrent_requests r,
 apps.fnd_concurrent_processes fp,
 gv$session s,
 gv$process p
where r.controlling_manager = fp.concurrent_process_id and
 r.oracle_process_id = p.spid and
 s.inst_id = p.inst_id and
 p.addr = s.paddr and
 r.request_id in (&reqid) order by r.request_id;