Search Results campaign_source_code

Overview

ASO_I_CAMPAIGN_GEO_AREAS_V is a read-only view owned by the APPS schema in Oracle E-Business Suite, classified under the ASO – Order Capture product family. Its documented purpose is to return compiled information about geographic areas and their associated campaign activities. The view exposes a flattened, denormalized projection that joins campaign header attributes with geographic targeting attributes, allowing reporting tools, concurrent programs, and integration interfaces to retrieve campaign-to-geography relationships without navigating the underlying AMS (Marketing) transaction tables directly. Because it is a view rather than a table, it carries no storage of its own and always reflects the current state of its defining query at execution time. In 12.1.1 and 12.2.2 the object is shipped in the same form, with the APPS synonym providing the externally addressable name used by customer extensions and custom reports.

Underlying Base Objects

The view text is a single-table selection over AMS_P_CAMPAIGN_GEO_AREAS_V:

SELECT APCGAV.CAMPAIGN_ID, ... FROM AMS_P_CAMPAIGN_GEO_AREAS_V APCGAV

The documented referenced base object is therefore AMS_P_CAMPAIGN_GEO_AREAS_V (itself a VIEW). No joins, unions, or inline subqueries are present in the outer definition; ASO_I_CAMPAIGN_GEO_AREAS_V is a thin pass-through layer. This pattern is typical of the ASO "_I_" (interface/inquiry) naming convention, where Order Capture exposes marketing-sourced campaign geography data for downstream consumption under a stable public name, insulating consumers from changes in the AMS marketing view. Because the base object is a view and not a stored table, the true base tables reside within the Oracle Marketing (AMS) schema and are reached transitively through AMS_P_CAMPAIGN_GEO_AREAS_V.

Key Columns

• CAMPAIGN_ID – Primary identifier of the campaign; the join key back to campaign header tables.
• CAMPAIGN_NAME – Descriptive name of the campaign for display and reporting.
• CAMPAIGN_STATUS_CODE / CAMPAIGN_STATUS_DATE – Current lifecycle status and the date that status was set.
• CAMPAIGN_SOURCE_CODE – Origin or source classification of the campaign.
• ACTUAL_START_DATE_TIME / ACTUAL_END_DATE_TIME – Actual (not planned) execution window of the campaign.
• GEO_AREA_TYPE / GEO_AREA_TYPE_NAME – Geographic area type code and its translated name (for example country, state, city, or postal code grouping).
• GEO_AREA_NAME – The user-facing geographic area label. This is the column most frequently queried by users searching for geo_area_name.
• MEDIA_ID / CHANNEL_ID – Media and channel identifiers associated with the campaign's geographic targeting.

Common Use Cases and Queries

The view supports campaign coverage reporting, geographic targeting validation, and integration extracts feeding external marketing analytics. A typical lookup by geographic area name is:

SELECT campaign_id, campaign_name, geo_area_type_name,
       geo_area_name, campaign_status_code
FROM   apps.aso_i_campaign_geo_areas_v
WHERE  geo_area_name = :p_geo_area_name;

To list all active campaigns for a geography type within a date window:

SELECT campaign_id, campaign_name, actual_start_date_time,
       actual_end_date_time
FROM   apps.aso_i_campaign_geo_areas_v
WHERE  geo_area_type_name = 'COUNTRY'
AND    actual_start_date_time >= :p_from_date;

Because the view is not indexed, queries benefit from predicates on CAMPAIGN_ID or geography attributes that push down to the underlying AMS view. It is commonly embedded in Reports, OAF pages, and BI Publisher data templates, and in custom interfaces that reconcile Order Capture campaign geography with external CRM systems.