View: BIM_DIMV_EVENT_HEADERS

Product:	BIM - Marketing Intelligence(Obsolete)
Description:	Shows all events.
Implementation/DBA Data:	APPS.BIM_DIMV_EVENT_HEADERS

View Text

SELECT 'EVEH' || TO_CHAR(EVTH.EVENT_HEADER_ID) ID
, SUBSTR(EVTH.EVENT_HEADER_NAME
, 1
, 80)
, 'EVEH' || TO_CHAR(EVTH.EVENT_HEADER_ID) EVENT_ID
, EVTH.EVENT_HEADER_NAME EVENT_NAME
, EVTH.DESCRIPTION EVENT_DESCRIPTION
, EVTH.EVENT_TYPE_CODE EVENT_TYPE
, EVTH.EVENT_LEVEL EVENT_LEVEL
, EVTH.SYSTEM_STATUS_CODE EVENT_STATUS_CODE
, EVTH.LAST_STATUS_DATE EVENT_STATUS_DATE
, EVTH.SOURCE_CODE EVENT_SOURCE_CODE
, EVTH.EVENT_STANDALONE_FLAG EVENT_STANDALONE_FLAG
, EVTH.ACTIVE_FROM_DATE ACTIVE_FROM_DATE
, EVTH.ACTIVE_TO_DATE ACTIVE_TO_DATE
, EVTH.ACTIVE_FLAG EVENT_ACTIVE_FLAG
, EVTH.INVENTORY_ITEM_ID EVENT_ITEM_ID
, DECODE( EVTH.PARENT_EVENT_HEADER_ID
, NULL
, NULL
, 'EVEH' || TO_CHAR(EVTH.PARENT_EVENT_HEADER_ID)) PARENT_EVENT_HEADER_ID
, NULL ORG_ID
FROM AMS_EVENT_HEADERS_VL EVTH
WHERE EVTH.EVENT_LEVEL = 'MAIN' WITH READ ONLY

Columns