Searching for Records
Many modules in Oracle Sales and Marketing such as Account, Contact, and Opportunities, provide you with a Find window that you can use to enter search criteria for locating specific information. When a Find window is not available, use Query Enter and Query Run from the menu to search for information.
To use Query Enter and Query Run:
1. Open the window in which you want to search for information.
2. Choose Enter from the Query menu.
3. Enter search criteria.
You can enter search criteria in any field. You can enter specific values to find exact matches, wildcard characters % to find matches that satisfy a pattern, or use query operators to find a specific range of values. Refer to the Oracle Applications User's Guide for additional details.
4. Choose Run from the Query menu to run the query.
5. Use the up and down arrow keys to review the retrieved records.
If no records are found, try entering less restrictive search criteria.