VIEW: APPS.MSD_EVENT_PRODUCTS_V

Source

View Text - Preformatted

SELECT mep.rowid row_id, mep.instance, mep.event_id, mep.seq_id, mep.product_lvl_id, mlv.level_name, item.level_value, item.level_pk, mep.sr_product_lvl_pk, mep.start_time, mep.end_time, mep.last_update_date, mep.last_updated_by, mep.creation_date, mep.created_by, mep.last_update_login, mep.request_id, mep.program_application_id, mep.program_id, mep.program_update_date FROM msd_events me, msd_event_products mep, msd_levels mlv, msd_level_values item WHERE me.event_id = mep.event_id AND mlv.level_id = mep.product_lvl_id AND mlv.dimension_code = 'PRD' AND item.sr_level_pk = mep.sr_product_lvl_pk AND item.level_id = mep.product_lvl_id AND item.instance = mep.instance and mlv.plan_type is null

View Text - HTML Formatted

SELECT MEP.ROWID ROW_ID
, MEP.INSTANCE
, MEP.EVENT_ID
, MEP.SEQ_ID
, MEP.PRODUCT_LVL_ID
, MLV.LEVEL_NAME
, ITEM.LEVEL_VALUE
, ITEM.LEVEL_PK
, MEP.SR_PRODUCT_LVL_PK
, MEP.START_TIME
, MEP.END_TIME
, MEP.LAST_UPDATE_DATE
, MEP.LAST_UPDATED_BY
, MEP.CREATION_DATE
, MEP.CREATED_BY
, MEP.LAST_UPDATE_LOGIN
, MEP.REQUEST_ID
, MEP.PROGRAM_APPLICATION_ID
, MEP.PROGRAM_ID
, MEP.PROGRAM_UPDATE_DATE
FROM MSD_EVENTS ME
, MSD_EVENT_PRODUCTS MEP
, MSD_LEVELS MLV
, MSD_LEVEL_VALUES ITEM
WHERE ME.EVENT_ID = MEP.EVENT_ID
AND MLV.LEVEL_ID = MEP.PRODUCT_LVL_ID
AND MLV.DIMENSION_CODE = 'PRD'
AND ITEM.SR_LEVEL_PK = MEP.SR_PRODUCT_LVL_PK
AND ITEM.LEVEL_ID = MEP.PRODUCT_LVL_ID
AND ITEM.INSTANCE = MEP.INSTANCE
AND MLV.PLAN_TYPE IS NULL