Script to find session details for a given request id

SELECT a.request_id,
       d.sid        as Oracle_SID,
       d.serial#,
       d.osuser,
       d.process,
       c.SPID       as OS_Process_ID
  FROM apps.fnd_concurrent_requests  a,
       apps.fnd_concurrent_processes b,
       gv$process                    c,
       gv$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;