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

VIEW: APPS.ASO_I_CAMPAIGNS_V

Object Details
Object Name: ASO_I_CAMPAIGNS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewASO.ASO_I_CAMPAIGNS_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 identifier of Campaign
CAMPAIGN_NAME VARCHAR2 (240) Yes Name of Campaign
DESCRIPTION VARCHAR2 (4000)
Description of Campaign
CAMPAIGN_PURPOSE VARCHAR2 (30)
Purpose of Campaign
ROLLUP_TYPE VARCHAR2 (30) Yes Campaign rollup type
STATUS_CODE VARCHAR2 (30) Yes System status code
STATUS_DATE DATE
Yes System Status Date
SOURCE_CODE VARCHAR2 (30) Yes Campaign source code
OWNER_USER_ID NUMBER
Yes Campaign owner identifier
CASCADE_SOURCE_CODE_FLAG VARCHAR2 (1) Yes Flag that indicates if the source code will be cascaded to campaign schedules
PARTNER_FLAG VARCHAR2 (1) Yes Flag that indicates if the campaign has partners
PARENT_CAMPAIGN_ID NUMBER

Identifier of the parent campaign
PRIORITY VARCHAR2 (30)
Campaign priority
INBOUND_SCRIPT_NAME VARCHAR2 (256)
The deployed script name
FUND_SOURCE_TYPE VARCHAR2 (30)
Campaign fund source type
FUND_SOURCE_ID NUMBER

Campaign fund source Identifier
ACTUAL_EXEC_START_DATE DATE

Actual execution start date
ACTUAL_EXEC_END_DATE DATE

Actual execution End date
MEDIA_ID NUMBER

Identifier of the media used by the campaign
MEDIA_NAME VARCHAR2 (0)
Name of the media used by the campaign
MEDIA_TYPE_CODE VARCHAR2 (0)
Type of the media used by the campaign
MEDIA_TYPE_NAME VARCHAR2 (0)
Name of the type of the media used by the campaign
CHANNEL_SOURCE VARCHAR2 (30)
Indicates if the channel is an event or a media channel
CHANNEL_ID NUMBER

Identifier of the channel used by this campaign
CHANNEL_NAME VARCHAR2 (0)
Name of the channel used by this campaign
CHANNEL_TYPE VARCHAR2 (0)
Type of the channel used by this campaign
CHANNEL_OUTBOUND_FLAG VARCHAR2 (0)
Channel OutBound Flag
CHANNEL_INBOUND_FLAG VARCHAR2 (0)
Channel InBound Flag
INBOUND_URL VARCHAR2 (120)
Inbound URL
INBOUND_EMAIL_ID VARCHAR2 (120)
Inbound Email Address
INBOUND_PHONE_NO VARCHAR2 (25)
Inbound Phone No
FF_PRIORITY VARCHAR2 (30)
Fulfillment priority
FF_OVERRIDE_COVER_LETTER NUMBER

Fulfillment override cover letter
FF_SHIPPING_METHOD VARCHAR2 (30)
Fulfillment shipping method
CONTENT_SOURCE VARCHAR2 (120)
Content source
CC_CALL_STRATEGY VARCHAR2 (30)
Call strategy to be used by the call center for contacting customers
CC_MANAGER_USER_ID NUMBER (15)
Resource id of the person who manages the call center
Query Text

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


SELECT CAMPAIGN_ID
,      CAMPAIGN_NAME
,      DESCRIPTION
,      CAMPAIGN_PURPOSE
,      ROLLUP_TYPE
,      STATUS_CODE
,      STATUS_DATE
,      SOURCE_CODE
,      OWNER_USER_ID
,      CASCADE_SOURCE_CODE_FLAG
,      PARTNER_FLAG
,      PARENT_CAMPAIGN_ID
,      PRIORITY
,      INBOUND_SCRIPT_NAME
,      FUND_SOURCE_TYPE
,      FUND_SOURCE_ID
,      ACTUAL_EXEC_START_DATE
,      ACTUAL_EXEC_END_DATE
,      MEDIA_ID
,      MEDIA_NAME
,      MEDIA_TYPE_CODE
,      MEDIA_TYPE_NAME
,      CHANNEL_SOURCE
,      CHANNEL_ID
,      CHANNEL_NAME
,      CHANNEL_TYPE
,      CHANNEL_OUTBOUND_FLAG
,      CHANNEL_INBOUND_FLAG
,      INBOUND_URL
,      INBOUND_EMAIL_ID
,      INBOUND_PHONE_NO
,      FF_PRIORITY
,      FF_OVERRIDE_COVER_LETTER
,      FF_SHIPPING_METHOD
,      CONTENT_SOURCE
,      CC_CALL_STRATEGY
,      CC_MANAGER_USER_ID
FROM APPS.ASO_I_CAMPAIGNS_V;

Dependencies

[top of page]

APPS.ASO_I_CAMPAIGNS_V references the following:

SchemaAPPS
ViewAMS_P_CAMPAIGNS_V

APPS.ASO_I_CAMPAIGNS_V is not referenced by any database object