Product: | MSC - Advanced Supply Chain Planning |
---|---|
Description: | Supply/Demand Schedule information for planner. |
Implementation/DBA Data: | APPS.MSC_PLAN_SCHEDULES_V |
SELECT MD.ORGANIZATION_ID
, MPS.PLAN_ID
, MD.SR_INSTANCE_ID
, MPS.DESIGNATOR_TYPE
, MPS.ORGANIZATION_ID
, MPS.SR_INSTANCE_ID
, MPS.INPUT_SCHEDULE_ID
, MD.DESIGNATOR
, MPS.INPUT_TYPE
, NVL(MPS.INTERPLANT_DEMAND_FLAG
, 2 )
, MPS.SCENARIO_SET
, MPS.PROBABILITY
FROM MSC_PLAN_SCHEDULES MPS
, MSC_DESIGNATORS MD
WHERE MPS.INPUT_SCHEDULE_ID = MD.DESIGNATOR_ID
AND MPS.DESIGNATOR_TYPE<>7 UNION SELECT MD_S.ORGANIZATION_ID
, MPS.PLAN_ID
, MD_S.SR_INSTANCE_ID
, MPS_S.DESIGNATOR_TYPE
, MPS_S.ORGANIZATION_ID
, MPS_S.SR_INSTANCE_ID
, MPS_S.INPUT_SCHEDULE_ID
, MD_S.DESIGNATOR
, MPS_S.INPUT_TYPE
, NVL(MPS_S.INTERPLANT_DEMAND_FLAG
, 2 )
, MPS_S.SCENARIO_SET
, MPS_S.PROBABILITY
FROM MSC_DESIGNATORS MD_S
, MSC_PLAN_SCHEDULES MPS_S
, MSC_PLANS MP_S
, MSC_DESIGNATORS MD
, MSC_PLAN_SCHEDULES MPS
WHERE MPS.INPUT_SCHEDULE_ID = MD.DESIGNATOR_ID
AND MPS.INPUT_TYPE = 1
AND NVL(MPS.INTERPLANT_DEMAND_FLAG
, 2) = 2
AND MPS.DESIGNATOR_TYPE IN (2
, 3
, 4)
AND MP_S.COMPILE_DESIGNATOR = MD.DESIGNATOR
AND MP_S.ORGANIZATION_ID = MD.ORGANIZATION_ID
AND MP_S.SR_INSTANCE_ID = MD.SR_INSTANCE_ID
AND MPS_S.PLAN_ID = MP_S.PLAN_ID
AND MPS_S.INPUT_SCHEDULE_ID = MD_S.DESIGNATOR_ID
AND MPS_S.DESIGNATOR_TYPE IN (1
, 6)
AND MPS.ORGANIZATION_ID = MPS_S.ORGANIZATION_ID
AND MPS.SR_INSTANCE_ID = MPS_S.SR_INSTANCE_ID UNION SELECT SCN.ORGANIZATION_ID
, MPS.PLAN_ID
, SCN.SR_INSTANCE_ID
, MPS.DESIGNATOR_TYPE
, MPS.ORGANIZATION_ID
, MPS.SR_INSTANCE_ID
, MPS.INPUT_SCHEDULE_ID
, SCN.SCENARIO_NAME
, MPS.INPUT_TYPE
, NVL(MPS.INTERPLANT_DEMAND_FLAG
, 2 )
, MPS.SCENARIO_SET
, MPS.PROBABILITY
FROM MSC_PLAN_SCHEDULES MPS
, MSD_DP_ASCP_SCENARIOS_V SCN
WHERE MPS.INPUT_SCHEDULE_ID = SCN.SCENARIO_ID
AND MPS.DESIGNATOR_TYPE = 7 UNION SELECT SCN.ORGANIZATION_ID
, MPS_S.PLAN_ID
, SCN.SR_INSTANCE_ID
, MPS.DESIGNATOR_TYPE
, MPS.ORGANIZATION_ID
, MPS.SR_INSTANCE_ID
, MPS.INPUT_SCHEDULE_ID
, SCN.SCENARIO_NAME
, MPS.INPUT_TYPE
, NVL(MPS.INTERPLANT_DEMAND_FLAG
, 2 )
, MPS.SCENARIO_SET
, MPS.PROBABILITY
FROM MSC_PLAN_SCHEDULES MPS
, MSD_DP_ASCP_SCENARIOS_V SCN
, MSC_PLANS MP
, MSC_PLAN_SCHEDULES MPS_S
, MSC_DESIGNATORS MD
WHERE MPS.INPUT_SCHEDULE_ID = SCN.SCENARIO_ID
AND MPS.DESIGNATOR_TYPE = 7
AND MPS.PLAN_ID = MP.PLAN_ID
AND MP.COMPILE_DESIGNATOR = MD.DESIGNATOR
AND MP.ORGANIZATION_ID = MD.ORGANIZATION_ID
AND MP.SR_INSTANCE_ID = MD.SR_INSTANCE_ID
AND MD.DESIGNATOR_ID = MPS_S.INPUT_SCHEDULE_ID
AND MPS.ORGANIZATION_ID = MPS_S.ORGANIZATION_ID
AND MPS.SR_INSTANCE_ID = MPS_S.SR_INSTANCE_ID
AND MPS_S.DESIGNATOR_TYPE IN (2
, 3
, 4)
AND NVL(MPS_S.INTERPLANT_DEMAND_FLAG
, 2) = 2
AND MPS_S.INPUT_TYPE = 1