VIEW: APPS.MSD_NPI_RELATED_PRODUCTS_V

Source

View Text - Preformatted

SELECT med.rowid row_id, med.instance, med.event_id, med.seq_id, med.relation_id, med.lag, med.start_time, med.end_time, med.product_lvl_id, msd_common_utilities.get_level_name(med.product_lvl_id), item.level_value, item.level_pk, 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, msd_level_values item WHERE flv1.lookup_code (+) = med.qty_modification_type AND flv1.lookup_type (+) = 'MSD_MODIFICATION_TYPE' AND med.npi_prod_relationship = '1' AND item.instance = med.instance AND item.level_id = med.product_lvl_id AND item.sr_level_pk = med.sr_product_lvl_pk

View Text - HTML Formatted

SELECT MED.ROWID ROW_ID
, MED.INSTANCE
, MED.EVENT_ID
, MED.SEQ_ID
, MED.RELATION_ID
, MED.LAG
, MED.START_TIME
, MED.END_TIME
, MED.PRODUCT_LVL_ID
, MSD_COMMON_UTILITIES.GET_LEVEL_NAME(MED.PRODUCT_LVL_ID)
, ITEM.LEVEL_VALUE
, ITEM.LEVEL_PK
, 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
, MSD_LEVEL_VALUES ITEM
WHERE FLV1.LOOKUP_CODE (+) = MED.QTY_MODIFICATION_TYPE
AND FLV1.LOOKUP_TYPE (+) = 'MSD_MODIFICATION_TYPE'
AND MED.NPI_PROD_RELATIONSHIP = '1'
AND ITEM.INSTANCE = MED.INSTANCE
AND ITEM.LEVEL_ID = MED.PRODUCT_LVL_ID
AND ITEM.SR_LEVEL_PK = MED.SR_PRODUCT_LVL_PK