Oracle EBS Forms: How to know query behind LOV

 Find the SQL behind List of Values(LOV) of an EBS Form:

Step1 : Find the name of the form. (Help -> About Oracle Applications)

Step2 : Invoke the List of values. Enter the filter condition and Click Find Button.

Step3 : Keep the screen in the above state. Open the database session connecting to APPS schema and execute the below SQL.

SELECT (SELECT To_char (sql_fulltext)
        FROM   v$sqlarea
        WHERE  sql_id = ses.prev_sql_id) sql_behind_lov
FROM   v$session ses,
       v$sqlarea sq
WHERE  ses.MODULE LIKE '%&form_name%'
       AND client_identifier = '&user_name'
       AND sq.sql_id (+) = ses.sql_id;