1. Define custom lookup XXX_TEST_LOOKUP (Application Developer --> Lookups)
2. Define custom profile (Application Developer --> Profiles)
3. Use SQL validation:
SQL="SELECT MEANING, LOOKUP_CODE
INTO :VISIBLE_OPTION_VALUE , :PROFILE_OPTION_VALUE
FROM FND_LOOKUPS
WHERE LOOKUP_TYPE = 'XXX_TEST_LOOKUP'
ORDER BY LOOKUP_CODE"
COLUMN="Meaning(*)"
HEADING="\"Test List Of Values\"(*)"
Kommentarer