View: MSD_EVENT_PRODUCTS_V

Product:	MSD - Demand Planning
Description:	This API is a child to the MSD_EVENTS_V API. This API holds information about all the products for which the promotion is run and the start and end date for each event.
Implementation/DBA Data:	APPS.MSD_EVENT_PRODUCTS_V

View Text

SELECT MEP.ROWID ROW_ID
, MEP.INSTANCE
, MEP.EVENT_ID
, MEP.SEQ_ID
, MEP.PRODUCT_LVL_ID
, MLV.LEVEL_NAME
, ITEM.LEVEL_VALUE
, ITEM.LEVEL_PK
, MEP.SR_PRODUCT_LVL_PK
, MEP.START_TIME
, MEP.END_TIME
, MEP.LAST_UPDATE_DATE
, MEP.LAST_UPDATED_BY
, MEP.CREATION_DATE
, MEP.CREATED_BY
, MEP.LAST_UPDATE_LOGIN
, MEP.REQUEST_ID
, MEP.PROGRAM_APPLICATION_ID
, MEP.PROGRAM_ID
, MEP.PROGRAM_UPDATE_DATE FROM MSD_EVENTS ME
, MSD_EVENT_PRODUCTS MEP
, MSD_LEVELS MLV
, MSD_LEVEL_VALUES ITEM
WHERE ME.EVENT_ID = MEP.EVENT_ID AND MLV.LEVEL_ID = MEP.PRODUCT_LVL_ID
AND MLV.DIMENSION_CODE = 'PRD'
AND ITEM.SR_LEVEL_PK = MEP.SR_PRODUCT_LVL_PK
AND ITEM.LEVEL_ID = MEP.PRODUCT_LVL_ID
AND ITEM.INSTANCE = MEP.INSTANCE

Columns