Skip to main content
OracleOps AI
← All tables
Oracle Fusion/Technical/FND

FND_LOOKUP_VALUES

Lookup values — the code, meaning and description rows behind every lookup type, per language.

Key Columns

LOOKUP_TYPELOOKUP_CODEMEANINGENABLED_FLAGLANGUAGEVIEW_APPLICATION_ID

Parent Table

FND_LOOKUP_TYPES_B

Lookup type headers — the code list definitions (e.g. YES_NO, INVOICE_TYPE) that group lookup values.

Used In

FND

Notes

Filter LANGUAGE = USERENV('LANG') and ENABLED_FLAG = 'Y' plus the active date range.

Related

Lookups, value sets and flexfields

Code lists are lookup types (FND_LOOKUP_TYPES_B) and values (FND_LOOKUP_VALUES). Flexfield lists of values are value sets (FND_FLEX_VALUE_SETS) with values in FND_FLEX_VALUES_B / _TL. KFF segments are defined in FND_ID_FLEX_SEGMENTS and DFF segments in FND_DESCR_FLEX_COLUMN_USAGES.

Ask Oracle AI about FND_LOOKUP_VALUES