Oracle Applications

Query to check session details of a HOST Concurrent request

SELECT a.request_id, d.sid, d.serial#, d.osuser, d.process, b.session_id, c.SPID  
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  
AND a.phase_code = 'R';

========================================================================