Using the Add Parameter dialog (queryparm)

To prompt the user for a parameter value, check Prompt the user for a value. AQT will add a queryparm command to your query.

Display Name is the name of the parameter on the parameter prompt
Prompt user with has a number of options for how the user will be prompted. One of these is List of values, where the user is prompted with a dropdown list of values to choose from.
Select from list can either be a fixed list of values, or a query to fetch the values from the database.
IDParm. In this example, the Select from list query returns two columns. The first column is the value displayed in the dropdown list. When the user selects a value from the list, the parameter (depart) is set the selected value; the IDParm parameter (deptno) is set to the second column from the query.
This is useful for displaying a list of "meaningful" values to the user, yet passing an internal value to the query.

parms4

When the query is run, the user will prompted as per the following screenshot.

parms5

Advanced Query Tool