View: BIM_DIMV_EVENT_HIER

Product:	BIM - Marketing Intelligence
Description:	Shows relationship between events and event offerings.
Implementation/DBA Data:	APPS.BIM_DIMV_EVENT_HIER

View Text

SELECT '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_CODE
, LKP.MEANING EVENT_TYPE_NAME
, 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
, 'EVEO' || TO_CHAR(EVTO.EVENT_OFFER_ID) EVENT_OFFER_ID
, EVTO.EVENT_OFFER_NAME EVENT_OFFER_NAME
, EVTO.DESCRIPTION EVENT_OFFER_DESCRIPTION
, DECODE( EVTO.PARENT_EVENT_OFFER_ID
, NULL
, NULL
, 'EVEO' || TO_CHAR(EVTO.PARENT_EVENT_OFFER_ID)) PARENT_EVENT_OFFER_ID
, EVTO.SOURCE_CODE EVENT_OFFER_SOURCE_CODE
, EVTO.SYSTEM_STATUS_CODE EVENT_OFFER_STATUS_CODE
, EVTO.LAST_STATUS_DATE EVENT_OFFER_STATUS_DATE
, EVTO.ACTIVE_FLAG EVENT_OFFER_ACTIVE_FLAG
, EVTO.EVENT_DURATION EVENT_OFFER_DURATION
, EVTO.EVENT_START_DATE EVENT_OFFER_START_DATE
, EVTO.EVENT_END_DATE EVENT_OFFER_END_DATE
, EVTO.REG_START_DATE EVENT_OFFER_REG_START_DATE
, EVTO.REG_END_DATE EVENT_OFFER_REG_END_DATE
, EVTO.INVENTORY_ITEM_ID EVENT_OFFER_ITEM_ID
FROM AMS_LOOKUPS LKP
, AMS_EVENT_HEADERS_VL EVTH
, AMS_EVENT_OFFERS_VL EVTO
WHERE EVTH.EVENT_HEADER_ID = EVTO.EVENT_HEADER_ID
AND EVTH.EVENT_TYPE_CODE = LKP.LOOKUP_CODE
AND LKP.LOOKUP_TYPE = 'AMS_EVENT_TYPE' UNION ALL SELECT '-999'
, MEANING
, NULL
, '-999'
, MEANING
, NULL
, NULL
, TO_DATE(NULL)
, NULL
, NULL
, TO_DATE(NULL)
, TO_DATE(NULL)
, NULL
, TO_NUMBER(NULL)
, NULL
, NULL
, '-999'
, MEANING
, NULL
, NULL
, NULL
, NULL
, TO_DATE(NULL)
, NULL
, TO_NUMBER(NULL)
, TO_DATE(NULL)
, TO_DATE(NULL)
, TO_DATE(NULL)
, TO_DATE(NULL)
, TO_NUMBER(NULL)
FROM FND_LOOKUPS
WHERE LOOKUP_TYPE = 'BIM_VALUE_TYPE'
AND LOOKUP_CODE = '-999' WITH READ ONLY

Columns