View: MSD_NPI_RELATED_PROD_DTLS_V1

Product:	MSD - Demand Planning
Description:	This API holds DETAILS information for New Product Introductions. Used by the Events Form.
Implementation/DBA Data:	APPS.MSD_NPI_RELATED_PROD_DTLS_V1

View Text

SELECT MED.ROWID ROW_ID
, MED.INSTANCE
, MED.EVENT_ID
, MED.SEQ_ID
, MED.DETAIL_ID
, MPR.RELATION_ID
, MPR.PRODUCT_LVL_ID
, MSD_COMMON_UTILITIES.GET_LEVEL_NAME(MED.PRODUCT_LVL_ID)
, MPR.PRODUCT_LVL_VAL
, MSD_COMMON_UTILITIES.GET_ITEM_KEY(MPR.INSTANCE
, MPR.SR_PRODUCT_LVL_PK
, MPR.PRODUCT_LVL_VAL
, MPR.PRODUCT_LVL_ID)
, MPR.SR_PRODUCT_LVL_PK
, (100 - MPR.QTY_MODIFICATION_FACTOR)
, MPR.LAG
, MPR.START_TIME
, MPR.END_TIME
, MPR.QTY_MODIFICATION_TYPE
, FLV1.MEANING
, MPR.QTY_MODIFICATION_FACTOR
, MPR.NPI_PROD_RELATIONSHIP
, FLV.MEANING
, 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 FLV
, MSD_EVENTS ME
, MSD_EVENT_PRODUCTS MEP
, MSD_EVT_PRODUCT_DETAILS MED
, MSD_EVT_PROD_RELATIONSHIPS MPR
WHERE FLV1.LOOKUP_CODE (+) = MPR.QTY_MODIFICATION_TYPE AND FLV1.LOOKUP_TYPE (+) = 'MSD_MODIFICATION_TYPE' AND ME.EVENT_ID = MEP.EVENT_ID AND MPR.EVENT_ID = MEP.EVENT_ID AND MPR.SEQ_ID = MEP.SEQ_ID AND MED.RELATION_ID = MPR.RELATION_ID
AND MED.EVENT_ID = MPR.EVENT_ID
AND MED.SEQ_ID = MPR.SEQ_ID AND MED.RELATION_ID IS NOT NULL
AND FLV.LOOKUP_CODE = MPR.NPI_PROD_RELATIONSHIP AND FLV.LOOKUP_TYPE = 'MSD_RELATIONSHIP_TYPE'

Columns