To know the Query Behind the LOV in Oracle Apps

To know the Query Behind the LOV in Oracle Apps

SELECT client_identifier,
       ses.module,
       (SELECT TO_CHAR (sql_fulltext)
          FROM v$sqlarea
         WHERE sql_id = ses.prev_sql_id AND ROWNUM = 1)
  FROM v$session ses, v$sqlarea sq
 WHERE     1 = 1
       AND ses.module LIKE '%Here you need to give the Form Name%'
       AND client_identifier = 'Giver the Oracle User Name Here'
       AND sq.sql_id(+) = ses.sql_id;

Comments

Popular posts from this blog

Deleting the Sourcing Rule Assignments API

BarCode with XML Publisher