View: MSD_EVT_PRODUCT_DETAILS_V

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_V

View Text

SELECT ROW_ID
, INSTANCE
, EVENT_ID
, SEQ_ID
, DETAIL_ID
, TIME_LVL_VAL_FROM
, TIME_LVL_VAL_TO
, PRODUCT_LVL_ID
, PRODUCT_LVL_NAME
, PRODUCT_LVL_VAL
, PRODUCT_LVL_PK
, SR_PRODUCT_LVL_PK
, QTY_MODIFICATION_TYPE_ID
, PRICE_MODIFICATION_TYPE_ID
, QTY_MODIFICATION_TYPE
, PRICE_MODIFICATION_TYPE
, QTY_MODIFICATION_FACTOR
, PRICE_MODIFICATION_FACTOR
, GEOGRAPHY_LVL_ID
, GEOGRAPHY_LVL_NAME
, GEOGRAPHY_LVL_VAL
, GEOGRAPHY_LVL_PK
, SR_GEOGRAPHY_LVL_PK
, SALESCHANNEL_LVL_ID
, SALESCHANNEL_LVL_NAME
, SALESCHANNEL_LVL_VAL
, SALESCHANNEL_LVL_PK
, SR_SALESCHANNEL_LVL_PK
, SALESREP_LVL_ID
, SALESREP_LVL_NAME
, SALESREP_LVL_VAL
, SALESREP_LVL_PK
, SR_SALESREP_LVL_PK
, ORGANIZATION_LVL_ID
, ORGANIZATION_LVL_NAME
, ORGANIZATION_LVL_VAL
, ORGANIZATION_LVL_PK
, SR_ORGANIZATION_LVL_PK
, USER_DEFINED1_LVL_ID
, USER_DEFINED1_LVL_NAME
, USER_DEFINED1_LVL_VAL
, USER_DEFINED1_LVL_PK
, USER_DEFINED2_LVL_ID
, USER_DEFINED2_LVL_NAME
, USER_DEFINED2_LVL_VAL
, USER_DEFINED2_LVL_PK
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
FROM ( 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) PRODUCT_LVL_NAME
, PRD.LEVEL_VALUE PRODUCT_LVL_VAL
, PRD.LEVEL_PK PRODUCT_LVL_PK
, MED.SR_PRODUCT_LVL_PK
, PRD.SR_LEVEL_PK PRD_SR_LEVEL_PK
, MED.QTY_MODIFICATION_TYPE QTY_MODIFICATION_TYPE_ID
, MED.PRICE_MODIFICATION_TYPE PRICE_MODIFICATION_TYPE_ID
, FLV1.MEANING QTY_MODIFICATION_TYPE
, FLV2.MEANING PRICE_MODIFICATION_TYPE
, MED.QTY_MODIFICATION_FACTOR
, MED.PRICE_MODIFICATION_FACTOR
, MED.GEOGRAPHY_LVL_ID
, MSD_COMMON_UTILITIES.GET_LEVEL_NAME(MED.GEOGRAPHY_LVL_ID) GEOGRAPHY_LVL_NAME
, GEO.LEVEL_VALUE GEOGRAPHY_LVL_VAL
, GEO.LEVEL_PK GEOGRAPHY_LVL_PK
, MED.SR_GEOGRAPHY_LVL_PK
, GEO.SR_LEVEL_PK GEO_SR_LEVEL_PK
, MED.SALESCHANNEL_LVL_ID
, MSD_COMMON_UTILITIES.GET_LEVEL_NAME(MED.SALESCHANNEL_LVL_ID) SALESCHANNEL_LVL_NAME
, CHN.LEVEL_VALUE SALESCHANNEL_LVL_VAL
, CHN.LEVEL_PK SALESCHANNEL_LVL_PK
, MED.SR_SALESCHANNEL_LVL_PK
, CHN.SR_LEVEL_PK CHN_SR_LEVEL_PK
, MED.SALESREP_LVL_ID
, MSD_COMMON_UTILITIES.GET_LEVEL_NAME(MED.SALESREP_LVL_ID) SALESREP_LVL_NAME
, REP.LEVEL_VALUE SALESREP_LVL_VAL
, REP.LEVEL_PK SALESREP_LVL_PK
, MED.SR_SALESREP_LVL_PK
, REP.SR_LEVEL_PK REP_SR_LEVEL_PK
, MED.ORGANIZATION_LVL_ID
, MSD_COMMON_UTILITIES.GET_LEVEL_NAME(MED.ORGANIZATION_LVL_ID) ORGANIZATION_LVL_NAME
, ORG.LEVEL_VALUE ORGANIZATION_LVL_VAL
, ORG.LEVEL_PK ORGANIZATION_LVL_PK
, MED.SR_ORGANIZATION_LVL_PK
, ORG.SR_LEVEL_PK ORG_SR_LEVEL_PK
, MED.USER_DEFINED1_LVL_ID
, MSD_COMMON_UTILITIES.GET_LEVEL_NAME(MED.USER_DEFINED1_LVL_ID) USER_DEFINED1_LVL_NAME
, 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) USER_DEFINED2_LVL_NAME
, 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
, MSD_LEVEL_VALUES PRD
, MSD_LEVEL_VALUES ORG
, MSD_LEVEL_VALUES GEO
, MSD_LEVEL_VALUES CHN
, MSD_LEVEL_VALUES REP
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
AND PRD.INSTANCE (+) = MED.INSTANCE
AND PRD.LEVEL_ID (+) = MED.PRODUCT_LVL_ID
AND PRD.SR_LEVEL_PK(+) = MED.SR_PRODUCT_LVL_PK
AND ORG.INSTANCE (+) = MED.INSTANCE
AND ORG.LEVEL_ID(+) = MED.ORGANIZATION_LVL_ID
AND ORG.SR_LEVEL_PK(+) = MED.SR_ORGANIZATION_LVL_PK
AND GEO.INSTANCE (+) = MED.INSTANCE
AND GEO.LEVEL_ID(+) = MED.GEOGRAPHY_LVL_ID
AND GEO.SR_LEVEL_PK(+) = MED.SR_GEOGRAPHY_LVL_PK
AND CHN.INSTANCE (+) = MED.INSTANCE
AND CHN.LEVEL_ID(+) = MED.SALESCHANNEL_LVL_ID
AND CHN.SR_LEVEL_PK(+) = MED.SR_SALESCHANNEL_LVL_PK
AND REP.INSTANCE (+) = MED.INSTANCE
AND REP.LEVEL_ID(+) = MED.SALESREP_LVL_ID
AND REP.SR_LEVEL_PK(+) = MED.SR_SALESREP_LVL_PK)
WHERE (PRD_SR_LEVEL_PK = SR_PRODUCT_LVL_PK OR SR_PRODUCT_LVL_PK IS NULL)
AND (ORG_SR_LEVEL_PK = SR_ORGANIZATION_LVL_PK OR SR_ORGANIZATION_LVL_PK IS NULL)
AND (GEO_SR_LEVEL_PK = SR_GEOGRAPHY_LVL_PK OR SR_GEOGRAPHY_LVL_PK IS NULL)
AND (CHN_SR_LEVEL_PK = SR_SALESCHANNEL_LVL_PK OR SR_SALESCHANNEL_LVL_PK IS NULL)
AND (REP_SR_LEVEL_PK = SR_SALESREP_LVL_PK OR SR_SALESREP_LVL_PK IS NULL)

Columns