View: AMS_EVENT_OFFERS_AGENDA_V

Product:	AMS - Marketing
Description:	This view returns the general information about marketing event offering agenda.
Implementation/DBA Data:	APPS.AMS_EVENT_OFFERS_AGENDA_V

View Text

SELECT EVO.ROW_ID
, EVO.INBOUND_SCRIPT_NAME
, EVO.STREAM_TYPE_CODE
, EVO.OWNER_USER_ID
, EVO.EVENT_OFFER_ID
, EVO.LAST_UPDATE_DATE
, EVO.LAST_UPDATED_BY
, EVO.CREATION_DATE
, EVO.CREATED_BY
, EVO.LAST_UPDATE_LOGIN
, EVO.OBJECT_VERSION_NUMBER
, EVO.APPLICATION_ID
, EVO.EVENT_HEADER_ID
, EVH.EVENT_HEADER_NAME
, EVO.PRIVATE_FLAG
, EVO.ACTIVE_FLAG
, EVO.EVENT_LEVEL
, EVO.USER_STATUS_ID
, AUS.NAME
, EVO.LAST_STATUS_DATE
, EVO.SYSTEM_STATUS_CODE
, EVO.EVENT_DELIVERY_METHOD_ID
, ADM.DELIVERY_MEDIA_NAME
, EVO.EVENT_REQUIRED_FLAG
, EVO.EVENT_LANGUAGE_CODE
, LANG.NLS_LANGUAGE
, EVO.EVENT_VENUE_ID
, VEN.VENUE_NAME
, EVO.EVENT_LOCATION_ID
, HZL.CITY||'
, '||HZL.STATE||'
, '||HZL.COUNTRY
, HZL.CITY
, HZL.STATE
, HZL.PROVINCE
, HZL.COUNTRY
, EVO.PARTNER_FLAG
, EVO.EVENT_STANDALONE_FLAG
, EVO.PARENT_EVENT_OFFER_ID
, PEVO.EVENT_OFFER_NAME
, EVO.EVENT_START_DATE
, EVO.EVENT_START_DATE_TIME
, EVO.EVENT_END_DATE
, EVO.EVENT_END_DATE_TIME
, EVO.CERT_CREDIT_TYPE_CODE
, EVO.CERTIFICATION_CREDITS
, EVO.COORDINATOR_ID
, EVO.URL
, EVO.PHONE
, EVO.EMAIL
, EVO.TIMEZONE_ID
, HTZ.NAME
, EVO.EVENT_OFFER_NAME
FROM AMS_EVENT_OFFERS_VL EVO
, AMS_EVENT_OFFERS_VL PEVO
, AMS_EVENT_HEADERS_VL EVH
, AMS_USER_STATUSES_VL AUS
, FND_LANGUAGES_VL LANG
, AMS_ACT_DELIVERY_METHODS_V ADM
, HZ_TIMEZONES_VL HTZ
, HZ_LOCATIONS HZL
, AMS_VENUES_VL VEN
WHERE EVO.EVENT_LEVEL='SUB'
AND EVO.PARENT_EVENT_OFFER_ID = PEVO.EVENT_OFFER_ID(+)
AND EVO.EVENT_HEADER_ID=EVH.EVENT_HEADER_ID(+)
AND EVO.USER_STATUS_ID=AUS.USER_STATUS_ID
AND EVO.EVENT_LANGUAGE_CODE=LANG.LANGUAGE_CODE(+)
AND EVO.EVENT_VENUE_ID=VEN.VENUE_ID(+)
AND EVO.TIMEZONE_ID=HTZ.TIMEZONE_ID(+)
AND EVO.EVENT_DELIVERY_METHOD_ID=ADM.ACTIVITY_DELIVERY_METHOD_ID(+)
AND EVO.EVENT_LOCATION_ID=HZL.LOCATION_ID(+)

Columns