the query related to a form

平安是福mtl (2009-02-25 15:16:36) 评论 (1)

To find the query related to fields in a form,

Menu: Help -> Diagnostics -> Examine

In the pop up window, choose Block: SYSTEM, Field: LAST_QUERY, the query will be displayed in Value section.

We can also find values for Environment variables and Profile variables. For example:

Block: $ENVIRONMENT$, Field: FND_TOP, return value: /u03/oracle/sit/sitappl/fnd/11.5.0

Block: $PROFILES$, Field: ORG_ID, return value: 1072.