Hidden Methods to Query Oracle Apps Forms -- Very Useful
Here I discuss how can we query a form by giving certain query condition like
- 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
Query
Result
Condition2: Display all records where Number is not null
Query
Result
Condition3:
Display all records where Number is greater than 1905
Query
Result
Condition4:
Display all records where Number is between 1905 and 1911
Query
Result
Condition5:
Display all records where Number in 1905,1911
Query
Result
<!-- Baidu Button BEGIN -->
- 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
Query
Result
Condition2: Display all records where Number is not null
Query
Result
Condition3:
Display all records where Number is greater than 1905Query
Result
Condition4:
Display all records where Number is between 1905 and 1911Query
Result
Condition5:
Display all records where Number in 1905,1911Query
Result
source:http://sureshvaishya.blogspot.jp/2008/02/tips-to-query-oracle-apps-forms.html
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/26687597/viewspace-1204281/ ，如需转载，请注明出处，否则将追究法律责任。
