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

VIEW: APPS.AMS_CAMPAIGNS_VL

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

View Type

MultiLingual view (a language resolved view of the data.)


This view is created for the general information about marketing campaigns.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row Id
CAMPAIGN_ID NUMBER
Yes Campaign owner identifier
LAST_UPDATE_DATE DATE
Yes Standard WHO column
LAST_UPDATED_BY NUMBER (15) Yes Standard WHO column
CREATION_DATE DATE
Yes Standard WHO column
CREATED_BY NUMBER (15) Yes Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column
OBJECT_VERSION_NUMBER NUMBER (9)
This column is used for locking purposes
OWNER_USER_ID NUMBER
Yes Campaign owner identifier
USER_STATUS_ID NUMBER
Yes User status identifier
STATUS_CODE VARCHAR2 (30) Yes System status code
STATUS_DATE DATE
Yes Date when the campaign status was last updated
ACTIVE_FLAG VARCHAR2 (1) Yes Flag that indicates if the campaign is enabled.
PRIVATE_FLAG VARCHAR2 (1) Yes Flag that indicates if the campaign is private
PARTNER_FLAG VARCHAR2 (1) Yes Flag that indicates if the campaign has partners
TEMPLATE_FLAG VARCHAR2 (1) Yes Flag that indicates if the campaign is the template
CASCADE_SOURCE_CODE_FLAG VARCHAR2 (1) Yes Flag that indicates if the source code will be cascaded to campaign schedules
INHERIT_ATTRIBUTES_FLAG VARCHAR2 (1) Yes Flag that indicates if the basic attributes will be inherited from parent
SOURCE_CODE VARCHAR2 (30) Yes Campaign source code
ROLLUP_TYPE VARCHAR2 (30) Yes Campaign rollup type
CAMPAIGN_TYPE VARCHAR2 (30)
Campaign type
MEDIA_TYPE_CODE VARCHAR2 (30)
Campaign activity type
PRIORITY VARCHAR2 (30)
Campaign priority
FUND_SOURCE_TYPE VARCHAR2 (30)
Campaign fund source type
FUND_SOURCE_ID NUMBER

Identifier of the campaign fund source
PARENT_CAMPAIGN_ID NUMBER

Identifier of the parent campaign
APPLICATION_ID NUMBER
Yes Application identifier
QP_LIST_HEADER_ID NUMBER

Identifier of the price list header
MEDIA_ID NUMBER

Identifier of the media used by the campaign
CHANNEL_ID NUMBER

Identifier of the channel used by this campaign
EVENT_TYPE VARCHAR2 (30)
Event type
ARC_CHANNEL_FROM VARCHAR2 (30)
Indicates if the channel is an event or a media channel
DSCRIPT_NAME VARCHAR2 (256)
The deployed script name
TRANSACTION_CURRENCY_CODE VARCHAR2 (15)
Transactional currency code
FUNCTIONAL_CURRENCY_CODE VARCHAR2 (15)
Functional currency code
BUDGET_AMOUNT_TC NUMBER

Budget amount in the transactional currency
BUDGET_AMOUNT_FC NUMBER

Budget amount in the functional currency
FORECASTED_PLAN_START_DATE DATE

Forecasted planning start date
FORECASTED_PLAN_END_DATE DATE

Forecasted planning end date
FORECASTED_EXEC_START_DATE DATE

Forecasted execution start date
FORECASTED_EXEC_END_DATE DATE

Forecasted execution end date
ACTUAL_PLAN_START_DATE DATE

Actual planning start date
ACTUAL_PLAN_END_DATE DATE

Actual planning end date
ACTUAL_EXEC_START_DATE DATE

Actual execution start date
ACTUAL_EXEC_END_DATE DATE

Actual execution end date
INBOUND_URL VARCHAR2 (120)
Inbound URL
INBOUND_EMAIL_ID VARCHAR2 (120)
Inbound email id
INBOUND_PHONE_NO VARCHAR2 (25)
Inbound phone no
DURATION NUMBER (15)
Campaign duration
DURATION_UOM_CODE VARCHAR2 (3)
Unit of the duration
FF_PRIORITY VARCHAR2 (30)
Fulfillment priority
FF_OVERRIDE_COVER_LETTER NUMBER

