The other day I was asked to find all the supplier sites that are that have the “Transportation Arranged” option set to “Buying Organization”. Normally, I would do a query in a form and then use the Examine feature to find the query. But in R12, the suppliers are now in web pages. It seemed my old trick would work in Oracle’s new OA framework. But luckily, Oracle has the same functionality in the “About this Page” link. If you want to find the SQL query behind any web page, you need to enable personalization and then use “About this Page” to find the view object. Below is an example using Supplier sites:
Step 1: Enable the personalization profile
a) Under the system admin responsibility, open the system profiles form
b) Change the “Personalize Self-Service Defn” profile to yes for your responsibility
Step 2: Perform the business process as you would normally do.
a) Using the Payables Manager responsibility, open the Suppliers web page
b) Find your supplier
c) Click the Purchasing link
d) Click the Freight tab
Step 3: Click the About the Page link
Step 4: Click the Page tab and then click the Expand button on the business components section
Step 5: Find you view object and click the link
Step 6: Select the SQL query and copy it to your favorite SQL tool (TOAD, SQL Developer,..)
Step 7: Replace and variables (anything that has a colon in front of it) with your data and test the query
Step 8: Modify the query to fit your needs.