If the request contains multiple sql statements, It gives the current sql statement that

If the request contains multiple sql statements, It gives the current sql statement that

Modules Involved : Application Object Library (AOL)
Purpose             : This SQL gives the current sql statement that the request is processing
Description        : If the request contains multiple sql statements, It gives the current sql statement that
                            the request is processing.
                            Needs one parmeter (Request_ID)
****************************************************************** */
SELECT r.request_id,
sq.sql_text,
ss.SID,
ss.SERIAL#
FROM fnd_concurrent_requests r,
v$process p,
v$session ss,
V$SQLAREA sq
WHERE r.request_id IN (:Request_ID)
AND p.spid = r.oracle_process_id
AND ss.paddr = p.addr
AND sq.ADDRESS = ss.SQL_ADDRESS;