Table: MSC_PLAN_ORGANIZATIONS

Product:	MSC - Advanced Supply Chain Planning
Description:	This table stores the parameters relative to organizations that participate to the plan in Oracle Advanced Planning and Scheduling (APS). This table also contains the different companies which are collaborating in a supply or demand plan in
Implementation/DBA Data:	MSC.MSC_PLAN_ORGANIZATIONS

Primary Key: MSC_PLAN_ORGANIZATIONS_PK

1. SR_INSTANCE_ID
2. PLAN_ID
3. ORGANIZATION_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
MSC_PLAN_ORGANIZATIONS		MSC_PARAMETERS	MSC_PLAN_ORGANIZATIONS.ORGANIZATION_ID MSC_PLAN_ORGANIZATIONS.SR_INSTANCE_ID
MSC_PLAN_ORGANIZATIONS		MSC_PLANS	MSC_PLAN_ORGANIZATIONS.PLAN_ID
MSC_BILL_OF_RESOURCES		MSC_PLAN_ORGANIZATIONS	MSC_BILL_OF_RESOURCES.PLAN_ID MSC_BILL_OF_RESOURCES.ORGANIZATION_ID MSC_BILL_OF_RESOURCES.SR_INSTANCE_ID
MSC_DEPARTMENT_RESOURCES		MSC_PLAN_ORGANIZATIONS	MSC_DEPARTMENT_RESOURCES.PLAN_ID MSC_DEPARTMENT_RESOURCES.ORGANIZATION_ID MSC_DEPARTMENT_RESOURCES.SR_INSTANCE_ID
MSC_PLAN_BUCKETS		MSC_PLAN_ORGANIZATIONS	MSC_PLAN_BUCKETS.PLAN_ID MSC_PLAN_BUCKETS.ORGANIZATION_ID MSC_PLAN_BUCKETS.SR_INSTANCE_ID
MSC_PLAN_ORG_KPIS		MSC_PLAN_ORGANIZATIONS	MSC_PLAN_ORG_KPIS.PLAN_ID MSC_PLAN_ORG_KPIS.ORGANIZATION_ID MSC_PLAN_ORG_KPIS.SR_INSTANCE_ID
MSC_PLAN_ORG_STATUS		MSC_PLAN_ORGANIZATIONS	MSC_PLAN_ORG_STATUS.PLAN_ID MSC_PLAN_ORG_STATUS.ORGANIZATION_ID MSC_PLAN_ORG_STATUS.SR_INSTANCE_ID
MSC_PLAN_SCHEDULES		MSC_PLAN_ORGANIZATIONS	MSC_PLAN_SCHEDULES.PLAN_ID MSC_PLAN_SCHEDULES.ORGANIZATION_ID MSC_PLAN_SCHEDULES.SR_INSTANCE_ID
MSC_PROJECTS		MSC_PLAN_ORGANIZATIONS	MSC_PROJECTS.PLAN_ID MSC_PROJECTS.ORGANIZATION_ID MSC_PROJECTS.SR_INSTANCE_ID
MSC_SUB_INVENTORIES		MSC_PLAN_ORGANIZATIONS	MSC_SUB_INVENTORIES.PLAN_ID MSC_SUB_INVENTORIES.ORGANIZATION_ID MSC_SUB_INVENTORIES.SR_INSTANCE_ID
MSC_SYSTEM_ITEMS		MSC_PLAN_ORGANIZATIONS	MSC_SYSTEM_ITEMS.PLAN_ID MSC_SYSTEM_ITEMS.ORGANIZATION_ID MSC_SYSTEM_ITEMS.SR_INSTANCE_ID