View: MSD_BOOKING_DATA_ORIG_CS_V

Product:	MSD - Demand Planning
Description:	This view to support product substitution in booking data
Implementation/DBA Data:	APPS.MSD_BOOKING_DATA_ORIG_CS_V

View Text

SELECT 1 PRD_LEVEL_ID
, ITEM_PK.LEVEL_PK PRD_LEVEL_VALUE_PK
, 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
, MBD.BOOKED_DATE
, MBD.REQUESTED_DATE
, MBD.PROMISED_DATE
, MBD.SCHEDULED_DATE
, MBD.AMOUNT
, MBD.QTY_ORDERED
, MBD.CREATION_DATE
, MBD.CREATED_BY
, MBD.LAST_UPDATE_DATE
, MBD.LAST_UPDATED_BY
, MBD.LAST_UPDATE_LOGIN
, MBD.LAST_REFRESH_NUM
, MBD.CREATED_BY_REFRESH_NUM
, MBD.ACTION_CODE
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
, MSD_LEVEL_VALUES PARENT_ITEM_PK
WHERE (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.INSTANCE = MBD.INSTANCE
AND ITEM_PK.SR_LEVEL_PK = MBD.SR_ORIGINAL_ITEM_PK
AND ITEM_PK.LEVEL_ID = 1)
AND (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.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.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)
AND (PARENT_ITEM_PK.INSTANCE(+) = MBD.INSTANCE
AND PARENT_ITEM_PK.SR_LEVEL_PK(+) = MBD.SR_PARENT_ITEM_PK
AND PARENT_ITEM_PK.LEVEL_ID(+) = 1 )

Columns