How to View SQL Statement from OAF Page

1. Verify the following Profile Option Values set to Yes at User level.
   • FND: Diagnostics
   • Personalize Self-Service Defn
2. Go to the Java OAF Page where the SQL Query executes.
3. Click on the "About this Page" link in the bottom Left Hand Side of the page.
4. Navigate to the Page Tab on the Top Left Hand Side of the page.
5. In the Business Component References Details Section (You may need to expand this
   section), Go to the View Objects Sub Section.
6. Find the Object that describes the piece of information that you want to find the query for.
7. Click on the Link. Here you can see the full Query used.