Hidden Methods to Query Oracle Apps Forms -- Very Useful

- Display only records where a particular column is null
- Display only records where column is greater than or less than a certain value
- Display only records where data is in certain range of value etc etc....

Press Function Key F11 to enter into query mode and Ctrl+F11 to run the query.
Hash(#) is the magic key here

Below are few examples with screenshots. As an example I have taken the FND_MESSAGE form which is available in the Application Developer responsibility.

Navigation : Application Developer-->Application-->Message
Condition1: Display all records where Number is NULL(#IS NULL)
Condition2: Display all records where Number is Not null(#IS NOT NULL)
Condition3: Display all records where Number is Greater than 2000(#>2000)
Condition4: Display all records where Number is Between 1001 and 2002(#BETWEEN 1001 and 2002)
Condition5: Display all records where Number in 1000, 2000 (#IN (1000,2000))