Query to get long(current) Running SQL statement of Request in Oracle Applications:

 Query to get long(current) Running SQL statement of  Concurrent Request in Oracle Applications:

You need to pass request id for below SQL

SELECT sql_text, sql_fulltext
  FROM v$sqlarea
 WHERE sql_id =
          (SELECT b.sql_id
             FROM v$process a, v$session b
            WHERE     a.addr = b.paddr
                  AND a.spid = (SELECT oracle_process_id
                                  FROM fnd_concurrent_requests
                                 WHERE request_id = &concurrent_request_id));