Query to Find out the Current Running Concurrent Program Tracing Details

Query:

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 = 24105126

  ORDER BY SQLT.piece;