FND Design Data [Home] [Help]

Table: BOM_INVENTORY_COMPONENTS

Product: BOM - Bills of Material
Description: Bill of material components
Implementation/DBA Data: Not implemented in this database
Primary Key: BOM_INVENTORY_COMPONENTS_PK
  1. ColumnCOMPONENT_SEQUENCE_ID
Primary Key: BOM_INVENTORY_COMPONENTS_UK1
  1. ColumnBILL_SEQUENCE_ID
  2. ColumnCOMPONENT_ITEM_ID
  3. ColumnEFFECTIVITY_DATE
  4. ColumnOPERATION_SEQ_NUM
Foreign Keys
Table
Foreign Table Foreign Key Column
BOM_INVENTORY_COMPONENTS FK Joins to TableENG_REVISED_ITEMS BOM_INVENTORY_COMPONENTS.REVISED_ITEM_SEQUENCE_ID
BOM_INVENTORY_COMPONENTS FK Joins to TableBOM_BILL_OF_MATERIALS BOM_INVENTORY_COMPONENTS.BILL_SEQUENCE_ID
BOM_INVENTORY_COMPONENTS FK Joins to TableBOM_INVENTORY_COMPONENTS BOM_INVENTORY_COMPONENTS.OLD_COMPONENT_SEQUENCE_ID
TableBOM_INVENTORY_COMPONENTS FK Joins to BOM_INVENTORY_COMPONENTS BOM_INVENTORY_COMPONENTS.OLD_COMPONENT_SEQUENCE_ID
TableMRP_BOM_COMPONENTS FK Joins to BOM_INVENTORY_COMPONENTS MRP_BOM_COMPONENTS.COMPONENT_SEQUENCE_ID
TableSO_LINES_ALL FK Joins to BOM_INVENTORY_COMPONENTS SO_LINES_ALL.COMPONENT_SEQUENCE_ID
TableSO_LINE_DETAILS FK Joins to BOM_INVENTORY_COMPONENTS SO_LINE_DETAILS.COMPONENT_SEQUENCE_ID
TableWSM_CO_PRODUCTS FK Joins to BOM_INVENTORY_COMPONENTS WSM_CO_PRODUCTS.COMPONENT_SEQUENCE_ID