R12 Finding SID of a Concurrent Request

Finding SID of a Concurrent Request

select b.sid, oracle_session_id, oracle_process_id, os_process_id

from fnd_concurrent_requests a ,

v$session b

 where a.request_id=&request_id and

        a.ORACLE_SESSION_ID = b.AUDSID