View: MSD_SHIPMENT_DATA_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_V

View Text

SELECT ORG_PK.LEVEL_VALUE
, ORG_PK.LEVEL_PK INV_ORG_PK
, ITEM_PK.LEVEL_VALUE
, ITEM_PK.LEVEL_PK ITEM_PK
, SALES_CHANNEL_PK.LEVEL_VALUE
, SALES_CHANNEL_PK.LEVEL_PK SALES_CHANNEL_PK
, SALES_REP_PK.LEVEL_VALUE
, SALES_REP_PK.LEVEL_PK SALES_REP_PK
, SHIP_TO_LOC_PK.LEVEL_VALUE
, SHIP_TO_LOC_PK.LEVEL_PK SHIP_TO_LOC_PK
, MSD.USER_DEFINED1
, NULL USER_DEFINED1_PK
, MSD.USER_DEFINED2
, NULL USER_DEFINED2_PK
, MSD.BOOKED_DATE
, MSD.REQUESTED_DATE
, MSD.PROMISED_DATE
, MSD.SHIPPED_DATE
, MSD.AMOUNT
, MSD.QTY_SHIPPED
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
WHERE /* INV_ORG_PK */ (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 */ (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 */ (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 */ (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 */ (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)

Columns