← All tables
Oracle Fusion/Technical/FND
FND_ID_FLEX_SEGMENTS
Key flexfield segment definitions — the segments of a KFF structure (e.g. the GL Accounting Flexfield) and their value sets.
Key Columns
APPLICATION_IDID_FLEX_CODEID_FLEX_NUMAPPLICATION_COLUMN_NAMESEGMENT_NUMFLEX_VALUE_SET_ID
Used In
FNDGL
Notes
ID_FLEX_CODE = 'GL#' is the Accounting Flexfield; APPLICATION_COLUMN_NAME maps SEGMENT1..30 to a business meaning.
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.