VIEW: APPS.MSD_NPI_RELATED_PRODUCTS_V1

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), 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, msd_common_utilities.get_dp_enabled_flag(med.instance, med.sr_product_lvl_pk, med.product_lvl_val, med.product_lvl_id) 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'

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)
, 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
, MSD_COMMON_UTILITIES.GET_DP_ENABLED_FLAG(MED.INSTANCE
, MED.SR_PRODUCT_LVL_PK
, MED.PRODUCT_LVL_VAL
, MED.PRODUCT_LVL_ID)
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'