Find current running SQL for Concurrent Program

This is often times useful, to find out current running SQL of a concurrent program. Helps a lot, if you are analyzing a long running process.

Here is the SQL

SELECT C.sql_text
      ,C.module 
  FROM APPS.fnd_concurrent_requests A
      ,V$SESSION B
      ,V$SQLAREA C 
 WHERE A.oracle_session_id = B.audsid 
   AND B.sql_hash_value    = C.hash_value 
   AND A.request_id        = 6935896

.
Here is another one

SELECT SQLT.hash_value
      ,SQLT.sql_text
      ,VSES.username
      ,VSES.module
      ,VSES.command
  FROM v$sqltext                    SQLT
      ,v$session                    VSES
      ,APPS.fnd_concurrent_requests FCONC
 WHERE SQLT.hash_value         = VSES.sql_hash_value 
   AND FCONC.oracle_session_id = VSES.audsid 
   AND FCONC.request_id        = 6935896
ORDER BY SQLT.piece

.

Cheers