SELECT vp.spid,
vs.sid,
fcr.request_id
FROM v$process vp,
v$session vs,
fnd_Concurrent_requests fcr
WHERE vs.paddr = vp.addr
AND fcr.oracle_process_id = vp.spid
AND vs.sid = :l_sid
vs.sid,
fcr.request_id
FROM v$process vp,
v$session vs,
fnd_Concurrent_requests fcr
WHERE vs.paddr = vp.addr
AND fcr.oracle_process_id = vp.spid
AND vs.sid = :l_sid
No comments:
Post a Comment