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_P_CAMPAIGNS_V

Object Details

Object Name:	AMS_P_CAMPAIGNS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	AMS.AMS_P_CAMPAIGNS_V
Subobject Name:
Status:	VALID

View Type

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.

[View Source]

Columns

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.

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
,      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;

Dependencies

[top of page]

APPS.AMS_P_CAMPAIGNS_V references the following:

APPS: AMS_CAMPAIGNS_VL

APPS.AMS_P_CAMPAIGNS_V is referenced by following:

APPS: ASO_I_CAMPAIGNS_V; AST_GRP_CAMPAIGNS_V; AST_RS_CAMPAIGNS_V; IEX_UWQ_SEL_PKG - show dependent code