View: MSD_EVT_PRODUCT_DETAILS_V1

Product:	MSD - Demand Planning
Description:	This API is a child to the MSD_EVENTS_PRODUCTS_V API. This API holds time frame for which this product promotion is run and the corresponding modification factor. In the case of New Product Introductions, the modifications are based on rel
Implementation/DBA Data:	APPS.MSD_EVT_PRODUCT_DETAILS_V1

View Text

SELECT MED.ROWID ROW_ID
, MED.INSTANCE
, MED.EVENT_ID
, MED.SEQ_ID
, MED.DETAIL_ID
, MED.TIME_LVL_VAL_FROM
, MED.TIME_LVL_VAL_TO
, MED.PRODUCT_LVL_ID
, MSD_COMMON_UTILITIES.GET_LEVEL_NAME(MED.PRODUCT_LVL_ID)
, MED.PRODUCT_LVL_VAL
, MSD_COMMON_UTILITIES.GET_ITEM_KEY(MED.INSTANCE
, MED.SR_PRODUCT_LVL_PK
, MED.PRODUCT_LVL_VAL
, MED.PRODUCT_LVL_ID)
, MED.SR_PRODUCT_LVL_PK
, MED.QTY_MODIFICATION_TYPE
, MED.PRICE_MODIFICATION_TYPE
, FLV1.MEANING
, FLV2.MEANING
, MED.QTY_MODIFICATION_FACTOR
, MED.PRICE_MODIFICATION_FACTOR
, MED.GEOGRAPHY_LVL_ID
, MSD_COMMON_UTILITIES.GET_LEVEL_NAME(MED.GEOGRAPHY_LVL_ID)
, MED.GEOGRAPHY_LVL_VAL
, MSD_COMMON_UTILITIES.GET_LOC_KEY(MED.INSTANCE
, MED.SR_GEOGRAPHY_LVL_PK
, MED.GEOGRAPHY_LVL_VAL
, MED.GEOGRAPHY_LVL_ID)
, MED.SR_GEOGRAPHY_LVL_PK
, MED.SALESCHANNEL_LVL_ID
, MSD_COMMON_UTILITIES.GET_LEVEL_NAME(MED.SALESCHANNEL_LVL_ID)
, MED.SALESCHANNEL_LVL_VAL
, MSD_COMMON_UTILITIES.GET_SC_KEY(MED.INSTANCE
, MED.SR_SALESCHANNEL_LVL_PK
, MED.SALESCHANNEL_LVL_VAL
, MED.SALESCHANNEL_LVL_ID)
, MED.SR_SALESCHANNEL_LVL_PK
, MED.SALESREP_LVL_ID
, MSD_COMMON_UTILITIES.GET_LEVEL_NAME(MED.SALESREP_LVL_ID)
, MED.SALESREP_LVL_VAL
, MSD_COMMON_UTILITIES.GET_SALESREP_KEY(MED.INSTANCE
, MED.SR_SALESREP_LVL_PK
, MED.SALESREP_LVL_VAL
, MED.SALESREP_LVL_ID)
, MED.SR_SALESREP_LVL_PK
, MED.ORGANIZATION_LVL_ID
, MSD_COMMON_UTILITIES.GET_LEVEL_NAME(MED.ORGANIZATION_LVL_ID)
, MED.ORGANIZATION_LVL_VAL
, MSD_COMMON_UTILITIES.GET_ORG_KEY(MED.INSTANCE
, MED.SR_ORGANIZATION_LVL_PK
, MED.ORGANIZATION_LVL_VAL
, MED.ORGANIZATION_LVL_ID)
, MED.SR_ORGANIZATION_LVL_PK
, MED.USER_DEFINED1_LVL_ID
, MSD_COMMON_UTILITIES.GET_LEVEL_NAME(MED.USER_DEFINED1_LVL_ID)
, MED.USER_DEFINED1_LVL_VAL
, MED.USER_DEFINED1_LVL_PK
, MED.USER_DEFINED2_LVL_ID
, MSD_COMMON_UTILITIES.GET_LEVEL_NAME(MED.USER_DEFINED2_LVL_ID)
, MED.USER_DEFINED2_LVL_VAL
, MED.USER_DEFINED2_LVL_PK
, MED.LAST_UPDATE_DATE
, MED.LAST_UPDATED_BY
, MED.CREATION_DATE
, MED.CREATED_BY
, MED.LAST_UPDATE_LOGIN
, MED.REQUEST_ID
, MED.PROGRAM_APPLICATION_ID
, MED.PROGRAM_ID
, MED.PROGRAM_UPDATE_DATE
FROM FND_LOOKUP_VALUES_VL FLV1
, FND_LOOKUP_VALUES_VL FLV2
, MSD_EVENTS ME
, MSD_EVENT_PRODUCTS MEP
, MSD_EVT_PRODUCT_DETAILS MED
WHERE FLV1.LOOKUP_CODE (+) = MED.QTY_MODIFICATION_TYPE
AND FLV1.LOOKUP_TYPE (+) = 'MSD_MODIFICATION_TYPE'
AND FLV2.LOOKUP_CODE (+) = MED.PRICE_MODIFICATION_TYPE
AND FLV2.LOOKUP_TYPE (+) = 'MSD_MODIFICATION_TYPE'
AND ME.EVENT_ID = MEP.EVENT_ID
AND MEP.EVENT_ID = MED.EVENT_ID
AND MEP.SEQ_ID = MED.SEQ_ID
AND MED.RELATION_ID IS NULL

Columns