View: ASO_I_CAMPAIGN_GEO_AREAS_V

Product:	ASO - Order Capture
Description:	This view returns compiled information of geographic areas and associated activities.
Implementation/DBA Data:	APPS.ASO_I_CAMPAIGN_GEO_AREAS_V

View Text

SELECT APCGAV.CAMPAIGN_ID
, APCGAV.CAMPAIGN_STATUS_CODE
, APCGAV.CAMPAIGN_STATUS_DATE
, APCGAV.CAMPAIGN_SOURCE_CODE
, APCGAV.ACTUAL_START_DATE_TIME
, APCGAV.ACTUAL_END_DATE_TIME
, APCGAV.GEO_AREA_TYPE
, APCGAV.GEO_AREA_TYPE_NAME
, APCGAV.GEO_AREA_NAME
, APCGAV.CAMPAIGN_NAME
, APCGAV.MEDIA_ID
, APCGAV.CHANNEL_ID
FROM AMS_P_CAMPAIGN_GEO_AREAS_V APCGAV

Columns