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