How to find Table/View Name from a Page in Oracle Apps R12

Step 1: Open a page

Step 2: Click on the 'About this Page' . You can find this at left bottom of the page

Step 3: Open the section  'Business Component References Details'

 This will show the links for the view objects relating the page

Step 4:  By clicking on the link you can get the SQL query relating to the page.


Note : To see ' About This Page'  profile option FND: Diagnostics can be set at user level .

From system administrator go to  Profile >>System .


Query for the user name and profile  'FND: Diagnostics'  Set this to YES for the user name