Add LOV to a Profile

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\"(*)"