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

VIEW: APPS.ASO_I_CAMPAIGN_GEO_AREAS_V

Object Details
Object Name: ASO_I_CAMPAIGN_GEO_AREAS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewASO.ASO_I_CAMPAIGN_GEO_AREAS_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
CAMPAIGN_ID NUMBER
Yes Unique Identifer of Campaigns
CAMPAIGN_STATUS_CODE VARCHAR2 (30) Yes Campaign Status Code
CAMPAIGN_STATUS_DATE DATE
Yes Campaign Status Date
CAMPAIGN_SOURCE_CODE VARCHAR2 (30) Yes Campaign Source Code
ACTUAL_START_DATE_TIME DATE

Start Date of Campaign
ACTUAL_END_DATE_TIME DATE

End Date of Campaign
GEO_AREA_TYPE VARCHAR2 (30) Yes Geographic type code.
GEO_AREA_TYPE_NAME VARCHAR2 (240) Yes Geographic type Name
GEO_AREA_NAME VARCHAR2 (240)
Geographic Area Name
CAMPAIGN_NAME VARCHAR2 (240) Yes Campaign Name
MEDIA_ID NUMBER

Media Id
CHANNEL_ID NUMBER

Channel Identifer
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_AREA_NAME
,      CAMPAIGN_NAME
,      MEDIA_ID
,      CHANNEL_ID
FROM APPS.ASO_I_CAMPAIGN_GEO_AREAS_V;

Dependencies

[top of page]

APPS.ASO_I_CAMPAIGN_GEO_AREAS_V references the following:

SchemaAPPS
ViewAMS_P_CAMPAIGN_GEO_AREAS_V

APPS.ASO_I_CAMPAIGN_GEO_AREAS_V is not referenced by any database object