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.MSD_CONSTRAINED_FORECAST_V

Source

View Text - Preformatted


SELECT total.plan_id, total.cs_name, total.org_level_value_pk, total.org_level_id, total.prd_level_value_pk, total.prd_level_id, total.geo_level_value_pk, total.geo_level_id, total.dcs_level_value_pk, total.dcs_level_id, total.time_level_id, total.quantity quantity, total.ship_date, total.arrival_date, total.creation_date, total.created_by, total.last_update_date, total.last_updated_by, total.last_update_login, 1, 1, 'I', to_number(null), to_number(null) from ( SELECT dem.plan_id plan_id, plans.compile_designator cs_name, d_org.level_pk org_level_value_pk, d_org.level_id org_level_id, d_itm.level_pk prd_level_value_pk, d_itm.level_id prd_level_id, nvl(msd_common_utilities.get_lvl_pk_from_tp_id(mtp.partner_id, dem.sr_instance_id), msd_common_utilities.get_loc_key(dem.sr_instance_id, '-777', null, 15) ) geo_level_value_pk, 15 geo_level_id, 9 time_level_id, dem.quantity_by_due_date quantity, trunc(dem.using_assembly_demand_date) ship_date, decode(nvl(plans.schedule_by, 1), 3, nvl(trunc(dem.request_date), trunc(dem.using_assembly_demand_date+nvl(intransit_lead_time,0))), 4, nvl(trunc(dem.request_date), trunc(dem.using_assembly_demand_date+nvl(intransit_lead_time,0))), 5, nvl(trunc(dem.promise_date), trunc(dem.using_assembly_demand_date+nvl(intransit_lead_time,0))), 6, nvl(trunc(dem.promise_date), trunc(dem.using_assembly_demand_date+nvl(intransit_lead_time,0))), nvl(trunc(dem.schedule_arrival_date), trunc(dem.using_assembly_demand_date+nvl(intransit_lead_time,0))) ) arrival_date, dem.creation_date, dem.created_by, dem.last_update_date, dem.last_updated_by, dem.last_update_login, 34 dcs_level_id, nvl(d_dcs.level_pk, msd_common_utilities.get_dcs_key(dem.sr_instance_id, '-777',null,34)) dcs_level_value_pk FROM msc_demands dem, msc_plans plans, msc_system_items msi, msc_system_items msia, msc_trading_partners mtp, msd_level_values d_itm, msd_level_values d_org, msd_level_values d_dcs, (select nvl(fnd_profile.value('MSD_TWO_LEVEL_PLANNING'), '2') profile_value from dual) tlp, msd_level_associations mla WHERE dem.plan_id != -1 and dem.plan_id = plans.plan_id and dem.plan_id = msia.plan_id and dem.sr_instance_id = msia.sr_instance_id and dem.organization_id = msia.organization_id and dem.using_assembly_item_id = msia.inventory_item_id and ((dem.inventory_item_id != dem.using_assembly_item_id and msia.bom_item_type = 5) or (dem.inventory_item_id = dem.using_assembly_item_id)) and dem.origination_type in (6,7,8,9,11,29,30,42, 22) and dem.plan_id = msi.plan_id and dem.sr_instance_id = msi.sr_instance_id and dem.organization_id = msi.organization_id and dem.inventory_item_id = msi.inventory_item_id and msi.mrp_planning_code <> 6 and d_itm.sr_level_pk = to_char(msi.sr_inventory_item_id) and d_itm.instance = to_char(msi.sr_instance_id) and d_itm.level_id = 1 and dem.customer_id = mtp.partner_id(+) and d_org.sr_level_pk = to_char(dem.organization_id) and d_org.instance = to_char(dem.sr_instance_id) and d_org.level_id = 7 and nvl(dem.quantity_by_due_date,0) != 0 and d_dcs.sr_level_pk(+) = dem.demand_class and d_dcs.instance(+) = to_char(dem.sr_instance_id) and d_dcs.level_id(+) = 34 and mla.instance = to_char(msi.sr_instance_id) and mla.level_id = 1 and mla.parent_level_id = 3 and mla.sr_level_pk = to_char(msi.sr_inventory_item_id) and decode( nvl(tlp.profile_value, '2'), '1', decode(nvl(msi.ato_forecast_control,3), 3, decode(mla.sr_parent_level_pk,'-777',2,1), 1), decode( nvl(msi.ato_forecast_control, 3), 3, 2, 1) ) = 1 UNION ALL SELECT dem.plan_id, plans.compile_designator, d_org.level_pk, d_org.level_id, d_itm.level_pk, d_itm.level_id, nvl(msd_common_utilities.get_lvl_pk_from_tp_id(mtp.partner_id, dem.sr_instance_id), msd_common_utilities.get_loc_key(dem.sr_instance_id, '-777', null, 15) ) geo_level_value_pk, 15, 9,(dem.USING_REQUIREMENT_QUANTITY - nvl(dem.quantity_by_due_date,0)) quantity, trunc(dem.dmd_satisfied_date) ship_date, nvl(trunc(dem.planned_arrival_date), trunc(dem.dmd_satisfied_date + nvl(intransit_lead_time,0))) arrival_date, dem.creation_date, dem.created_by, dem.last_update_date, dem.last_updated_by, dem.last_update_login, 34 dcs_level_id, nvl(d_dcs.level_pk, msd_common_utilities.get_dcs_key(dem.sr_instance_id, '-777',null,34)) dcs_level_value_pk FROM msc_demands dem, msc_plans plans, msc_system_items msi, msc_system_items msia, msc_trading_partners mtp, msd_level_values d_itm, msd_level_values d_org, msd_level_values d_dcs, (select nvl(fnd_profile.value('MSD_TWO_LEVEL_PLANNING'), '2') profile_value from dual) tlp, msd_level_associations mla WHERE dem.plan_id != -1 and dem.plan_id = plans.plan_id and dem.plan_id = msia.plan_id and dem.sr_instance_id = msia.sr_instance_id and dem.using_assembly_item_id = msia.inventory_item_id and dem.organization_id = msia.organization_id and ((dem.inventory_item_id != dem.using_assembly_item_id and msia.bom_item_type =5) or (dem.inventory_item_id = dem.using_assembly_item_id)) and dem.origination_type in (6,7,8,9,11,29,30,42,22) and dem.plan_id = msi.plan_id and dem.inventory_item_id = msi.inventory_item_id and dem.sr_instance_id = msi.sr_instance_id and dem.organization_id = msi.organization_id and msi.mrp_planning_code <> 6 and d_itm.sr_level_pk = to_char(msi.sr_inventory_item_id) and d_itm.instance = to_char(msi.sr_instance_id) and d_itm.level_id = 1 and dem.customer_id = mtp.partner_id(+) and d_org.sr_level_pk = to_char(dem.organization_id) and d_org.instance = to_char(dem.sr_instance_id) and d_org.level_id = 7 and (dem.USING_REQUIREMENT_QUANTITY - nvl(dem.quantity_by_due_date,0) !=0) and d_dcs.sr_level_pk(+) = dem.demand_class and d_dcs.instance(+) = to_char(dem.sr_instance_id) and d_dcs.level_id(+) = 34 and mla.instance = to_char(msi.sr_instance_id) and mla.level_id = 1 and mla.parent_level_id = 3 and mla.sr_level_pk = to_char(msi.sr_inventory_item_id) and decode( nvl(tlp.profile_value, '2'), '1', decode(nvl(msi.ato_forecast_control,3), 3, decode(mla.sr_parent_level_pk,'-777',2,1), 1), decode( nvl(msi.ato_forecast_control, 3), 3, 2, 1) ) = 1 ) total UNION ALL SELECT to_number(NULL) plan_id, mcd.CS_NAME cs_name, mlv_org.LEVEL_PK org_level_value_pk, 7 org_level_id, mlv_prd.LEVEL_PK prd_level_value_pk, 1 prd_level_id, mlv_geo.LEVEL_PK geo_level_value_pk, 15 geo_level_id, mlv_dcs.LEVEL_PK dcs_level_value_pk, 34 dcs_level_id, 9 time_level_id, to_number(mcd.ATTRIBUTE_41) quantity, to_date(mcd.ATTRIBUTE_43,'yyyy/mm/dd') ship_date, to_date(mcd.ATTRIBUTE_45,'yyyy/mm/dd') arrival_date, mcd.CREATION_DATE creation_date, mcd.CREATED_BY created_by, mcd.LAST_UPDATE_DATE last_update_date, mcd.LAST_UPDATED_BY last_updated_by, mcd.LAST_UPDATE_LOGIN last_update_login, mcd.LAST_REFRESH_NUM last_refresh_num, mcd.CREATED_BY_REFRESH_NUM created_by_refresh_num, mcd.ACTION_CODE action_code, to_number(NULL) prd_parent_level_id, to_number(NULL) prd_parent_level_value_pk FROM MSD_CS_DATA mcd, MSD_LEVEL_VALUES mlv_org, MSD_LEVEL_VALUES mlv_prd, MSD_LEVEL_VALUES mlv_geo, MSD_LEVEL_VALUES mlv_dcs WHERE mcd.CS_DEFINITION_ID = (SELECT cs_definition_id FROM msd_cs_definitions WHERE name = 'MSD_CONSTRAINED_FORECAST') AND mcd.ATTRIBUTE_10 = 7 AND mlv_org.level_id = 7 AND mcd.ATTRIBUTE_11 = mlv_org.SR_LEVEL_PK AND mcd.ATTRIBUTE_1 = mlv_org.INSTANCE AND mcd.ATTRIBUTE_2 = 1 AND mlv_prd.level_id = 1 AND mcd.ATTRIBUTE_3 = mlv_prd.SR_LEVEL_PK AND mcd.ATTRIBUTE_1 = mlv_prd.INSTANCE AND mcd.ATTRIBUTE_6 = 15 AND mlv_geo.level_id = 15 AND mcd.ATTRIBUTE_7 = mlv_geo.SR_LEVEL_PK AND mcd.ATTRIBUTE_1 = mlv_geo.INSTANCE AND mcd.ATTRIBUTE_50 = 34 AND mlv_dcs.level_id = 34 AND mcd.ATTRIBUTE_51 = mlv_dcs.SR_LEVEL_PK AND mcd.ATTRIBUTE_1 = mlv_dcs.INSTANCE

