Oracle EBS-Forms: How to know query behind LOV

In this article, let us understand how to quickly get the query behind any list of values on Oracle Form.

Use Case Scenario:

As an example, we need to know the query behind the Nationality list of values on Employee screen.

Solution:

• Go to respective form on the Application and get the form name.

        Navigation: Help >> About Oracle Applications

• Open the respective list of values (Nationality) on the Employee Form.
• Keep the list of values screen open and run the below query on database by passing the above form name that gives the query behind the list of values that is opened currently.

            SELECT TO_CHAR(sq.sql_fulltext) 
               FROM v$session ses, 
                            v$sqlarea sq
            WHERE ses.module LIKE '%PERWSHRG%'
                  AND sq.sql_id = ses.prev_sql_id;