Introduction:
In oracle E-Business Suite it’s a common task to find an lov query. today we’ll tell you how to find SQL query behind LOV in oracle apps r12.
There are two V$ views in oracle (v$sqlarea, v$session) available to find what happens in the database session. and one of the most benefits is to find a query of LOV that is currently opened by particular user.
Goal:
getting the query behind opened oracle forms LOV
Form:
We have used miscellaneous transactions form & Sub inventory field to find list of values query
Steps:
Step 1:
Finding the name of target form. You can find the form name by navigating to menu –> About Oracle Applications.
Step 2:
Open the list of values in our case here is sub inventory field LOV. Make sure that the LOV has more than one value inside and the values has been displayed as follows:
Step 3:
Just hold on and keep the LOV opened, then open a database session from SQL Developer Or Toad and execute the query below after passing a propeate parameter to it:
SELECT to_char (sq.sql_fulltext)
FROM v$session ses, v$sqlarea sq
WHERE ses.module LIKE '%INVTTMTX%'
AND sq.sql_id = ses.prev_sql_id;In this article, we have demonstrated how to find SQL query behind oracle forms LOV in oracle apps r12 .
Hopefully, it was clear and concise.
[convertkit form=1415728]
Thank you for sharing your knowledge
Hi all, here every one is sharing these kinds of knowledge,
therefore it’s pleasant to read this weblog, and I used to go to see this website everyday.