FND Design Data [Home] [Help]

Table: BOM_BILL_OF_MATERIALS

Product: BOM - Bills of Material
Description: Bills of material
Implementation/DBA Data: Not implemented in this database
Primary Key: BOM_BILL_OF_MATERIALS_PK
  1. ColumnBILL_SEQUENCE_ID
Primary Key: BOM_BILL_OF_MATERIALS_UK1
  1. ColumnASSEMBLY_ITEM_ID
  2. ColumnORGANIZATION_ID
  3. ColumnALTERNATE_BOM_DESIGNATOR
Foreign Keys
Table
Foreign Table Foreign Key Column
BOM_BILL_OF_MATERIALS FK Joins to TableMTL_SYSTEM_ITEMS_B BOM_BILL_OF_MATERIALS.ASSEMBLY_ITEM_ID
BOM_BILL_OF_MATERIALS.ORGANIZATION_ID
BOM_BILL_OF_MATERIALS FK Joins to TableENG_ENGINEERING_CHANGES BOM_BILL_OF_MATERIALS.PENDING_FROM_ECN
BOM_BILL_OF_MATERIALS.ORGANIZATION_ID
BOM_BILL_OF_MATERIALS FK Joins to TableBOM_ALTERNATE_DESIGNATORS BOM_BILL_OF_MATERIALS.ALTERNATE_BOM_DESIGNATOR
BOM_BILL_OF_MATERIALS.ORGANIZATION_ID
BOM_BILL_OF_MATERIALS FK Joins to TableBOM_BILL_OF_MATERIALS BOM_BILL_OF_MATERIALS.COMMON_BILL_SEQUENCE_ID
BOM_BILL_OF_MATERIALS FK Joins to TableMTL_SYSTEM_ITEMS_B BOM_BILL_OF_MATERIALS.COMMON_ASSEMBLY_ITEM_ID
BOM_BILL_OF_MATERIALS.COMMON_ORGANIZATION_ID
BOM_BILL_OF_MATERIALS FK Joins to TableHR_ALL_ORGANIZATION_UNITS BOM_BILL_OF_MATERIALS.ORGANIZATION_ID
TableBOM_BILL_OF_MATERIALS FK Joins to BOM_BILL_OF_MATERIALS BOM_BILL_OF_MATERIALS.COMMON_BILL_SEQUENCE_ID
TableBOM_BILL_REVISIONS_B FK Joins to BOM_BILL_OF_MATERIALS BOM_BILL_REVISIONS_B.BILL_SEQUENCE_ID
TableBOM_INVENTORY_COMPONENTS FK Joins to BOM_BILL_OF_MATERIALS BOM_INVENTORY_COMPONENTS.BILL_SEQUENCE_ID
TableSO_LINES_ALL FK Joins to BOM_BILL_OF_MATERIALS SO_LINES_ALL.COMPONENT_SEQUENCE_ID
TableSO_LINE_DETAILS FK Joins to BOM_BILL_OF_MATERIALS SO_LINE_DETAILS.COMPONENT_SEQUENCE_ID
TableWSM_CO_PRODUCTS FK Joins to BOM_BILL_OF_MATERIALS WSM_CO_PRODUCTS.BILL_SEQUENCE_ID
TableWSM_LOT_JOB_INTERFACE FK Joins to BOM_BILL_OF_MATERIALS WSM_LOT_JOB_INTERFACE.PRIMARY_ITEM_ID
WSM_LOT_JOB_INTERFACE.ORGANIZATION_ID
WSM_LOT_JOB_INTERFACE.ALTERNATE_BOM_DESIGNATOR