View: MSD_BOOKING_DATA_V

Product:	MSD - Demand Planning
Description:	This view provides the Booking 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 S
Implementation/DBA Data:	APPS.MSD_BOOKING_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
, MBD.USER_DEFINED1
, NULL USER_DEFINED1_PK
, MBD.USER_DEFINED2
, NULL USER_DEFINED2_PK
, MBD.BOOKED_DATE
, MBD.REQUESTED_DATE
, MBD.PROMISED_DATE
, MBD.SCHEDULED_DATE
, MBD.AMOUNT
, MBD.QTY_ORDERED
FROM MSD_BOOKING_DATA MBD
, 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 = MBD.INSTANCE
AND ORG_PK.SR_LEVEL_PK = MBD.SR_INV_ORG_PK
AND ORG_PK.LEVEL_ID = 7)
AND /* ITEM_PK*/ (ITEM_PK.INSTANCE = MBD.INSTANCE
AND ITEM_PK.SR_LEVEL_PK = MBD.SR_ITEM_PK
AND ITEM_PK.LEVEL_ID = 1)
AND /* SALES_CHANNEL_PK */ (SALES_CHANNEL_PK.INSTANCE = MBD.INSTANCE
AND SALES_CHANNEL_PK.SR_LEVEL_PK = MBD.SR_SALES_CHANNEL_PK
AND SALES_CHANNEL_PK.LEVEL_ID = 27)
AND /* SALES_REP_PK */ (SALES_REP_PK.INSTANCE = MBD.INSTANCE
AND SALES_REP_PK.SR_LEVEL_PK = MBD.SR_SALES_REP_PK
AND SALES_REP_PK.LEVEL_ID = 18)
AND /* SHIP_TO_LOC_PK */ (SHIP_TO_LOC_PK.INSTANCE = MBD.INSTANCE
AND SHIP_TO_LOC_PK.SR_LEVEL_PK = MBD.SR_SHIP_TO_LOC_PK
AND SHIP_TO_LOC_PK.LEVEL_ID = 11)

Columns