Create and Edit Table-Validated Value Sets Based on Lookups

While creating and editing value sets, use a predefined list of values that are stored in an application table.

You can specify which table you want to use, along with a WHERE clause to limit the values you want to use for your set. For example, let's use the FND_LOOKUPS view as the basis for a table-validated value set. The lookup meaning corresponds to the Value Column Name field and the lookup description corresponds to the Description Column Name field.

Create a Value Set Based on a Lookup

1. In the Setup and Maintenance work area, go to the Manage Value Sets task.

2. On the Manage Value Sets page, click the Create icon.

3. On the Create Value Set page, enter these values:

   Field	Value
   Value Set Code	SAMPLE_VALUE_SET_CODE
   Description	Sample lookup-based table validated value set
   Module	Oracle Middleware Extensions for Applications
   Validation Type	Table
   Value Data Type	Character

4. In the Definition section, enter these values:

   Field	Value
   FROM Clause	FND_LOOKUPS
   Value Column Name	Meaning
   Description Column Name	Description
   Start Date Column Name	start_date_active
   End Date Column Name	end_date_active
   Enabled Flag Column Name	'Y'
   ID Column Name	lookup_code
   WHERE Clause	lookup_type = 'SAMPLE_LOOKUP_TYPE'
   ORDER BY Clause	display_sequence, meaning

5. Click Save and Close.

Edit a Value Set Based on a Lookup

1. In the Setup and Maintenance work area, go to the Manage Value Sets task.

2. On the Manage Value Sets page, use the Search text field to search for a value set.

3. Select a value set and click the Edit icon.

4. On the Edit Value Set page, modify the existing values.

5. Click Save and Close.