Friday 13 December 2019

how to find LOV query in oracle apps form

Step 1: Find the form name (.fmb name). (Help --> About Oracle Applications)
Step 2: click on List of values and enter the filter condition and click Find button.
Step 3: Keep the screen in the above state.
Step 4: Connect to database and run the below SQL Statement.

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

No comments:

Post a Comment