View: AMS_P_CAMPAIGN_GEO_AREAS_V

Product:	AMS - Marketing
Description:	This public view returns information of Marketing campaign and the geographic area they are available / used.
Implementation/DBA Data:	APPS.AMS_P_CAMPAIGN_GEO_AREAS_V

View Text

SELECT AGEO.ACT_GEO_AREA_USER_ID
, CAMP.STATUS_CODE
, CAMP.STATUS_DATE
, CAMP.SOURCE_CODE
, CAMP.ACTUAL_EXEC_START_DATE
, CAMP.ACTUAL_EXEC_END_DATE
, AGEO.GEO_TYPE_CODE
, AGEO.GEO_TYPE_NAME
, AGEO.GEO_HIERARCHY_ID
, AGEO.GEO_AREA_NAME
, CAMP.CAMPAIGN_NAME
, CAMP.MEDIA_ID
, CAMP.CHANNEL_ID
FROM AMS_ACT_GEO_AREAS_V AGEO
, AMS_CAMPAIGNS_VL CAMP
WHERE AGEO.ACT_GEO_AREA_USER_ID = CAMP.CAMPAIGN_ID
AND AGEO.ACT_GEO_AREA_USER = 'CAMP'
AND CAMP.STATUS_CODE = 'ACTIVE'
AND CAMP.ACTIVE_FLAG = 'Y'
AND CAMP.SHOW_CAMPAIGN_FLAG = 'Y'

Columns