GET THE CURRENT SQL STATEMENT RUNNING FOR A CONCURRENT REQUEST

SELECT

  A.REQUEST_ID

  , D.SID

  , D.SERIAL#

  , D.OSUSER

  , D.PROCESS

  , C.SPID

  , E.SQL_TEXT

FROM

  APPS.FND_CONCURRENT_REQUESTS A,

  APPS.FND_CONCURRENT_PROCESSES B,

  V$PROCESS C,

  V$SESSION D,

  V$SQL E

WHERE 1=1

  AND A.CONTROLLING_MANAGER = B.CONCURRENT_PROCESS_ID

  AND C.PID = B.ORACLE_PROCESS_ID

  AND B.SESSION_ID = D.AUDSID

  AND D.SQL_ADDRESS = E.ADDRESS

;