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]

TABLE: AMS.AMS_CAMPAIGNS_ALL_B

Object Details

Object Name:	AMS_CAMPAIGNS_ALL_B
Object Type:	TABLE
Owner:	AMS
FND Design Data:	AMS.AMS_CAMPAIGNS_ALL_B
Subobject Name:
Status:	VALID

This is the container for all marketing campaigns created by various CRM products. General details of a campaign like dates, priority, type, channel are stored in this table. The campaign type decides the medium in which the campaign is run. The hierarchical structure of the campaigns can be constructed using the PARENT_CAMPAIGN_ID. This table also stores the general details of Trade promotions and Plans.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AMS_CAMPAIGNS_ALL_B_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	CAMPAIGN_ID
AMS_CAMPAIGNS_ALL_B_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	SOURCE_CODE
AMS_CAMPAIGNS_ALL_B_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PARENT_CAMPAIGN_ID
AMS_CAMPAIGNS_ALL_B_N11	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OWNER_USER_ID
AMS_CAMPAIGNS_ALL_B_N13	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LAST_UPDATE_DATE
AMS_CAMPAIGNS_ALL_B_N14	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CITY_ID
AMS_CAMPAIGNS_ALL_B_N15	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BUSINESS_UNIT_ID
AMS_CAMPAIGNS_ALL_B_N17	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RELATED_EVENT_FROM RELATED_EVENT_ID
AMS_CAMPAIGNS_ALL_B_N18	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ACTUAL_EXEC_START_DATE
AMS_CAMPAIGNS_ALL_B_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	MEDIA_ID
AMS_CAMPAIGNS_ALL_B_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORG_ID
AMS_CAMPAIGNS_ALL_B_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	STATUS_CODE
AMS_CAMPAIGNS_ALL_B_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	USER_STATUS_ID
AMS_CAMPAIGNS_ALL_B_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ARC_CHANNEL_FROM CHANNEL_ID
AMS_CAMPAIGNS_ALL_B_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CAMPAIGN_TYPE

Columns

Name	Datatype	Length	Mandatory	Comments
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
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 purpose
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			No Longer in use.
ORG_ID	NUMBER	(32)		Organization identifier
MEDIA_ID	NUMBER			No Longer in use.
CHANNEL_ID	NUMBER			No Longer in use.
EVENT_TYPE	VARCHAR2	(30)		No Longer in use.
ARC_CHANNEL_FROM	VARCHAR2	(30)		No Longer in use.
DSCRIPT_NAME	VARCHAR2	(256)		No Longer in use.
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			No Longer in use.
FORECASTED_PLAN_END_DATE	DATE			No Longer in use.
FORECASTED_EXEC_START_DATE	DATE			No Longer in use.
FORECASTED_EXEC_END_DATE	DATE			No Longer in use.
ACTUAL_PLAN_START_DATE	DATE			No Longer in use.
ACTUAL_PLAN_END_DATE	DATE			No Longer in use.
ACTUAL_EXEC_START_DATE	DATE			Actual execution start date
ACTUAL_EXEC_END_DATE	DATE			Actual execution end date
INBOUND_URL	VARCHAR2	(120)		No Longer in use.
INBOUND_EMAIL_ID	VARCHAR2	(120)		No Longer in use.
INBOUND_PHONE_NO	VARCHAR2	(25)		No Longer in use.
DURATION	NUMBER	(15)		No Longer in use.
DURATION_UOM_CODE	VARCHAR2	(3)		No Longer in use.
FF_PRIORITY	VARCHAR2	(30)		No Longer in use.
FF_OVERRIDE_COVER_LETTER	NUMBER			No Longer in use.
FF_SHIPPING_METHOD	VARCHAR2	(30)		No Longer in use.
FF_CARRIER	VARCHAR2	(120)		No Longer in use.
CONTENT_SOURCE	VARCHAR2	(120)		No Longer in use.
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
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
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 General Ledger 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			Country 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'.
SECURITY_GROUP_ID	NUMBER			Used in hosted environments
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			Task indentifier 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 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.
ORIG_CUSTOM_SETUP_ID	NUMBER			Stores the custom_setup_id used prior to R12

Query Text

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


SELECT 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
,      ORG_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
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE14
,      ATTRIBUTE13
,      ATTRIBUTE15
,      VERSION_NO
,      CAMPAIGN_CALENDAR
,      START_PERIOD_NAME
,      END_PERIOD_NAME
,      CITY_ID
,      GLOBAL_FLAG
,      CUSTOM_SETUP_ID
,      SHOW_CAMPAIGN_FLAG
,      SECURITY_GROUP_ID
,      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
,      ORIG_CUSTOM_SETUP_ID
FROM AMS.AMS_CAMPAIGNS_ALL_B;

Dependencies

[top of page]

AMS.AMS_CAMPAIGNS_ALL_B does not reference any database object

AMS.AMS_CAMPAIGNS_ALL_B is referenced by following:

APPS: AMS_CAMPAIGNS_ALL_B