Oracle Fusion/Technical/FND

FND_FLEX_VALUES_B

Flexfield / value set values — the individual valid values (e.g. cost centre codes) and their enabled state.

Key Columns

FLEX_VALUE_IDFLEX_VALUE_SET_IDFLEX_VALUEENABLED_FLAGSUMMARY_FLAG

Parent Table

FND_FLEX_VALUE_SETS

Value set definitions — validation type, format and security for a list of values used by flexfields.

Child Tables

FND_FLEX_VALUES_TL

Translated flexfield value descriptions — join to show a readable label for a segment value.

Common Joins

FND_FLEX_VALUES_TLvia FLEX_VALUE_ID + LANGUAGE

The translated description of the value.

Used In

FNDGL

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.