FND Design Data [Home] [Help]

Table: FND_ID_FLEX_SEGMENTS

Product: FND - Application Object Library
Description: Key flexfield segments setup information and correspondences between table columns and key flexfield segments
Implementation/DBA Data: TableAPPLSYS.FND_ID_FLEX_SEGMENTS
Primary Key: FND_ID_FLEX_SEGMENTS_PK
  1. ColumnAPPLICATION_ID
  2. ColumnID_FLEX_CODE
  3. ColumnID_FLEX_NUM
  4. ColumnAPPLICATION_COLUMN_NAME
Primary Key: FND_ID_FLEX_SEGMENTS_UK2
  1. ColumnAPPLICATION_ID
  2. ColumnID_FLEX_CODE
  3. ColumnID_FLEX_NUM
  4. ColumnSEGMENT_NAME
Foreign Keys
Table
Foreign Table Foreign Key Column
FND_ID_FLEX_SEGMENTS FK Joins to TableFND_ID_FLEX_STRUCTURES FND_ID_FLEX_SEGMENTS.APPLICATION_ID
FND_ID_FLEX_SEGMENTS.ID_FLEX_CODE
FND_ID_FLEX_SEGMENTS.ID_FLEX_NUM
FND_ID_FLEX_SEGMENTS FK Joins to TableFND_FLEX_VALUE_SETS FND_ID_FLEX_SEGMENTS.FLEX_VALUE_SET_ID
TableFND_FLEXBUILDER_PARAMETERS FK Joins to FND_ID_FLEX_SEGMENTS FND_FLEXBUILDER_PARAMETERS.FLEXFIELD_APPLICATION_ID
FND_FLEXBUILDER_PARAMETERS.ID_FLEX_CODE
FND_FLEXBUILDER_PARAMETERS.ID_FLEX_NUM
FND_FLEXBUILDER_PARAMETERS.APPLICATION_COLUMN_NAME
TableFND_FLEX_VALIDATION_RULES FK Joins to FND_ID_FLEX_SEGMENTS FND_FLEX_VALIDATION_RULES.APPLICATION_ID
FND_FLEX_VALIDATION_RULES.ID_FLEX_CODE
FND_FLEX_VALIDATION_RULES.ID_FLEX_NUM
FND_FLEX_VALIDATION_RULES.ERROR_SEGMENT_COLUMN_NAME
TableFND_ID_FLEX_SEGMENTS_TL FK Joins to FND_ID_FLEX_SEGMENTS FND_ID_FLEX_SEGMENTS_TL.APPLICATION_ID
FND_ID_FLEX_SEGMENTS_TL.ID_FLEX_CODE
FND_ID_FLEX_SEGMENTS_TL.ID_FLEX_NUM
FND_ID_FLEX_SEGMENTS_TL.APPLICATION_COLUMN_NAME
TableFND_SEGMENT_ATTRIBUTE_VALUES FK Joins to FND_ID_FLEX_SEGMENTS FND_SEGMENT_ATTRIBUTE_VALUES.APPLICATION_ID
FND_SEGMENT_ATTRIBUTE_VALUES.ID_FLEX_CODE
FND_SEGMENT_ATTRIBUTE_VALUES.ID_FLEX_NUM
FND_SEGMENT_ATTRIBUTE_VALUES.APPLICATION_COLUMN_NAME