View: MSD_SHIPMENT_DATA_CS_V

Product:	MSD - Demand Planning
Description:	This view provides the shipment Data in the planning server and is not restricted by a demand plan. If the Planning Server is used for only one demand plan then we can go directly out of the fact table or this view. However if the planning
Implementation/DBA Data:	APPS.MSD_SHIPMENT_DATA_CS_V

View Text

SELECT 1 PRD_LEVEL_ID
, ITEM_PK.LEVEL_PK PRD_LEVEL_VALUE
, 11 GEO_LEVEL_ID
, SHIP_TO_LOC_PK.LEVEL_PK GEO_LEVEL_VALUE_PK
, 7 ORG_LEVEL_ID
, ORG_PK.LEVEL_PK ORG_LEVEL_VALUE_PK
, 18 REP_LEVEL_ID
, SALES_REP_PK.LEVEL_PK REP_LEVEL_VALUE_PK
, 27 CHN_LEVEL_ID
, SALES_CHANNEL_PK.LEVEL_PK CHN_LEVEL_VALUE_PK
, NULL UD1_LEVEL_ID
, NULL UD1_LEVEL_VALUE_PK
, NULL UD2_LEVEL_ID
, NULL UD2_LEVEL_VALUE_PK
, DECODE(PARENT_ITEM_PK.LEVEL_PK
, NULL
, NULL
, 1) PRD_PARENT_LEVEL_ID
, PARENT_ITEM_PK.LEVEL_PK PRD_PARENT_LEVEL_VALUE_PK
, 9 TIME_LEVEL_ID
, MSD.BOOKED_DATE
, MSD.REQUESTED_DATE
, MSD.PROMISED_DATE
, MSD.SHIPPED_DATE
, MSD.AMOUNT
, MSD.QTY_SHIPPED
, MSD.CREATION_DATE
, MSD.CREATED_BY
, MSD.LAST_UPDATE_DATE
, MSD.LAST_UPDATED_BY
, MSD.LAST_UPDATE_LOGIN
, MSD.LAST_REFRESH_NUM
, MSD.CREATED_BY_REFRESH_NUM
, MSD.ACTION_CODE
FROM MSD_SHIPMENT_DATA MSD
, MSD_LEVEL_VALUES ORG_PK
, MSD_LEVEL_VALUES ITEM_PK
, MSD_LEVEL_VALUES SALES_CHANNEL_PK
, MSD_LEVEL_VALUES SALES_REP_PK
, MSD_LEVEL_VALUES SHIP_TO_LOC_PK
, MSD_LEVEL_VALUES PARENT_ITEM_PK
WHERE (ORG_PK.INSTANCE = MSD.INSTANCE
AND ORG_PK.SR_LEVEL_PK = MSD.SR_INV_ORG_PK
AND ORG_PK.LEVEL_ID = 7)
AND (ITEM_PK.INSTANCE = MSD.INSTANCE
AND ITEM_PK.SR_LEVEL_PK = MSD.SR_ITEM_PK
AND ITEM_PK.LEVEL_ID = 1)
AND (SALES_CHANNEL_PK.INSTANCE = MSD.INSTANCE
AND SALES_CHANNEL_PK.SR_LEVEL_PK = MSD.SR_SALES_CHANNEL_PK
AND SALES_CHANNEL_PK.LEVEL_ID = 27)
AND (SALES_REP_PK.INSTANCE = MSD.INSTANCE
AND SALES_REP_PK.SR_LEVEL_PK = MSD.SR_SALES_REP_PK
AND SALES_REP_PK.LEVEL_ID = 18)
AND (SHIP_TO_LOC_PK.INSTANCE = MSD.INSTANCE
AND SHIP_TO_LOC_PK.SR_LEVEL_PK = MSD.SR_SHIP_TO_LOC_PK
AND SHIP_TO_LOC_PK.LEVEL_ID = 11)
AND (PARENT_ITEM_PK.INSTANCE(+) = MSD.INSTANCE
AND PARENT_ITEM_PK.SR_LEVEL_PK(+) = MSD.SR_PARENT_ITEM_PK
AND PARENT_ITEM_PK.LEVEL_ID(+) = 1 )

Columns