View: MSD_SUPPLY_PLANS_V

Product:	MSD - Demand Planning
Description:	Supply Plan View
Implementation/DBA Data:	APPS.MSD_SUPPLY_PLANS_V

View Text

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.TIME_LEVEL_ID
, TOTAL.QUANTITY
, TOTAL.END_DATE
, TOTAL.CREATION_DATE
, TOTAL.CREATED_BY
, TOTAL.LAST_UPDATE_DATE
, TOTAL.LAST_UPDATED_BY
, TOTAL.LAST_UPDATE_LOGIN
FROM (SELECT SUP.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
, MSD_COMMON_UTILITIES.GET_LOC_KEY(SUP.SR_INSTANCE_ID
, '-3'
, NULL
, 30) GEO_LEVEL_VALUE_PK
, 30 GEO_LEVEL_ID
, 9 TIME_LEVEL_ID
, NVL(SUP.NEW_ORDER_QUANTITY
, 0) QUANTITY
, TRUNC(SUP.NEW_SCHEDULE_DATE) END_DATE
, SUP.CREATION_DATE
, SUP.CREATED_BY
, SUP.LAST_UPDATE_DATE
, SUP.LAST_UPDATED_BY
, SUP.LAST_UPDATE_LOGIN
FROM MSC_SUPPLIES SUP
, MSC_PLANS PLANS
, MSC_SYSTEM_ITEMS MSI
, MSD_LEVEL_VALUES D_ITM
, MSD_LEVEL_VALUES D_ORG
WHERE SUP.PLAN_ID != -1
AND SUP.PLAN_ID = PLANS.PLAN_ID
AND NVL(SUP.NEW_ORDER_QUANTITY
, 0) !=0
AND SUP.ORDER_TYPE IN (1
, 2
, 3
, 4
, 5
, 7
, 8
, 11
, 12
, 14
, 15
, 16
, 17
, 18
, 27
, 28
, 29
, 30)
AND SUP.ORGANIZATION_ID = MSI.ORGANIZATION_ID
AND SUP.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
AND SUP.PLAN_ID = MSI.PLAN_ID
AND SUP.SR_INSTANCE_ID = MSI.SR_INSTANCE_ID
AND MSI.ATO_FORECAST_CONTROL <> 3
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 D_ORG.SR_LEVEL_PK = TO_CHAR(SUP.ORGANIZATION_ID)
AND D_ORG.INSTANCE = TO_CHAR(SUP.SR_INSTANCE_ID)
AND D_ORG.LEVEL_ID = 7) TOTAL

Columns