Product: | BIM - Marketing Intelligence |
---|---|
Description: | Shows all event offers. |
Implementation/DBA Data: | APPS.BIM_DIMV_EVENT_OFFERS |
SELECT 'EVEO' || TO_CHAR(EVTO.EVENT_OFFER_ID) ID
, SUBSTR(EVTO.EVENT_OFFER_NAME
, 1
, 80) VALUE
, 'EVEO' || TO_CHAR(EVTO.EVENT_OFFER_ID) EVENT_OFFER_ID
, EVTO.EVENT_OFFER_NAME EVENT_OFFER_NAME
, EVTO.DESCRIPTION EVENT_OFFER_DESCRIPTION
, 'EVEH' || TO_CHAR(EVTO.EVENT_HEADER_ID) EVENT_HEADER_ID
, 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.REG_REQUIRED_FLAG REG_REQUIRED_FLAG
, EVTO.EVENT_LANGUAGE_CODE EVENT_LANGUAGE_CODE
, UPPER(HZL.COUNTRY||'>>'||HZL.STATE||'>>'||HZL.CITY||'>>'||HZL.POSTAL_CODE) EVENT_LOCATION_CODE
, EVTO.EVENT_STANDALONE_FLAG EVENT_STAND_ALONE_FLAG
, DECODE(EVTO.PARENT_EVENT_OFFER_ID
, NULL
, NULL
, 'EVEO' || TO_CHAR(EVTO.PARENT_EVENT_OFFER_ID)) MAIN_EVENT_OFFER_ID
, 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 REG_START_DATE
, EVTO.REG_END_DATE REG_END_DATE
, EVTO.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, NULL ORG_ID
FROM AMS_EVENT_OFFERS_VL EVTO
, HZ_LOCATIONS HZL
WHERE EVTO.EVENT_LEVEL = 'MAIN'
AND EVTO.EVENT_LOCATION_ID = HZL.LOCATION_ID (+) WITH READ ONLY