VIEW: APPS.MSD_EVENT_PRODUCTS_V1

Source

View Text - Preformatted

SELECT mep.rowid row_id, mep.instance, mep.event_id, mep.seq_id, mep.product_lvl_id, mlv.level_name, mep.product_lvl_val, msd_common_utilities.get_item_key(mep.instance, mep.sr_product_lvl_pk, mep.product_lvl_val, mep.product_lvl_id), 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, msd_common_utilities.get_dp_enabled_flag(mep.instance, mep.sr_product_lvl_pk, mep.product_lvl_val, mep.product_lvl_id) FROM msd_events me, msd_event_products mep, msd_levels mlv WHERE me.event_id = mep.event_id AND mlv.level_id = mep.product_lvl_id AND mlv.dimension_code = 'PRD' 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
, MEP.PRODUCT_LVL_VAL
, MSD_COMMON_UTILITIES.GET_ITEM_KEY(MEP.INSTANCE
, MEP.SR_PRODUCT_LVL_PK
, MEP.PRODUCT_LVL_VAL
, MEP.PRODUCT_LVL_ID)
, 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
, MSD_COMMON_UTILITIES.GET_DP_ENABLED_FLAG(MEP.INSTANCE
, MEP.SR_PRODUCT_LVL_PK
, MEP.PRODUCT_LVL_VAL
, MEP.PRODUCT_LVL_ID)
FROM MSD_EVENTS ME
, MSD_EVENT_PRODUCTS MEP
, MSD_LEVELS MLV
WHERE ME.EVENT_ID = MEP.EVENT_ID
AND MLV.LEVEL_ID = MEP.PRODUCT_LVL_ID
AND MLV.DIMENSION_CODE = 'PRD'
AND MLV.PLAN_TYPE IS NULL