I'm working on R12 customers modules. For few fields like Tax details , I would like to know the base table for the fields in the screen. I know how to see in the Oracle forms.
Can anyone let me know how to see in R12?
Atlast found a way to know the base table information.
Enable the Profile
FND: Diagnostics - Yes
Go to the Customer Screen.
You will see an Diagnostics at the Bottom of the page
Choose that Select - Show Log - > Select
This will show the log of each page. From there you can find the query that is used for that Page.