Concurrent Program session details along with SQL Query

 Concurrent Program session details along with SQL Query

1 2 3 4 5 6 7 8 9 10 11 12 13

SELECT sqlt.sql_text, sess.sid, sess.serial#, fcr.requested_start_date FROM fnd_concurrent_requests fcr , V$SQLTEXT sqlt , v$session sess WHERE fcr.request_id = :pRequestID AND fcr.phase_code = ‘R’ AND fcr.status_code = ‘R’ AND fcr.oracle_session_id = sess.audsid (+) AND sqlt.address = sess.sql_address ORDER BY sqlt.piece;