DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.AMS_P_CAMPAIGN_GEO_AREAS_V

Object Details
Object Name: AMS_P_CAMPAIGN_GEO_AREAS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAMS.AMS_P_CAMPAIGN_GEO_AREAS_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


This public view provides data for campaign and geographic areas association.


[View Source]

Columns
Name Datatype Length Mandatory Comments
CAMPAIGN_ID NUMBER
Yes Campaign Identifier.
CAMPAIGN_STATUS_CODE VARCHAR2 (30) Yes Campaign status code.
CAMPAIGN_STATUS_DATE DATE
Yes status date.
CAMPAIGN_SOURCE_CODE VARCHAR2 (30) Yes Campaign source code.
ACTUAL_START_DATE_TIME DATE

Actual start date and time of campaign.
ACTUAL_END_DATE_TIME DATE

Actual end date and time of campaign.
GEO_AREA_TYPE VARCHAR2 (30) Yes Geographic Area type.
GEO_AREA_TYPE_NAME VARCHAR2 (240) Yes Geographic area type name.
GEO_HIERARCHY_ID NUMBER
Yes Geography hierarchy area identifier.
GEO_AREA_NAME VARCHAR2 (240)
Geographic area name.
CAMPAIGN_NAME VARCHAR2 (240) Yes Campaign Name.
MEDIA_ID NUMBER

Media identifier.
CHANNEL_ID NUMBER

Channel identifier.
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT 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_HIERARCHY_ID
,      GEO_AREA_NAME
,      CAMPAIGN_NAME
,      MEDIA_ID
,      CHANNEL_ID
FROM APPS.AMS_P_CAMPAIGN_GEO_AREAS_V;

Dependencies

[top of page]

APPS.AMS_P_CAMPAIGN_GEO_AREAS_V references the following:

SchemaAPPS
ViewAMS_ACT_GEO_AREAS_V
ViewAMS_CAMPAIGNS_VL
APPS.AMS_P_CAMPAIGN_GEO_AREAS_V is referenced by following:

SchemaAPPS
ViewASO_I_CAMPAIGN_GEO_AREAS_V