VIEW: APPS.MSD_EVENTS_V

Source

View Text - Preformatted

SELECT me.ROWID ROW_ID, me.INSTANCE, me.EVENT_ID, me.EVENT_NAME, me.EVENT_DESCRIPTION, me.EVENT_TYPE, flv1.MEANING, me.INTRODUCTION_TYPE, flv2.MEANING, me.EVENT_PRIORITY, me.FORECAST_BASIS, flv3.meaning, me.AUTO_UPDATE_SS_FLAG, me.LAST_UPDATE_DATE, me.LAST_UPDATED_BY, me.CREATION_DATE, me.CREATED_BY, me.LAST_UPDATE_LOGIN, me.REQUEST_ID, me.PROGRAM_APPLICATION_ID, me.PROGRAM_ID, me.PROGRAM_UPDATE_DATE FROM fnd_lookup_values_vl flv1, fnd_lookup_values_vl flv2, fnd_lookup_values_vl flv3, msd_events me WHERE flv1.lookup_code = me.event_type AND flv1.lookup_type = 'MSD_EVENT_TYPE' AND flv2.lookup_code (+) = me.introduction_type AND flv2.lookup_type (+) = 'MSD_INTRODUCTION_TYPE' AND flv3.lookup_code (+) = me.forecast_basis AND flv3.lookup_type (+) = 'MSD_FORECAST_BASIS'

View Text - HTML Formatted

SELECT ME.ROWID ROW_ID
, ME.INSTANCE
, ME.EVENT_ID
, ME.EVENT_NAME
, ME.EVENT_DESCRIPTION
, ME.EVENT_TYPE
, FLV1.MEANING
, ME.INTRODUCTION_TYPE
, FLV2.MEANING
, ME.EVENT_PRIORITY
, ME.FORECAST_BASIS
, FLV3.MEANING
, ME.AUTO_UPDATE_SS_FLAG
, ME.LAST_UPDATE_DATE
, ME.LAST_UPDATED_BY
, ME.CREATION_DATE
, ME.CREATED_BY
, ME.LAST_UPDATE_LOGIN
, ME.REQUEST_ID
, ME.PROGRAM_APPLICATION_ID
, ME.PROGRAM_ID
, ME.PROGRAM_UPDATE_DATE
FROM FND_LOOKUP_VALUES_VL FLV1
, FND_LOOKUP_VALUES_VL FLV2
, FND_LOOKUP_VALUES_VL FLV3
, MSD_EVENTS ME
WHERE FLV1.LOOKUP_CODE = ME.EVENT_TYPE
AND FLV1.LOOKUP_TYPE = 'MSD_EVENT_TYPE'
AND FLV2.LOOKUP_CODE (+) = ME.INTRODUCTION_TYPE
AND FLV2.LOOKUP_TYPE (+) = 'MSD_INTRODUCTION_TYPE'
AND FLV3.LOOKUP_CODE (+) = ME.FORECAST_BASIS
AND FLV3.LOOKUP_TYPE (+) = 'MSD_FORECAST_BASIS'