View: MSD_EVENT_PRODUCTS_V1

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_V1

View Text

SELECT MEP.ROWID ROW_ID
, MEP.INSTANCE
, MEP.EVENT_ID
, MEP.SEQ_ID
, MEP.PRODUCT_LVL_ID
, MLV.LEVEL_NAME
, MEP.PRODUCT_LVL_VAL
, MSD_COMMON_UTILITIES.GET_ITEM_KEY(MEP.INSTANCE
, MEP.SR_PRODUCT_LVL_PK
, MEP.PRODUCT_LVL_VAL
, MEP.PRODUCT_LVL_ID)
, 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
WHERE ME.EVENT_ID = MEP.EVENT_ID AND MLV.LEVEL_ID = MEP.PRODUCT_LVL_ID
AND MLV.DIMENSION_CODE = 'PRD'

Columns