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;
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
Post a Comment