FND Design Data [Home] [Help]

Table: MSC_PROCESS_EFFECTIVITY

Product: MSC - Advanced Supply Chain Planning
Description: This table stores links between the bill of material and routings and store effectivities for this process.
Implementation/DBA Data: TableMSC.MSC_PROCESS_EFFECTIVITY
Primary Key: MSC_PROCESS_EFFECTIVITY_PK
  1. ColumnPLAN_ID
  2. ColumnPROCESS_SEQUENCE_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
MSC_PROCESS_EFFECTIVITY FK Joins to TableMSC_BOMS MSC_PROCESS_EFFECTIVITY.SR_INSTANCE_ID
MSC_PROCESS_EFFECTIVITY.BILL_SEQUENCE_ID
MSC_PROCESS_EFFECTIVITY.PLAN_ID
MSC_PROCESS_EFFECTIVITY FK Joins to TableMSC_ROUTINGS MSC_PROCESS_EFFECTIVITY.PLAN_ID
MSC_PROCESS_EFFECTIVITY.ROUTING_SEQUENCE_ID
MSC_PROCESS_EFFECTIVITY.SR_INSTANCE_ID
MSC_PROCESS_EFFECTIVITY FK Joins to TableMSC_SYSTEM_ITEMS MSC_PROCESS_EFFECTIVITY.ITEM_ID
MSC_PROCESS_EFFECTIVITY.PLAN_ID
MSC_PROCESS_EFFECTIVITY.SR_INSTANCE_ID
MSC_PROCESS_EFFECTIVITY.ORGANIZATION_ID