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.

VIEW: APPS.MSC_PLAN_SCHEDULES_V

Source

View Text - Preformatted


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, MPS.SHIP_TO, MPS.MAPE_VALUE, MPS.DEMAND_VARIABILITY_TYPE FROM MSC_PLAN_SCHEDULES MPS, MSC_DESIGNATORS MD WHERE MPS.INPUT_SCHEDULE_ID = MD.DESIGNATOR_ID AND MPS.DESIGNATOR_TYPE<>7 AND MD.DESIGNATOR_TYPE NOT IN (12,13) UNION ALL 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, MPS_S.SHIP_TO, MPS_S.MAPE_VALUE, MPS_S.DEMAND_VARIABILITY_TYPE 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 AND MPS_S.input_schedule_id not in (select input_schedule_id from msc_plan_schedules where plan_id = MPS.plan_id) AND MD.DESIGNATOR_TYPE NOT IN (12,13) UNION ALL SELECT SCN.ORGANIZATION_ID, MPS.PLAN_ID, MPS.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, MPS.SHIP_TO, MPS.MAPE_VALUE, MPS.DEMAND_VARIABILITY_TYPE 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 ALL 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, MPS.SHIP_TO, MPS.MAPE_VALUE, MPS.DEMAND_VARIABILITY_TYPE 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 AND MPS.input_schedule_id not in (select input_schedule_id from msc_plan_schedules where plan_id = MPS_S.plan_id) AND MD.DESIGNATOR_TYPE NOT IN (12,13)

View Text - HTML Formatted

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
, MPS.SHIP_TO
, MPS.MAPE_VALUE
, MPS.DEMAND_VARIABILITY_TYPE
FROM MSC_PLAN_SCHEDULES MPS
, MSC_DESIGNATORS MD
WHERE MPS.INPUT_SCHEDULE_ID = MD.DESIGNATOR_ID
AND MPS.DESIGNATOR_TYPE<>7
AND MD.DESIGNATOR_TYPE NOT IN (12
, 13) UNION ALL 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
, MPS_S.SHIP_TO
, MPS_S.MAPE_VALUE
, MPS_S.DEMAND_VARIABILITY_TYPE
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
AND MPS_S.INPUT_SCHEDULE_ID NOT IN (SELECT INPUT_SCHEDULE_ID
FROM MSC_PLAN_SCHEDULES
WHERE PLAN_ID = MPS.PLAN_ID)
AND MD.DESIGNATOR_TYPE NOT IN (12
, 13) UNION ALL SELECT SCN.ORGANIZATION_ID
, MPS.PLAN_ID
, MPS.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
, MPS.SHIP_TO
, MPS.MAPE_VALUE
, MPS.DEMAND_VARIABILITY_TYPE
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 ALL 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
, MPS.SHIP_TO
, MPS.MAPE_VALUE
, MPS.DEMAND_VARIABILITY_TYPE
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
AND MPS.INPUT_SCHEDULE_ID NOT IN (SELECT INPUT_SCHEDULE_ID
FROM MSC_PLAN_SCHEDULES
WHERE PLAN_ID = MPS_S.PLAN_ID)
AND MD.DESIGNATOR_TYPE NOT IN (12
, 13)