[Home] [Help] [Dependency Information]
Object Name: | AMS_P_CAMPAIGNS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | AMS.AMS_P_CAMPAIGNS_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This view is created for the general information about marketing campaigns.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CAMPAIGN_ID | NUMBER | Yes | Unique Identifier | |
CAMPAIGN_NAME | VARCHAR2 | (240) | Yes | Campaign name |
DESCRIPTION | VARCHAR2 | (4000) | Description | |
CAMPAIGN_PURPOSE | VARCHAR2 | (30) | Campaign purpose | |
ROLLUP_TYPE | VARCHAR2 | (30) | Yes | Campaign rollup type |
STATUS_CODE | VARCHAR2 | (30) | Yes | System status code |
STATUS_DATE | DATE | Yes | Date when the campaign status was last updated | |
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 | |
APPLICATION_ID | NUMBER | Yes | Application identifier | |
FUND_SOURCE_TYPE | VARCHAR2 | (30) | Campaign fund source type | |
FUND_SOURCE_ID | NUMBER | Identifier of the campaign fund source | ||
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) | Campaign activity type | |
MEDIA_TYPE_NAME | VARCHAR2 | (0) | Campaign activity name | |
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) | Flag indicationg wether the channel is outbound or not. | |
CHANNEL_INBOUND_FLAG | VARCHAR2 | (0) | Flag indicationg wether the channel is inbound or not. | |
INBOUND_URL | VARCHAR2 | (120) | Inbound URL | |
INBOUND_EMAIL_ID | VARCHAR2 | (120) | Inbound email id | |
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 | |
VERSION_NO | VARCHAR2 | (10) | Version Number of the campaign. A campaign can have many versions before it goes active. | |
CAMPAIGN_CALENDAR | VARCHAR2 | (15) | Calendar used for campaign planning. Refers to the GL calendar. | |
START_PERIOD_NAME | VARCHAR2 | (15) | Starting period name within the campaign calendar | |
END_PERIOD_NAME | VARCHAR2 | (15) | End period name within the campaign calendar | |
CITY_ID | NUMBER | City where the campaign was created | ||
GLOBAL_FLAG | VARCHAR2 | (1) | Flag to indicate if the campaign is run globally. | |
CUSTOM_SETUP_ID | NUMBER | Custom setup used to create the campaign | ||
BUSINESS_UNIT_ID | NUMBER | (15) | Identifier indicates which business group this campaign belongs to | |
RELATED_EVENT_FROM | VARCHAR2 | (30) | Type of event campaign is promoting. | |
RELATED_EVENT_ID | NUMBER | Identifier of the event campaign is promoting. |
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
, APPLICATION_ID
, 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
, VERSION_NO
, CAMPAIGN_CALENDAR
, START_PERIOD_NAME
, END_PERIOD_NAME
, CITY_ID
, GLOBAL_FLAG
, CUSTOM_SETUP_ID
, BUSINESS_UNIT_ID
, RELATED_EVENT_FROM
, RELATED_EVENT_ID
FROM APPS.AMS_P_CAMPAIGNS_V;
|
|
|