FND Design Data [Home] [Help]

Table: MRP_BOM_COMPONENTS

Product: MRP - Master Scheduling/MRP
Description: BOM and pending ECO information.
Implementation/DBA Data: TableMRP.MRP_BOM_COMPONENTS
Primary Key: MRP_BOM_COMPONENTS_PK
  1. ColumnCOMPONENT_SEQUENCE_ID
  2. ColumnINVENTORY_ITEM_ID
  3. ColumnCOMPILE_DESIGNATOR
  4. ColumnORGANIZATION_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
MRP_BOM_COMPONENTS FK Joins to TableBOM_INVENTORY_COMPONENTS MRP_BOM_COMPONENTS.COMPONENT_SEQUENCE_ID
MRP_BOM_COMPONENTS FK Joins to TableMRP_SYSTEM_ITEMS MRP_BOM_COMPONENTS.INVENTORY_ITEM_ID
MRP_BOM_COMPONENTS.ORGANIZATION_ID
MRP_BOM_COMPONENTS.COMPILE_DESIGNATOR
MRP_BOM_COMPONENTS FK Joins to TableMRP_SYSTEM_ITEMS MRP_BOM_COMPONENTS.USING_ASSEMBLY_ID
MRP_BOM_COMPONENTS.ORGANIZATION_ID
MRP_BOM_COMPONENTS.COMPILE_DESIGNATOR