Creating Named LOVs at the Application Level |
 Previous |
 Next |
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:
-
On the Database Home Page, click the Application Builder icon.
-
Select an application.
The Application home page appears.
-
Click the Shared Components icon.
-
Under User Interface, select Lists of Values.
-
To create a new LOV, click Create.
-
Follow the on-screen instructions.
New named LOVs are added to the List of Values repository.
About the List of Values Page
Once you create a LOV, it appears on the List of Values page. You control how the page displays by making a selection from the View list. Available options include:
-
Icons (the default) displays each LOV as a large icon. To edit a LOV, click the appropriate icon.
-
Details displays each LOV as a line in a report. To edit a LOV, click the name.