Creating a Named LOV at the Application Level

You define named (or shared) LOVs at the application level by running the Create LOV Wizard and adding them to the List of Values repository. All LOVs can be defined as static or dynamic. Static lists are based on predefined pairs of display values and return values. Dynamic lists are based on a SQL query you write that selects values from a table.

To create a named LOV:

1. On the Workspace home page, click the Application Builder icon.

2. Select an application.

   The Application home page appears.

3. Click the Shared Components icon.

4. Under User Interface, select Lists of Values.

   The Lists of Values page appears.

5. To create a new LOV, click Create.

6. Follow the on-screen instructions.

   New named LOVs are added to the List of Values repository. Note to add the LOV to a page you must edit the appropriate item or column and select the named LOV.

About the List of Values Page

Once you create an LOV, it appears on the List of Values page.

Description of the illustration lov_page.gif

Use the Navigation bar at the top of the page to search for a LOV by name or change the page display. For example, you can change the default display by making a selection from View list. Available options include:

• Icons (the default) displays each LOV as a large icon. To edit an LOV, click the appropriate icon.

• Details displays each LOV as a line in a report. To edit an LOV, click the name.