ORACLE

ORACLE
Let us share our knowledge to the world of oracle apps. I am trying my best to do so and I request every one to contribute their part. If you have any thing useful related to oracle apps, do send me I will post in my blog on behalf of you. If you like my blog tell the world about it, else tell me i will improve. You can suggest me, what exactly you want on oracle apps. Mail your queries.

Wednesday, June 6, 2012

How to get the queries behind a form

To find the form's last executed query
     Go to the menu Help >> Diagnostics >> Examine, Provide the examine password
                    Enter Block: SYSTEM
                    Enter Item: LAST_QUERY
     The value field contains the last query executed by the form




To find the query last executed in a block
1.                              Go to the field on the form with the value you want
2.                              Go to the menu Help >> Diagnostics >> Examine
3.                              Make a note of the block
4.                              Go to the menu Help >> Diagnostics >> Properties >> Item
5.                              Choose Object: Block
6.                              Choose Object 1: <the name of the block noted above>
7.                              Choose Property: Last_query
.  The value field contains the last query executed by the form

No comments:

Post a Comment