A script-enabled browser is required for this page to function properly.

Specifying LOV Return Items Using Column Properties

To specify an LOV return item:

  1. Select the LOV in the Object Navigator.
  2. Select Tools | LOV Wizard.
  3. Click the Column Display tab at the top of the Wizard.
  4. All columns in the LOV are Listed in the table. Change the Return Value for the column to the name of the desired return item. You can use the Look up return item button to help you find the correct return item for the column.

or

  1. In the Object Navigator LOVs node, double-click the object icon beside the desired LOV to display the Property Palette.
  2. Under the Functional node, double-click on Column Mapping Properties. The LOV Column Mapping dialog appears.
  3. Select the desired column in the Column Names List.
  4. In the Return Item field, enter a name (item, global variable, or parameter).

 Tip: If you do not want a column to be returned, leave the Return Item property blank.


Specifying LOV return items in the SELECT statement

LOV Wizard: Column Display page