eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

Table: MSC_BOM_COMPONENTS

Product:	MSC - Advanced Supply Chain Planning
Description:	This table stores Bill of material data for plans in Oracle Advanced Planning and Oracle Supply Chain Hub products.
Implementation/DBA Data:	MSC.MSC_BOM_COMPONENTS

Primary Key: MSC_BOM_COMPONENTS_PK

PLAN_ID
COMPONENT_SEQUENCE_ID
SR_INSTANCE_ID
BILL_SEQUENCE_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
MSC_BOM_COMPONENTS	MSC_BOMS	MSC_BOM_COMPONENTS.SR_INSTANCE_ID MSC_BOM_COMPONENTS.BILL_SEQUENCE_ID MSC_BOM_COMPONENTS.PLAN_ID
MSC_BOM_COMPONENTS	MSC_SYSTEM_ITEMS	MSC_BOM_COMPONENTS.INVENTORY_ITEM_ID MSC_BOM_COMPONENTS.PLAN_ID MSC_BOM_COMPONENTS.SR_INSTANCE_ID MSC_BOM_COMPONENTS.ORGANIZATION_ID
MSC_COMPONENT_SUBSTITUTES	MSC_BOM_COMPONENTS	MSC_COMPONENT_SUBSTITUTES.BILL_SEQUENCE_ID MSC_COMPONENT_SUBSTITUTES.COMPONENT_SEQUENCE_ID MSC_COMPONENT_SUBSTITUTES.SR_INSTANCE_ID MSC_COMPONENT_SUBSTITUTES.PLAN_ID
MSC_OPERATION_COMPONENTS	MSC_BOM_COMPONENTS	MSC_OPERATION_COMPONENTS.BILL_SEQUENCE_ID MSC_OPERATION_COMPONENTS.COMPONENT_SEQUENCE_ID MSC_OPERATION_COMPONENTS.SR_INSTANCE_ID MSC_OPERATION_COMPONENTS.PLAN_ID