[Home] [Help] [Dependency Information]
Object Name: | ASO_I_CAMPAIGNS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | ASO.ASO_I_CAMPAIGNS_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
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 |
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;
APPS.ASO_I_CAMPAIGNS_V is not referenced by any database object
|
|
|