View: MSD_EVENTS_V

Product:	MSD - Demand Planning
Description:	This API defines the types of Events and is the header to the MSD_EVENT_PRODUCTS_V API. This is based on top of the MSD_EVENTS table.
Implementation/DBA Data:	APPS.MSD_EVENTS_V

View Text

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.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
, 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'

Columns