FND Design Data [Home] [Help]

Table: MSC_BOMS

Product: MSC - Advanced Supply Chain Planning
Description: This table represents the Bills Of Material of an item created at source applications.
Implementation/DBA Data: TableMSC.MSC_BOMS
Primary Key: MSC_BOMS_PK
  1. ColumnPLAN_ID
  2. ColumnSR_INSTANCE_ID
  3. ColumnBILL_SEQUENCE_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
MSC_BOMS FK Joins to TableMSC_SYSTEM_ITEMS MSC_BOMS.ASSEMBLY_ITEM_ID
MSC_BOMS.PLAN_ID
MSC_BOMS.SR_INSTANCE_ID
MSC_BOMS.ORGANIZATION_ID
TableMSC_BOM_COMPONENTS FK Joins to MSC_BOMS MSC_BOM_COMPONENTS.SR_INSTANCE_ID
MSC_BOM_COMPONENTS.BILL_SEQUENCE_ID
MSC_BOM_COMPONENTS.PLAN_ID
TableMSC_PROCESS_EFFECTIVITY FK Joins to MSC_BOMS MSC_PROCESS_EFFECTIVITY.SR_INSTANCE_ID
MSC_PROCESS_EFFECTIVITY.BILL_SEQUENCE_ID
MSC_PROCESS_EFFECTIVITY.PLAN_ID