eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.AMS_CAMPAIGNS_V

Object Details

Object Name:	AMS_CAMPAIGNS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	AMS.AMS_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
ROW_ID	ROWID	(10)		Row ID
CAMPAIGN_ID	NUMBER		Yes	Unique 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
USER_STATUS	VARCHAR2	(120)		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_PURPOSE_CODE	VARCHAR2	(30)		Campaign purpose Code
CAMPAIGN_PURPOSE	VARCHAR2	(4000)		Campaign purpose
MEDIA_TYPE_CODE	VARCHAR2	(30)		Campaign activity type
MEDIA_TYPE_NAME	VARCHAR2	(4000)		Campaign activity type name
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
PARENT_NAME	VARCHAR2	(240)		Name 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
MEDIA_NAME	VARCHAR2	(0)		Name 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 codeLanguage code
LANGUAGE_CODE	VARCHAR2	(30)		Language code
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
DESCRIPTION	VARCHAR2	(4000)		Campaign description
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
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)
TASK_ID	NUMBER			Identifier of Task created for campaign.
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
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
,      USER_STATUS
,      STATUS_CODE
,      STATUS_DATE
,      ACTIVE_FLAG
,      PRIVATE_FLAG
,      PARTNER_FLAG
,      TEMPLATE_FLAG
,      CASCADE_SOURCE_CODE_FLAG
,      INHERIT_ATTRIBUTES_FLAG
,      SOURCE_CODE
,      ROLLUP_TYPE
,      CAMPAIGN_PURPOSE_CODE
,      CAMPAIGN_PURPOSE
,      MEDIA_TYPE_CODE
,      MEDIA_TYPE_NAME
,      PRIORITY
,      FUND_SOURCE_TYPE
,      FUND_SOURCE_ID
,      PARENT_CAMPAIGN_ID
,      PARENT_NAME
,      APPLICATION_ID
,      QP_LIST_HEADER_ID
,      MEDIA_ID
,      MEDIA_NAME
,      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
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE14
,      ATTRIBUTE13
,      ATTRIBUTE15
,      CAMPAIGN_NAME
,      CAMPAIGN_THEME
,      DESCRIPTION
,      VERSION_NO
,      CAMPAIGN_CALENDAR
,      START_PERIOD_NAME
,      END_PERIOD_NAME
,      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_V;

Dependencies

[top of page]

APPS.AMS_CAMPAIGNS_V references the following:

APPS: AMS_CAMPAIGNS_ALL_TL; AMS_CAMPAIGNS_VL; AMS_USER_STATUSES_VL; AMS_UTILITY_PVT - show dependent code

APPS.AMS_CAMPAIGNS_V is referenced by following:

APPS: AMS_ACT_CAMPAIGNS_V; AMS_COPYELEMENTS_PVT - show dependent code; AMS_EVENTHEADER_PVT - show dependent code