View: MSD_NPI_RELATED_PRODUCTS_V1

Product:	MSD - Demand Planning
Description:	This API holds information on New Product Introduction Related Products. Used by the Events Form.
Implementation/DBA Data:	APPS.MSD_NPI_RELATED_PRODUCTS_V1

View Text

SELECT MED.ROWID ROW_ID
, MED.INSTANCE
, MED.EVENT_ID
, MED.SEQ_ID
, MED.RELATION_ID
, MED.LAG
, MED.START_TIME
, 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
, FLV1.MEANING
, MED.QTY_MODIFICATION_FACTOR
, 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
, MSD_EVT_PROD_RELATIONSHIPS MED
WHERE FLV1.LOOKUP_CODE (+) = MED.QTY_MODIFICATION_TYPE AND FLV1.LOOKUP_TYPE (+) = 'MSD_MODIFICATION_TYPE' AND MED.NPI_PROD_RELATIONSHIP = '1'

Columns