Concurrent Program session details along with SQL Query

Concurrent Program session details along with SQL Query

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;