Case insensitive query in Oracle Apps
|This is response to a question posted by a comment in Article..Why Is it Called Apps|
Click on the field in question, and click on Help/Diagnostic/Properties/Item
In the property field, select case insensitive query
If the value is TRUE, then you will know that Case Insensitive Query is possible on this field.