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_ORDER_FORECAST_DS_V

Source

View Text - Preformatted


SELECT MDS.DEMAND_PLAN_ID, MS.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, d_geo.level_pk geo_level_value_pk, d_geo.level_id geo_level_id, 9 time_level_id, MS.NEW_ORDER_QUANTITY, to_number(null), TRUNC(MS.NEW_SCHEDULE_DATE) , MS.creation_date, MS.created_by, MS.last_update_date, MS.last_updated_by, MS.last_update_login, 1, 1, 'I', to_number(null), to_number(null), mis.ASL_LIABILITY_AGREEMENT_BASIS FROM MSC_PLANS PLANS, MSC_supplies MS, MSD_DP_SESSION MDS, msc_item_suppliers mis, MSC_TRADING_PARTNERS MTP, MSC_SYSTEM_ITEMS MSI, msd_level_values_DS d_itm, msd_level_values_DS d_org, msd_level_values_DS d_geo WHERE plans.plan_id <> -1 and MS.PLAN_ID=PLANS.PLAN_ID AND MSI.PLAN_ID=PLANS.PLAN_ID AND mis.plan_id = plans.plan_id and MS.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID AND MS.ORGANIZATION_ID = MSI.ORGANIZATION_ID AND MS.SR_INSTANCE_ID = MSI.SR_INSTANCE_ID AND MS.ORDER_TYPE in (5,17) AND mis.plan_id = ms.plan_id AND mis.sr_instance_id = ms.sr_instance_id AND mis.organization_id = ms.organization_id and mis.inventory_item_id = ms.inventory_item_id and mis.supplier_id = ms.supplier_id and MIS.SUPPLIER_SITE_ID = MS.SUPPLIER_SITE_ID AND mis.INCLUDE_LIABILITY_AGREEMENT = 1 and MTP.PARTNER_ID=MIS.SUPPLIER_ID AND MTP.PARTNER_TYPE=1 AND D_ORG.LEVEL_ID=7 AND D_ORG.INSTANCE=to_char(MS.SR_INSTANCE_ID) AND D_ORG.SR_LEVEL_PK=to_char(MS.ORGANIZATION_ID) AND D_ORG.DEMAND_PLAN_ID = MDS.DEMAND_PLAN_ID AND D_ITM.LEVEL_ID=1 AND D_ITM.INSTANCE=to_char(MSI.SR_INSTANCE_ID) AND D_ITM.SR_LEVEL_PK=to_char(MSI.SR_INVENTORY_ITEM_ID) AND D_ITM.DEMAND_PLAN_ID = MDS.DEMAND_PLAN_ID AND d_geo.level_id=50 and D_GEO.INSTANCE=to_char(MS.SR_INSTANCE_ID) AND D_GEO.SR_LEVEL_PK=to_char('1.'||MTP.sr_tp_id) AND D_GEO.DEMAND_PLAN_ID = MDS.DEMAND_PLAN_ID UNION ALL SELECT MDS.DEMAND_PLAN_ID, 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, 50 GEO_LEVEL_ID, 9 TIME_LEVEL_ID, TO_NUMBER(MCD.ATTRIBUTE_41) QUANTITY, to_number(null), TO_DATE(MCD.ATTRIBUTE_43,'YYYY/MM/DD'), 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, to_number(null) FROM MSD_CS_DATA MCD, MSD_LEVEL_VALUES_DS MLV_ORG, MSD_LEVEL_VALUES_DS MLV_PRD, MSD_LEVEL_VALUES_DS MLV_GEO, MSD_DP_SESSION MDS WHERE MCD.CS_DEFINITION_ID = (SELECT CS_DEFINITION_ID FROM MSD_CS_DEFINITIONS WHERE NAME = 'MSD_ORDER_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 MLV_ORG.DEMAND_PLAN_ID=MDS.DEMAND_PLAN_ID 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 MLV_PRD.DEMAND_PLAN_ID=MDS.DEMAND_PLAN_ID AND MCD.ATTRIBUTE_6 = 50 AND MLV_GEO.LEVEL_ID = 50 AND MCD.ATTRIBUTE_7 = MLV_GEO.SR_LEVEL_PK AND MCD.ATTRIBUTE_1 = MLV_GEO.INSTANCE AND MLV_GEO.DEMAND_PLAN_ID=MDS.DEMAND_PLAN_ID

View Text - HTML Formatted

SELECT MDS.DEMAND_PLAN_ID
, MS.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
, D_GEO.LEVEL_PK GEO_LEVEL_VALUE_PK
, D_GEO.LEVEL_ID GEO_LEVEL_ID
, 9 TIME_LEVEL_ID
, MS.NEW_ORDER_QUANTITY
, TO_NUMBER(NULL)
, TRUNC(MS.NEW_SCHEDULE_DATE)
, MS.CREATION_DATE
, MS.CREATED_BY
, MS.LAST_UPDATE_DATE
, MS.LAST_UPDATED_BY
, MS.LAST_UPDATE_LOGIN
, 1
, 1
, 'I'
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, MIS.ASL_LIABILITY_AGREEMENT_BASIS
FROM MSC_PLANS PLANS
, MSC_SUPPLIES MS
, MSD_DP_SESSION MDS
, MSC_ITEM_SUPPLIERS MIS
, MSC_TRADING_PARTNERS MTP
, MSC_SYSTEM_ITEMS MSI
, MSD_LEVEL_VALUES_DS D_ITM
, MSD_LEVEL_VALUES_DS D_ORG
, MSD_LEVEL_VALUES_DS D_GEO
WHERE PLANS.PLAN_ID <> -1
AND MS.PLAN_ID=PLANS.PLAN_ID
AND MSI.PLAN_ID=PLANS.PLAN_ID
AND MIS.PLAN_ID = PLANS.PLAN_ID
AND MS.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
AND MS.ORGANIZATION_ID = MSI.ORGANIZATION_ID
AND MS.SR_INSTANCE_ID = MSI.SR_INSTANCE_ID
AND MS.ORDER_TYPE IN (5
, 17)
AND MIS.PLAN_ID = MS.PLAN_ID
AND MIS.SR_INSTANCE_ID = MS.SR_INSTANCE_ID
AND MIS.ORGANIZATION_ID = MS.ORGANIZATION_ID
AND MIS.INVENTORY_ITEM_ID = MS.INVENTORY_ITEM_ID
AND MIS.SUPPLIER_ID = MS.SUPPLIER_ID
AND MIS.SUPPLIER_SITE_ID = MS.SUPPLIER_SITE_ID
AND MIS.INCLUDE_LIABILITY_AGREEMENT = 1
AND MTP.PARTNER_ID=MIS.SUPPLIER_ID
AND MTP.PARTNER_TYPE=1
AND D_ORG.LEVEL_ID=7
AND D_ORG.INSTANCE=TO_CHAR(MS.SR_INSTANCE_ID)
AND D_ORG.SR_LEVEL_PK=TO_CHAR(MS.ORGANIZATION_ID)
AND D_ORG.DEMAND_PLAN_ID = MDS.DEMAND_PLAN_ID
AND D_ITM.LEVEL_ID=1
AND D_ITM.INSTANCE=TO_CHAR(MSI.SR_INSTANCE_ID)
AND D_ITM.SR_LEVEL_PK=TO_CHAR(MSI.SR_INVENTORY_ITEM_ID)
AND D_ITM.DEMAND_PLAN_ID = MDS.DEMAND_PLAN_ID
AND D_GEO.LEVEL_ID=50
AND D_GEO.INSTANCE=TO_CHAR(MS.SR_INSTANCE_ID)
AND D_GEO.SR_LEVEL_PK=TO_CHAR('1.'||MTP.SR_TP_ID)
AND D_GEO.DEMAND_PLAN_ID = MDS.DEMAND_PLAN_ID UNION ALL SELECT MDS.DEMAND_PLAN_ID
, 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
, 50 GEO_LEVEL_ID
, 9 TIME_LEVEL_ID
, TO_NUMBER(MCD.ATTRIBUTE_41) QUANTITY
, TO_NUMBER(NULL)
, TO_DATE(MCD.ATTRIBUTE_43
, 'YYYY/MM/DD')
, 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
, TO_NUMBER(NULL)
FROM MSD_CS_DATA MCD
, MSD_LEVEL_VALUES_DS MLV_ORG
, MSD_LEVEL_VALUES_DS MLV_PRD
, MSD_LEVEL_VALUES_DS MLV_GEO
, MSD_DP_SESSION MDS
WHERE MCD.CS_DEFINITION_ID = (SELECT CS_DEFINITION_ID
FROM MSD_CS_DEFINITIONS
WHERE NAME = 'MSD_ORDER_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 MLV_ORG.DEMAND_PLAN_ID=MDS.DEMAND_PLAN_ID
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 MLV_PRD.DEMAND_PLAN_ID=MDS.DEMAND_PLAN_ID
AND MCD.ATTRIBUTE_6 = 50
AND MLV_GEO.LEVEL_ID = 50
AND MCD.ATTRIBUTE_7 = MLV_GEO.SR_LEVEL_PK
AND MCD.ATTRIBUTE_1 = MLV_GEO.INSTANCE
AND MLV_GEO.DEMAND_PLAN_ID=MDS.DEMAND_PLAN_ID