[Home] [Help]
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
Name |
CAMPAIGN_ID |
CAMPAIGN_STATUS_CODE |
CAMPAIGN_STATUS_DATE |
CAMPAIGN_SOURCE_CODE |
ACTUAL_START_DATE_TIME |
ACTUAL_END_DATE_TIME |
GEO_AREA_TYPE |
GEO_AREA_TYPE_NAME |
GEO_AREA_NAME |
CAMPAIGN_NAME |
MEDIA_ID |
CHANNEL_ID |