Overview of Query Find

There are two implementations for Query Find (also known as View Find). One implementation shows a Row-LOV that shows the available rows and allows you to choose one. The other implementation opens a Find window, which shows you the fields the user is likely to want to use for selecting data.

Use only one implementation for a given block. All queryable blocks within your form should support Query Find. The Oracle Applications User Interface Standards for Forms-Based Products describe what situations are better served by the two implementations.

Raising Query Find on Form Startup

If you want a Row-LOV or Find window to raise immediately upon entering the form, at the end of your WHEN-NEW-FORM- INSTANCE trigger, call:

EXECUTE_TRIGGER('QUERY_FIND'); 

This will simulate the user invoking the function while in the first block of the form.