Fulfillment override cover letter
FF_SHIPPING_METHOD VARCHAR2 (30)
Fulfillment shipping method
FF_CARRIER VARCHAR2 (120)
Fulfillment carrier
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
FORECASTED_REVENUE NUMBER (15)
Forecasted revenue
ACTUAL_REVENUE NUMBER (15)
Actual revenue
FORECASTED_COST NUMBER (15)
Forecasted cost
ACTUAL_COST NUMBER (15)
Actual cost
FORECASTED_RESPONSE NUMBER (15)
Forecasted reponse
ACTUAL_RESPONSE NUMBER (15)
Actual response
TARGET_RESPONSE NUMBER (15)
Target reponse
COUNTRY_CODE VARCHAR2 (30)
Country code
LANGUAGE_CODE VARCHAR2 (30)
Language code
ORG_ID NUMBER (32)
Organization identifier
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfiled structure defining column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
CAMPAIGN_NAME VARCHAR2 (240) Yes Campaign name
CAMPAIGN_THEME VARCHAR2 (4000)
Campaign theme
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
DESCRIPTION VARCHAR2 (4000)
Description
VERSION_NO VARCHAR2 (10)
Version Number of the campaign. A campaign can have many versions before it goes active.
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
SHOW_CAMPAIGN_FLAG VARCHAR2 (1)
Indicates if the campaign has t o be visible. All active versions of a campaign will have this flag set to 'Y'.
BUSINESS_UNIT_ID NUMBER (15)
Identifier of the Business Unit this campaign belongs to
ACCOUNTS_CLOSED_FLAG VARCHAR2 (1)
Flag to indicate closing of Accounts
TASK_ID NUMBER

Identifier for the Task associated to campaigns.
RELATED_EVENT_FROM VARCHAR2 (30)
Type of event campaign is promoting.
RELATED_EVENT_ID NUMBER

Identifier of the event campaign is promoting.
PROGRAM_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfiled structure defining column for Programs
PROGRAM_ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment for Programs.
PROGRAM_ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment for Programs.
PROGRAM_ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment for Programs.
PROGRAM_ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment for Programs.
PROGRAM_ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment for Programs.
PROGRAM_ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment for Programs.
PROGRAM_ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment for Programs.
PROGRAM_ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment for Programs.
PROGRAM_ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment for Programs.
PROGRAM_ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment for Programs.
PROGRAM_ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment for Programs.
PROGRAM_ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment for Programs.
PROGRAM_ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment for Programs.
PROGRAM_ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment for Programs.
PROGRAM_ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment for Programs.
Query Text

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


SELECT ROW_ID
,      CAMPAIGN_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      OWNER_USER_ID
,      USER_STATUS_ID
,      STATUS_CODE
,      STATUS_DATE
,      ACTIVE_FLAG
,      PRIVATE_FLAG
,      PARTNER_FLAG
,      TEMPLATE_FLAG
,      CASCADE_SOURCE_CODE_FLAG
,      INHERIT_ATTRIBUTES_FLAG
,      SOURCE_CODE
,      ROLLUP_TYPE
,      CAMPAIGN_TYPE
,      MEDIA_TYPE_CODE
,      PRIORITY
,      FUND_SOURCE_TYPE
,      FUND_SOURCE_ID
,      PARENT_CAMPAIGN_ID
,      APPLICATION_ID
,      QP_LIST_HEADER_ID
,      MEDIA_ID
,      CHANNEL_ID
,      EVENT_TYPE
,      ARC_CHANNEL_FROM
,      DSCRIPT_NAME
,      TRANSACTION_CURRENCY_CODE
,      FUNCTIONAL_CURRENCY_CODE
,      BUDGET_AMOUNT_TC
,      BUDGET_AMOUNT_FC
,      FORECASTED_PLAN_START_DATE
,      FORECASTED_PLAN_END_DATE
,      FORECASTED_EXEC_START_DATE
,      FORECASTED_EXEC_END_DATE
,      ACTUAL_PLAN_START_DATE
,      ACTUAL_PLAN_END_DATE
,      ACTUAL_EXEC_START_DATE
,      ACTUAL_EXEC_END_DATE
,      INBOUND_URL
,      INBOUND_EMAIL_ID
,      INBOUND_PHONE_NO
,      DURATION
,      DURATION_UOM_CODE
,      FF_PRIORITY
,      FF_OVERRIDE_COVER_LETTER
,      FF_SHIPPING_METHOD
,      FF_CARRIER
,      CONTENT_SOURCE
,      CC_CALL_STRATEGY
,      CC_MANAGER_USER_ID
,      FORECASTED_REVENUE
,      ACTUAL_REVENUE
,      FORECASTED_COST
,      ACTUAL_COST
,      FORECASTED_RESPONSE
,      ACTUAL_RESPONSE
,      TARGET_RESPONSE
,      COUNTRY_CODE
,      LANGUAGE_CODE
,      ORG_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE14
,      ATTRIBUTE13
,      ATTRIBUTE15
,      CAMPAIGN_NAME
,      CAMPAIGN_THEME
,      CAMPAIGN_CALENDAR
,      START_PERIOD_NAME
,      END_PERIOD_NAME
,      DESCRIPTION
,      VERSION_NO
,      CITY_ID
,      GLOBAL_FLAG
,      CUSTOM_SETUP_ID
,      SHOW_CAMPAIGN_FLAG
,      BUSINESS_UNIT_ID
,      ACCOUNTS_CLOSED_FLAG
,      TASK_ID
,      RELATED_EVENT_FROM
,      RELATED_EVENT_ID
,      PROGRAM_ATTRIBUTE_CATEGORY
,      PROGRAM_ATTRIBUTE1
,      PROGRAM_ATTRIBUTE2
,      PROGRAM_ATTRIBUTE3
,      PROGRAM_ATTRIBUTE4
,      PROGRAM_ATTRIBUTE5
,      PROGRAM_ATTRIBUTE6
,      PROGRAM_ATTRIBUTE7
,      PROGRAM_ATTRIBUTE8
,      PROGRAM_ATTRIBUTE9
,      PROGRAM_ATTRIBUTE10
,      PROGRAM_ATTRIBUTE11
,      PROGRAM_ATTRIBUTE12
,      PROGRAM_ATTRIBUTE13
,      PROGRAM_ATTRIBUTE14
,      PROGRAM_ATTRIBUTE15
FROM APPS.AMS_CAMPAIGNS_VL;

