View: AMS_P_EVENT_CAMPAIGNS_V

Product:	AMS - Marketing
Description:	This public view returns all marketing campaigns promoting marketing events.
Implementation/DBA Data:	APPS.AMS_P_EVENT_CAMPAIGNS_V

View Text

SELECT E.EVENT_OFFER_ID EVENT_OFFER_ID
, E.EVENT_OFFER_NAME EVENT_OFFER_NAME
, E.DESCRIPTION EVENT_OFFER_DESCRIPTION
, E.EVENT_OBJECT_TYPE EVENT_OBJECT_TYPE
, TO_NUMBER('') EVENT_HEADER_ID
, TO_CHAR('') EVENT_HEADER_NAME
, C.CAMPAIGN_ID CAMPAIGN_ID
, C.CAMPAIGN_NAME CAMPAIGN_NAME
, C.DESCRIPTION CAMPAIGN_DESCRIPTION
, C.SOURCE_CODE CAMPAIGN_SOURCE_CODE
, TO_CHAR('') MEDIA_NAME
FROM AMS_EVENT_OFFERS_VL E
, AMS_CAMPAIGNS_VL C
WHERE C.RELATED_EVENT_ID =E.EVENT_OFFER_ID
AND C.RELATED_EVENT_FROM IN('EVEO'
, 'EONE') UNION ALL SELECT TO_NUMBER('') EVENT_OFFER_ID
, TO_CHAR('') EVENT_OFFER_NAME
, TO_CHAR('') EVENT_OFFER_DESCRIPTION
, TO_CHAR('') EVENT_OBJECT_TYPE
, H.EVENT_HEADER_ID EVENT_HEADER_ID
, H.EVENT_HEADER_NAME EVENT_HEADER_NAME
, C.CAMPAIGN_ID CAMPAIGN_ID
, C.CAMPAIGN_NAME CAMPAIGN_NAME
, C.DESCRIPTION CAMPAIGN_DESCRIPTION
, C.SOURCE_CODE CAMPAIGN_SOURCE_CODE
, TO_CHAR('') MEDIA_NAME
FROM AMS_EVENT_HEADERS_VL H
, AMS_CAMPAIGNS_VL C
WHERE C.RELATED_EVENT_ID =H.EVENT_HEADER_ID
AND C.RELATED_EVENT_FROM = 'EVEH'

Columns