Monday, 20 July 2026

How can I find the LOV query behind an Oracle Forms List of Values (LOV)?

Example: 


I want to find the Leaving reason LOV Query. 

Step1: 

    Go to Help --> About Oracle Application --> Find the Form Name

Step2: 

    Open the Leaving reason LOV as shown from the above screenshot. 

Step3:

    Run the Below Query:

        SELECT TO_CHAR(sq.sql_fulltext) AS perwstem_lov_query

FROM v$session ses, 

     v$sqlarea sq

WHERE ses.module LIKE '%PERWSTEM%' -- Form Name

 --AND ses.client_identifier = '&your_ebs_username'

  AND sq.sql_id = ses.prev_sql_id;


Result: 

  select meaning ,lookup_code from hr_leg_lookups where lookup_type = 'LEAV_REAS' and enabled_flag = 'Y' and :1 between nvl(start_date_active, :2) and nvl(end_date_active, :3) order by meaning

No comments:

Post a Comment