find the details of concurrent requests from request id

set linesize 900
column RESPONSIBILITY_NAME format a30
column USER_CONCURRENT_PROGRAM_NAME format a30
column MACHINE  format a10
column REQUESTOR format a15

select cmp.USER_CONCURRENT_PROGRAM_NAME ,cm.request_id,
(select user_name from apps.fnd_user where USER_ID =cm.requested_by) Requestor, PARENT_REQUEST_ID,t.USED_UREC,t.USED_UBLK,cm.phase_code,
cm.status_code,s.sid,s.serial#,s.saddr,s.username,s.status, s.OSUSER,s.PROCESS,
s.MODULE,s.ACTION,fr.RESPONSIBILITY_NAME
from v$transaction t,v$session s,apps.FND_CONCURRENT_REQUESTS cm,
apps.FND_RESPONSIBILITY_VL fr,
apps.FND_CONCURRENT_PROGRAMS_VL cmp
where t.addr(+)=s.taddr and s.process(+)=cm.os_process_id
AND fr.RESPONSIBILITY_ID= cm.RESPONSIBILITY_ID
AND cmp.CONCURRENT_PROGRAM_ID=cm.CONCURRENT_PROGRAM_ID
and cm.request_id=&reqid
/