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: AMS.AMS_CAMPAIGNS_ALL_B#

Object Details

Object Name:	AMS_CAMPAIGNS_ALL_B#
Object Type:	VIEW
Owner:	AMS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
CAMPAIGN_ID	NUMBER		Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes
CREATION_DATE	DATE		Yes
CREATED_BY	NUMBER	(15)	Yes
LAST_UPDATE_LOGIN	NUMBER	(15)
OBJECT_VERSION_NUMBER	NUMBER	(9)
OWNER_USER_ID	NUMBER		Yes
USER_STATUS_ID	NUMBER		Yes
STATUS_CODE	VARCHAR2	(30)	Yes
STATUS_DATE	DATE		Yes
ACTIVE_FLAG	VARCHAR2	(1)	Yes
PRIVATE_FLAG	VARCHAR2	(1)	Yes
PARTNER_FLAG	VARCHAR2	(1)	Yes
TEMPLATE_FLAG	VARCHAR2	(1)	Yes
CASCADE_SOURCE_CODE_FLAG	VARCHAR2	(1)	Yes
INHERIT_ATTRIBUTES_FLAG	VARCHAR2	(1)	Yes
SOURCE_CODE	VARCHAR2	(30)	Yes
ROLLUP_TYPE	VARCHAR2	(30)	Yes
CAMPAIGN_TYPE	VARCHAR2	(30)
MEDIA_TYPE_CODE	VARCHAR2	(30)
PRIORITY	VARCHAR2	(30)
FUND_SOURCE_TYPE	VARCHAR2	(30)
FUND_SOURCE_ID	NUMBER
PARENT_CAMPAIGN_ID	NUMBER
APPLICATION_ID	NUMBER		Yes
QP_LIST_HEADER_ID	NUMBER
ORG_ID	NUMBER	(32)
MEDIA_ID	NUMBER
CHANNEL_ID	NUMBER
EVENT_TYPE	VARCHAR2	(30)
ARC_CHANNEL_FROM	VARCHAR2	(30)
DSCRIPT_NAME	VARCHAR2	(256)
TRANSACTION_CURRENCY_CODE	VARCHAR2	(15)
FUNCTIONAL_CURRENCY_CODE	VARCHAR2	(15)
BUDGET_AMOUNT_TC	NUMBER
BUDGET_AMOUNT_FC	NUMBER
FORECASTED_PLAN_START_DATE	DATE
FORECASTED_PLAN_END_DATE	DATE
FORECASTED_EXEC_START_DATE	DATE
FORECASTED_EXEC_END_DATE	DATE
ACTUAL_PLAN_START_DATE	DATE
ACTUAL_PLAN_END_DATE	DATE
ACTUAL_EXEC_START_DATE	DATE
ACTUAL_EXEC_END_DATE	DATE
INBOUND_URL	VARCHAR2	(120)
INBOUND_EMAIL_ID	VARCHAR2	(120)
INBOUND_PHONE_NO	VARCHAR2	(25)
DURATION	NUMBER	(15)
DURATION_UOM_CODE	VARCHAR2	(3)
FF_PRIORITY	VARCHAR2	(30)
FF_OVERRIDE_COVER_LETTER	NUMBER
FF_SHIPPING_METHOD	VARCHAR2	(30)
FF_CARRIER	VARCHAR2	(120)
CONTENT_SOURCE	VARCHAR2	(120)
CC_CALL_STRATEGY	VARCHAR2	(30)
CC_MANAGER_USER_ID	NUMBER	(15)
FORECASTED_REVENUE	NUMBER	(15)
ACTUAL_REVENUE	NUMBER	(15)
FORECASTED_COST	NUMBER	(15)
ACTUAL_COST	NUMBER	(15)
FORECASTED_RESPONSE	NUMBER	(15)
ACTUAL_RESPONSE	NUMBER	(15)
TARGET_RESPONSE	NUMBER	(15)
COUNTRY_CODE	VARCHAR2	(30)
LANGUAGE_CODE	VARCHAR2	(30)
ATTRIBUTE_CATEGORY	VARCHAR2	(30)
ATTRIBUTE1	VARCHAR2	(150)
ATTRIBUTE2	VARCHAR2	(150)
ATTRIBUTE3	VARCHAR2	(150)
ATTRIBUTE4	VARCHAR2	(150)
ATTRIBUTE5	VARCHAR2	(150)
ATTRIBUTE6	VARCHAR2	(150)
ATTRIBUTE7	VARCHAR2	(150)
ATTRIBUTE8	VARCHAR2	(150)
ATTRIBUTE9	VARCHAR2	(150)
ATTRIBUTE10	VARCHAR2	(150)
ATTRIBUTE11	VARCHAR2	(150)
ATTRIBUTE12	VARCHAR2	(150)
ATTRIBUTE14	VARCHAR2	(150)
ATTRIBUTE13	VARCHAR2	(150)
ATTRIBUTE15	VARCHAR2	(150)
VERSION_NO	VARCHAR2	(10)
CAMPAIGN_CALENDAR	VARCHAR2	(15)
START_PERIOD_NAME	VARCHAR2	(15)
END_PERIOD_NAME	VARCHAR2	(15)
CITY_ID	NUMBER
GLOBAL_FLAG	VARCHAR2	(1)
CUSTOM_SETUP_ID	NUMBER
SHOW_CAMPAIGN_FLAG	VARCHAR2	(1)
SECURITY_GROUP_ID	NUMBER
BUSINESS_UNIT_ID	NUMBER	(15)
ACCOUNTS_CLOSED_FLAG	VARCHAR2	(1)
TASK_ID	NUMBER
RELATED_EVENT_FROM	VARCHAR2	(30)
RELATED_EVENT_ID	NUMBER
PROGRAM_ATTRIBUTE_CATEGORY	VARCHAR2	(30)
PROGRAM_ATTRIBUTE1	VARCHAR2	(150)
PROGRAM_ATTRIBUTE2	VARCHAR2	(150)
PROGRAM_ATTRIBUTE3	VARCHAR2	(150)
PROGRAM_ATTRIBUTE4	VARCHAR2	(150)
PROGRAM_ATTRIBUTE5	VARCHAR2	(150)
PROGRAM_ATTRIBUTE6	VARCHAR2	(150)
PROGRAM_ATTRIBUTE7	VARCHAR2	(150)
PROGRAM_ATTRIBUTE8	VARCHAR2	(150)
PROGRAM_ATTRIBUTE9	VARCHAR2	(150)
PROGRAM_ATTRIBUTE10	VARCHAR2	(150)
PROGRAM_ATTRIBUTE11	VARCHAR2	(150)
PROGRAM_ATTRIBUTE12	VARCHAR2	(150)
PROGRAM_ATTRIBUTE13	VARCHAR2	(150)
PROGRAM_ATTRIBUTE14	VARCHAR2	(150)
PROGRAM_ATTRIBUTE15	VARCHAR2	(150)
ORIG_CUSTOM_SETUP_ID	NUMBER

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# references the following:

AMS: AMS_CAMPAIGNS_ALL_B

AMS.AMS_CAMPAIGNS_ALL_B# is referenced by following:

APPS: AMS_CAMPAIGNS_ALL_B