Dependencies

[top of page]

APPS.AMS_CAMPAIGNS_VL references the following:

SchemaAPPS
SynonymAMS_CAMPAIGNS_ALL_B
SynonymAMS_CAMPAIGNS_ALL_TL
APPS.AMS_CAMPAIGNS_VL is referenced by following:

SchemaAPPS
Package BodyAMS_APPROVAL_PVT - show dependent code
Package BodyAMS_APPROVAL_UTIL_PVT - show dependent code
Package BodyAMS_CAMPAIGNRULES_PVT - show dependent code
ViewAMS_CAMPAIGNS_V
ViewAMS_CAMPAIGN_FORECASTS_ALL_V
Package BodyAMS_CAMPAIGN_PVT - show dependent code
Package BodyAMS_CAMP_SCHEDULE_PVT - show dependent code
Package BodyAMS_COPYACTIVITIES_PVT - show dependent code
Package BodyAMS_CPYUTILITY_PVT - show dependent code
Package BodyAMS_DELIVERABLE_PVT - show dependent code
Package BodyAMS_EVENTHEADER_PVT - show dependent code
Package BodyAMS_EVHRULES_PVT - show dependent code
Package BodyAMS_LIST_ASSOC_PVT - show dependent code
ViewAMS_PROGRAM_COMPONENTS_V
ViewAMS_P_CAMPAIGNS_V
ViewAMS_P_CAMPAIGN_GEO_AREAS_V
ViewAMS_P_CAMPAIGN_MKT_SEGMENTS_V
ViewAMS_P_CAMPAIGN_OFFERS_V
ViewAMS_P_CAMPAIGN_PRODUCTS_V
ViewAMS_P_CAMPAIGN_SCHEDS_V
ViewAMS_P_EVENT_CAMPAIGNS_V
ViewAMS_P_OSO_SOURCE_CODES_V
ViewAMS_P_SOURCE_CODES_V
Package BodyAMS_SCHEDULERULES_PVT - show dependent code
Package BodyAMS_SOURCECODE_PVT - show dependent code
ViewAMS_SOURCE_CODES_DETAILS_V
Package BodyAMS_TCOP_PREVIEW - show dependent code
Package BodyAMS_UTILITY_PVT - show dependent code
Package BodyAMS_WFCMPAPR_PVT - show dependent code
Package BodyAMS_WFTRIG_PVT - show dependent code
Package BodyAST_AMS_SOURCE_PKG - show dependent code
ViewAST_CAMPAIGNS_LOV_V
ViewAST_LS_CAMPAIGNS_V
ViewAST_SOURCE_ONLY_V
ViewBIM_DIMV_CAMPAIGNS
Package BodyBIM_EDW_CMPGNS_M_SIZE - show dependent code
Package BodyBIX_CAMP_PERF_REPORT - show dependent code
ViewBIX_DM_CAMPAIGNS_PARAM_V
ViewIEC_AGENT_WORK_ASSIGNMENTS_V
ViewIEC_GROUP_WORK_ASSIGNMENTS_V
Package BodyOZF_ACTBUDGETRULES_PVT - show dependent code
Package BodyOZF_ACTBUDGETS_PVT - show dependent code
Package BodyOZF_ACT_OFFERS_PVT - show dependent code
ViewOZF_AEL_SL_UTL_V
Package BodyOZF_BUDGETAPPROVAL_PVT - show dependent code
ViewOZF_FUND_CHECKBOOK_V
Package BodyOZF_FUND_EXTENSION_PVT - show dependent code
Package BodyOZF_FUND_RECONCILE_PVT - show dependent code
Package BodyOZF_FUND_UTILIZED_PUB - show dependent code
Package BodyOZF_OFFR_ELIG_PROD_DENORM_PVT - show dependent code
ViewOZF_P_CAMPAIGN_OFFERS_V
Package BodyOZF_SCHEDULE_DENORM_PVT - show dependent code
Package BodyOZF_UTILITY_PVT - show dependent code