View Text - HTML Formatted

SELECT TOTAL.PLAN_ID
, TOTAL.CS_NAME
, TOTAL.ORG_LEVEL_VALUE_PK
, TOTAL.ORG_LEVEL_ID
, TOTAL.PRD_LEVEL_VALUE_PK
, TOTAL.PRD_LEVEL_ID
, TOTAL.GEO_LEVEL_VALUE_PK
, TOTAL.GEO_LEVEL_ID
, TOTAL.DCS_LEVEL_VALUE_PK
, TOTAL.DCS_LEVEL_ID
, TOTAL.TIME_LEVEL_ID
, TOTAL.QUANTITY QUANTITY
, TOTAL.SHIP_DATE
, TOTAL.ARRIVAL_DATE
, TOTAL.CREATION_DATE
, TOTAL.CREATED_BY
, TOTAL.LAST_UPDATE_DATE
, TOTAL.LAST_UPDATED_BY
, TOTAL.LAST_UPDATE_LOGIN
, 1
, 1
, 'I'
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
FROM ( SELECT DEM.PLAN_ID PLAN_ID
, PLANS.COMPILE_DESIGNATOR CS_NAME
, D_ORG.LEVEL_PK ORG_LEVEL_VALUE_PK
, D_ORG.LEVEL_ID ORG_LEVEL_ID
, D_ITM.LEVEL_PK PRD_LEVEL_VALUE_PK
, D_ITM.LEVEL_ID PRD_LEVEL_ID
, NVL(MSD_COMMON_UTILITIES.GET_LVL_PK_FROM_TP_ID(MTP.PARTNER_ID
, DEM.SR_INSTANCE_ID)
, MSD_COMMON_UTILITIES.GET_LOC_KEY(DEM.SR_INSTANCE_ID
, '-777'
, NULL
, 15) ) GEO_LEVEL_VALUE_PK
, 15 GEO_LEVEL_ID
, 9 TIME_LEVEL_ID
, DEM.QUANTITY_BY_DUE_DATE QUANTITY
, TRUNC(DEM.USING_ASSEMBLY_DEMAND_DATE) SHIP_DATE
, DECODE(NVL(PLANS.SCHEDULE_BY
, 1)
, 3
, NVL(TRUNC(DEM.REQUEST_DATE)
, TRUNC(DEM.USING_ASSEMBLY_DEMAND_DATE+NVL(INTRANSIT_LEAD_TIME
, 0)))
, 4
, NVL(TRUNC(DEM.REQUEST_DATE)
, TRUNC(DEM.USING_ASSEMBLY_DEMAND_DATE+NVL(INTRANSIT_LEAD_TIME
, 0)))
, 5
, NVL(TRUNC(DEM.PROMISE_DATE)
, TRUNC(DEM.USING_ASSEMBLY_DEMAND_DATE+NVL(INTRANSIT_LEAD_TIME
, 0)))
, 6
, NVL(TRUNC(DEM.PROMISE_DATE)
, TRUNC(DEM.USING_ASSEMBLY_DEMAND_DATE+NVL(INTRANSIT_LEAD_TIME
, 0)))
, NVL(TRUNC(DEM.SCHEDULE_ARRIVAL_DATE)
, TRUNC(DEM.USING_ASSEMBLY_DEMAND_DATE+NVL(INTRANSIT_LEAD_TIME
, 0))) ) ARRIVAL_DATE
, DEM.CREATION_DATE
, DEM.CREATED_BY
, DEM.LAST_UPDATE_DATE
, DEM.LAST_UPDATED_BY
, DEM.LAST_UPDATE_LOGIN
, 34 DCS_LEVEL_ID
, NVL(D_DCS.LEVEL_PK
, MSD_COMMON_UTILITIES.GET_DCS_KEY(DEM.SR_INSTANCE_ID
, '-777'
, NULL
, 34)) DCS_LEVEL_VALUE_PK
FROM MSC_DEMANDS DEM
, MSC_PLANS PLANS
, MSC_SYSTEM_ITEMS MSI
, MSC_SYSTEM_ITEMS MSIA
, MSC_TRADING_PARTNERS MTP
, MSD_LEVEL_VALUES D_ITM
, MSD_LEVEL_VALUES D_ORG
, MSD_LEVEL_VALUES D_DCS
, (SELECT NVL(FND_PROFILE.VALUE('MSD_TWO_LEVEL_PLANNING')
, '2') PROFILE_VALUE
FROM DUAL) TLP
, MSD_LEVEL_ASSOCIATIONS MLA
WHERE DEM.PLAN_ID != -1
AND DEM.PLAN_ID = PLANS.PLAN_ID
AND DEM.PLAN_ID = MSIA.PLAN_ID
AND DEM.SR_INSTANCE_ID = MSIA.SR_INSTANCE_ID
AND DEM.ORGANIZATION_ID = MSIA.ORGANIZATION_ID
AND DEM.USING_ASSEMBLY_ITEM_ID = MSIA.INVENTORY_ITEM_ID
AND ((DEM.INVENTORY_ITEM_ID != DEM.USING_ASSEMBLY_ITEM_ID
AND MSIA.BOM_ITEM_TYPE = 5) OR (DEM.INVENTORY_ITEM_ID = DEM.USING_ASSEMBLY_ITEM_ID))
AND DEM.ORIGINATION_TYPE IN (6
, 7
, 8
, 9
, 11
, 29
, 30
, 42
, 22)
AND DEM.PLAN_ID = MSI.PLAN_ID
AND DEM.SR_INSTANCE_ID = MSI.SR_INSTANCE_ID
AND DEM.ORGANIZATION_ID = MSI.ORGANIZATION_ID
AND DEM.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
AND MSI.MRP_PLANNING_CODE <> 6
AND D_ITM.SR_LEVEL_PK = TO_CHAR(MSI.SR_INVENTORY_ITEM_ID)
AND D_ITM.INSTANCE = TO_CHAR(MSI.SR_INSTANCE_ID)
AND D_ITM.LEVEL_ID = 1
AND DEM.CUSTOMER_ID = MTP.PARTNER_ID(+)
AND D_ORG.SR_LEVEL_PK = TO_CHAR(DEM.ORGANIZATION_ID)
AND D_ORG.INSTANCE = TO_CHAR(DEM.SR_INSTANCE_ID)
AND D_ORG.LEVEL_ID = 7
AND NVL(DEM.QUANTITY_BY_DUE_DATE
, 0) != 0
AND D_DCS.SR_LEVEL_PK(+) = DEM.DEMAND_CLASS
AND D_DCS.INSTANCE(+) = TO_CHAR(DEM.SR_INSTANCE_ID)
AND D_DCS.LEVEL_ID(+) = 34
AND MLA.INSTANCE = TO_CHAR(MSI.SR_INSTANCE_ID)
AND MLA.LEVEL_ID = 1
AND MLA.PARENT_LEVEL_ID = 3
AND MLA.SR_LEVEL_PK = TO_CHAR(MSI.SR_INVENTORY_ITEM_ID)
AND DECODE( NVL(TLP.PROFILE_VALUE
, '2')
, '1'
, DECODE(NVL(MSI.ATO_FORECAST_CONTROL
, 3)
, 3
, DECODE(MLA.SR_PARENT_LEVEL_PK
, '-777'
, 2
, 1)
, 1)
, DECODE( NVL(MSI.ATO_FORECAST_CONTROL
, 3)
, 3
, 2
, 1) ) = 1 UNION ALL SELECT DEM.PLAN_ID
, PLANS.COMPILE_DESIGNATOR
, D_ORG.LEVEL_PK
, D_ORG.LEVEL_ID
, D_ITM.LEVEL_PK
, D_ITM.LEVEL_ID
, NVL(MSD_COMMON_UTILITIES.GET_LVL_PK_FROM_TP_ID(MTP.PARTNER_ID
, DEM.SR_INSTANCE_ID)
, MSD_COMMON_UTILITIES.GET_LOC_KEY(DEM.SR_INSTANCE_ID
, '-777'
, NULL
, 15) ) GEO_LEVEL_VALUE_PK
, 15
, 9
, (DEM.USING_REQUIREMENT_QUANTITY - NVL(DEM.QUANTITY_BY_DUE_DATE
, 0)) QUANTITY
, TRUNC(DEM.DMD_SATISFIED_DATE) SHIP_DATE
, NVL(TRUNC(DEM.PLANNED_ARRIVAL_DATE)
, TRUNC(DEM.DMD_SATISFIED_DATE + NVL(INTRANSIT_LEAD_TIME
, 0))) ARRIVAL_DATE
, DEM.CREATION_DATE
, DEM.CREATED_BY
, DEM.LAST_UPDATE_DATE
, DEM.LAST_UPDATED_BY
, DEM.LAST_UPDATE_LOGIN
, 34 DCS_LEVEL_ID
, NVL(D_DCS.LEVEL_PK
, MSD_COMMON_UTILITIES.GET_DCS_KEY(DEM.SR_INSTANCE_ID
, '-777'
, NULL
, 34)) DCS_LEVEL_VALUE_PK
FROM MSC_DEMANDS DEM
, MSC_PLANS PLANS
, MSC_SYSTEM_ITEMS MSI
, MSC_SYSTEM_ITEMS MSIA
, MSC_TRADING_PARTNERS MTP
, MSD_LEVEL_VALUES D_ITM
, MSD_LEVEL_VALUES D_ORG
, MSD_LEVEL_VALUES D_DCS
, (SELECT NVL(FND_PROFILE.VALUE('MSD_TWO_LEVEL_PLANNING')
, '2') PROFILE_VALUE
FROM DUAL) TLP
, MSD_LEVEL_ASSOCIATIONS MLA
WHERE DEM.PLAN_ID != -1
AND DEM.PLAN_ID = PLANS.PLAN_ID
AND DEM.PLAN_ID = MSIA.PLAN_ID
AND DEM.SR_INSTANCE_ID = MSIA.SR_INSTANCE_ID
AND DEM.USING_ASSEMBLY_ITEM_ID = MSIA.INVENTORY_ITEM_ID
AND DEM.ORGANIZATION_ID = MSIA.ORGANIZATION_ID
AND ((DEM.INVENTORY_ITEM_ID != DEM.USING_ASSEMBLY_ITEM_ID
AND MSIA.BOM_ITEM_TYPE =5) OR (DEM.INVENTORY_ITEM_ID = DEM.USING_ASSEMBLY_ITEM_ID))
AND DEM.ORIGINATION_TYPE IN (6
, 7
, 8
, 9
, 11
, 29
, 30
, 42
, 22)
AND DEM.PLAN_ID = MSI.PLAN_ID
AND DEM.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
AND DEM.SR_INSTANCE_ID = MSI.SR_INSTANCE_ID
AND DEM.ORGANIZATION_ID = MSI.ORGANIZATION_ID
AND MSI.MRP_PLANNING_CODE <> 6
AND D_ITM.SR_LEVEL_PK = TO_CHAR(MSI.SR_INVENTORY_ITEM_ID)
AND D_ITM.INSTANCE = TO_CHAR(MSI.SR_INSTANCE_ID)
AND D_ITM.LEVEL_ID = 1
AND DEM.CUSTOMER_ID = MTP.PARTNER_ID(+)
AND D_ORG.SR_LEVEL_PK = TO_CHAR(DEM.ORGANIZATION_ID)
AND D_ORG.INSTANCE = TO_CHAR(DEM.SR_INSTANCE_ID)
AND D_ORG.LEVEL_ID = 7
AND (DEM.USING_REQUIREMENT_QUANTITY - NVL(DEM.QUANTITY_BY_DUE_DATE
, 0) !=0)
AND D_DCS.SR_LEVEL_PK(+) = DEM.DEMAND_CLASS
AND D_DCS.INSTANCE(+) = TO_CHAR(DEM.SR_INSTANCE_ID)
AND D_DCS.LEVEL_ID(+) = 34
AND MLA.INSTANCE = TO_CHAR(MSI.SR_INSTANCE_ID)
AND MLA.LEVEL_ID = 1
AND MLA.PARENT_LEVEL_ID = 3
AND MLA.SR_LEVEL_PK = TO_CHAR(MSI.SR_INVENTORY_ITEM_ID)
AND DECODE( NVL(TLP.PROFILE_VALUE
, '2')
, '1'
, DECODE(NVL(MSI.ATO_FORECAST_CONTROL
, 3)
, 3
, DECODE(MLA.SR_PARENT_LEVEL_PK
, '-777'
, 2
, 1)
, 1)
, DECODE( NVL(MSI.ATO_FORECAST_CONTROL
, 3)
, 3
, 2
, 1) ) = 1 ) TOTAL UNION ALL SELECT TO_NUMBER(NULL) PLAN_ID
, MCD.CS_NAME CS_NAME
, MLV_ORG.LEVEL_PK ORG_LEVEL_VALUE_PK
, 7 ORG_LEVEL_ID
, MLV_PRD.LEVEL_PK PRD_LEVEL_VALUE_PK
, 1 PRD_LEVEL_ID
, MLV_GEO.LEVEL_PK GEO_LEVEL_VALUE_PK
, 15 GEO_LEVEL_ID
, MLV_DCS.LEVEL_PK DCS_LEVEL_VALUE_PK
, 34 DCS_LEVEL_ID
, 9 TIME_LEVEL_ID
, TO_NUMBER(MCD.ATTRIBUTE_41) QUANTITY
, TO_DATE(MCD.ATTRIBUTE_43
, 'YYYY/MM/DD') SHIP_DATE
, TO_DATE(MCD.ATTRIBUTE_45
, 'YYYY/MM/DD') ARRIVAL_DATE
, MCD.CREATION_DATE CREATION_DATE
, MCD.CREATED_BY CREATED_BY
, MCD.LAST_UPDATE_DATE LAST_UPDATE_DATE
, MCD.LAST_UPDATED_BY LAST_UPDATED_BY
, MCD.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, MCD.LAST_REFRESH_NUM LAST_REFRESH_NUM
, MCD.CREATED_BY_REFRESH_NUM CREATED_BY_REFRESH_NUM
, MCD.ACTION_CODE ACTION_CODE
, TO_NUMBER(NULL) PRD_PARENT_LEVEL_ID
, TO_NUMBER(NULL) PRD_PARENT_LEVEL_VALUE_PK
FROM MSD_CS_DATA MCD
, MSD_LEVEL_VALUES MLV_ORG
, MSD_LEVEL_VALUES MLV_PRD
, MSD_LEVEL_VALUES MLV_GEO
, MSD_LEVEL_VALUES MLV_DCS
WHERE MCD.CS_DEFINITION_ID = (SELECT CS_DEFINITION_ID
FROM MSD_CS_DEFINITIONS
WHERE NAME = 'MSD_CONSTRAINED_FORECAST')
AND MCD.ATTRIBUTE_10 = 7
AND MLV_ORG.LEVEL_ID = 7
AND MCD.ATTRIBUTE_11 = MLV_ORG.SR_LEVEL_PK
AND MCD.ATTRIBUTE_1 = MLV_ORG.INSTANCE
AND MCD.ATTRIBUTE_2 = 1
AND MLV_PRD.LEVEL_ID = 1
AND MCD.ATTRIBUTE_3 = MLV_PRD.SR_LEVEL_PK
AND MCD.ATTRIBUTE_1 = MLV_PRD.INSTANCE
AND MCD.ATTRIBUTE_6 = 15
AND MLV_GEO.LEVEL_ID = 15
AND MCD.ATTRIBUTE_7 = MLV_GEO.SR_LEVEL_PK
AND MCD.ATTRIBUTE_1 = MLV_GEO.INSTANCE
AND MCD.ATTRIBUTE_50 = 34
AND MLV_DCS.LEVEL_ID = 34
AND MCD.ATTRIBUTE_51 = MLV_DCS.SR_LEVEL_PK
AND MCD.ATTRIBUTE_1 = MLV_DCS.INSTANCE