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

FND_LOOKUP_TYPES_B

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

Key Columns

LOOKUP_TYPEVIEW_APPLICATION_IDSECURITY_GROUP_IDCUSTOMIZATION_LEVEL

Child Tables

FND_LOOKUP_VALUES

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

Common Joins

FND_LOOKUP_VALUESvia LOOKUP_TYPE + VIEW_APPLICATION_ID

The individual codes and their meanings for this lookup type.

Used In

FND

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_TYPES_B