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_CAMPAIGN_SCHEDULES_B

Object Details

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

AMS_SCHEDULES_B stores the schedule details of execution campaigns.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AMS_CAMPAIGN_SCHEDULES_B_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	SCHEDULE_ID
AMS_CAMPAIGN_SCHEDULES_B_FUN1	FUNCTION-BASED NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRUNC("START_DATE_TIME")
AMS_CAMPAIGN_SCHEDULES_B_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CAMPAIGN_ID
AMS_CAMPAIGN_SCHEDULES_B_N10	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OWNER_USER_ID
AMS_CAMPAIGN_SCHEDULES_B_N11	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRIGGER_ID
AMS_CAMPAIGN_SCHEDULES_B_N12	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORIG_CSCH_ID
AMS_CAMPAIGN_SCHEDULES_B_N13	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	START_DATE_TIME
AMS_CAMPAIGN_SCHEDULES_B_N14	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LAST_UPDATE_DATE
AMS_CAMPAIGN_SCHEDULES_B_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	USER_STATUS_ID
AMS_CAMPAIGN_SCHEDULES_B_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	STATUS_CODE
AMS_CAMPAIGN_SCHEDULES_B_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SOURCE_CODE
AMS_CAMPAIGN_SCHEDULES_B_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ACTIVITY_ID
AMS_CAMPAIGN_SCHEDULES_B_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	MARKETING_MEDIUM_ID
AMS_CAMPAIGN_SCHEDULES_B_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	COUNTRY_ID
AMS_CAMPAIGN_SCHEDULES_B_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LANGUAGE_CODE
AMS_CAMPAIGN_SCHEDULES_B_N9	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RELATED_EVENT_FROM RELATED_EVENT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
SCHEDULE_ID	NUMBER		Yes	Unique Identifier
LAST_UPDATE_DATE	DATE		Yes	Standard WHO columns
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard WHO columns
CREATION_DATE	DATE		Yes	Standard WHO columns
CREATED_BY	NUMBER	(15)	Yes	Standard WHO columns
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO columns
OBJECT_VERSION_NUMBER	NUMBER	(9)		This column is used for locking purposes
CAMPAIGN_ID	NUMBER		Yes	Unique Identifier for Campaigns
USER_STATUS_ID	NUMBER		Yes	Unique Identifier for Current User status
STATUS_CODE	VARCHAR2	(30)	Yes	Current System Status code
STATUS_DATE	DATE		Yes	Date when last status was updated.
SOURCE_CODE	VARCHAR2	(30)	Yes	Source code for schedule.
USE_PARENT_CODE_FLAG	VARCHAR2	(1)	Yes	Flag to indicate if campaign's source code should be used for schedules.
START_DATE_TIME	DATE			Start Date and time for Schedule
END_DATE_TIME	DATE			End Date and time for Schedule
TIMEZONE_ID	NUMBER	(15)		Identifier for User's timezone.
ACTIVITY_TYPE_CODE	VARCHAR2	(30)	Yes	Schedule Activity Type Code.
ACTIVITY_ID	NUMBER			Identifier for the Acitivity associated to the schedule.
ARC_MARKETING_MEDIUM_FROM	VARCHAR2	(30)		Indicates if the Marketing Medium is Event or Activity Marketing medium.
MARKETING_MEDIUM_ID	NUMBER			Unique Identifier for Marketing Medium.
CUSTOM_SETUP_ID	NUMBER		Yes	Identifier for the setupwith which this schedule is created.
TRIGGERABLE_FLAG	VARCHAR2	(1)	Yes	Flag to indicate if the schedule is Triggerable.
TRIGGER_ID	NUMBER			Unique Identifier for Triggers
NOTIFY_USER_ID	NUMBER			Identifier of the Resource to send Notifications to.
APPROVER_USER_ID	NUMBER			Identifier for the Approver
OWNER_USER_ID	NUMBER		Yes	Identifier for the coordinator of the Schdule.
ACTIVE_FLAG	VARCHAR2	(1)	Yes	Flag to indicate if the schedule is Active.
COVER_LETTER_ID	NUMBER			Identifier for the cover letter to be sent with the schedule.
REPLY_TO_MAIL	VARCHAR2	(120)		Email Address for the reply of the Email.
MAIL_SENDER_NAME	VARCHAR2	(120)		Name of the person sending Email or Fax.
MAIL_SUBJECT	VARCHAR2	(240)		Subject of the Email.
FROM_FAX_NO	VARCHAR2	(25)		Number of the Fax from where the Fax is sent.
ACCOUNTS_CLOSED_FLAG	VARCHAR2	(1)	Yes	Flag indicating if the account is closed .
ORG_ID	NUMBER	(32)		Identifier for the organization.
OBJECTIVE_CODE	VARCHAR2	(30)		Objective of the schedule.
COUNTRY_ID	NUMBER		Yes	Identifier for the country where the schedule is created.
CAMPAIGN_CALENDAR	VARCHAR2	(20)		Calendar used for campaign planning. Refers to the General Ledger calendar.
START_PERIOD_NAME	VARCHAR2	(15)		Starting period name within the schedule calendar.
END_PERIOD_NAME	VARCHAR2	(30)		End period name within the schedule calendar
PRIORITY	VARCHAR2	(30)		Priority of the schedules.
WORKFLOW_ITEM_KEY	VARCHAR2	(240)		Identifier for the workflow process. Reserved for the future use.
TRANSACTION_CURRENCY_CODE	VARCHAR2	(15)		Transaction 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
LANGUAGE_CODE	VARCHAR2	(4)		Language of schedule execution
TASK_ID	NUMBER			Task created for schedule.
RELATED_EVENT_FROM	VARCHAR2	(30)		Type of event schedule is promoting.
RELATED_EVENT_ID	NUMBER			Identifier of the event schedule is promoting.
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	(240)		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
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment
ACTIVITY_ATTRIBUTE_CATEGORY	VARCHAR2	(240)		Descriptive flexfiled structure defining column for Activity.
ACTIVITY_ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment for Activity.
ACTIVITY_ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment for Activity.
ACTIVITY_ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment for Activity.
ACTIVITY_ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment for Activity.
ACTIVITY_ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment for Activity.
ACTIVITY_ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment for Activity.
ACTIVITY_ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment for Activity.
ACTIVITY_ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment for Activity.
ACTIVITY_ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment for Activity.
ACTIVITY_ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment for Activity.
ACTIVITY_ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment for Activity.
ACTIVITY_ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment for Activity.
ACTIVITY_ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment for Activity.
ACTIVITY_ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment for Activity.
ACTIVITY_ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment for Activity.
SECURITY_GROUP_ID	NUMBER			Used in hosted environments
QUERY_ID	NUMBER			Identifier of the fulfillment query attached to the schedule.
INCLUDE_CONTENT_FLAG	VARCHAR2	(1)		Flag to indicate if the content to be included when the email is sent out for this schedule.
CONTENT_TYPE	VARCHAR2	(30)		Content type of the email.
TEST_EMAIL_ADDRESS	VARCHAR2	(150)		Email address where the test email is sent.
SOURCE_FROM_PARENT	VARCHAR2	(1)		Flag to Indicate if the budget will be sourced from the parent campaign
TRIG_REPEAT_FLAG	VARCHAR2	(1)		Flag to indicate if the schedule repeats through trigger
TGRP_EXCLUDE_PREV_FLAG	VARCHAR2	(1)		Flag to indicate if the target group generation should exclude previously contacted entries
ORIG_CSCH_ID	NUMBER			Indicates the original schedule's id, if repeating.
COVER_LETTER_VERSION	NUMBER			Indicates the associated cover letter content item's version.
LAST_ACTIVATION_DATE	DATE			Last Activation Date for the Schedule
USAGE	VARCHAR2	(30)		Lite or Classic Schedule
PURPOSE	VARCHAR2	(30)		Purpose behind execution of Schedule
SALES_METHODOLOGY_ID	NUMBER			Methodology used for Sales Campaigns
LABEL_FND_ID	NUMBER			Identifier for the file generated for labels.
PRINTER_ADDRESS	VARCHAR2	(255)		Address of the printer where the content will be print for print schedules
REPEAT_WORKFLOW_ITEM_KEY	VARCHAR2	(240)		Identifier for the workflow itemkey created for Repeat schedule workflow
NOTIFY_ON_ACTIVATION_FLAG	VARCHAR2	(1)		Indicates whether a notification will be sent when schedule becomes active
ORIG_CUSTOM_SETUP_ID	NUMBER			Stores the custom_setup_id used prior to R12
SENDER_DISPLAY_NAME	VARCHAR2	(240)		Sender's display name
DELIVERY_MODE	VARCHAR2	(30)		Delivery Mode

Query Text

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


SELECT SCHEDULE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      CAMPAIGN_ID
,      USER_STATUS_ID
,      STATUS_CODE
,      STATUS_DATE
,      SOURCE_CODE
,      USE_PARENT_CODE_FLAG
,      START_DATE_TIME
,      END_DATE_TIME
,      TIMEZONE_ID
,      ACTIVITY_TYPE_CODE
,      ACTIVITY_ID
,      ARC_MARKETING_MEDIUM_FROM
,      MARKETING_MEDIUM_ID
,      CUSTOM_SETUP_ID
,      TRIGGERABLE_FLAG
,      TRIGGER_ID
,      NOTIFY_USER_ID
,      APPROVER_USER_ID
,      OWNER_USER_ID
,      ACTIVE_FLAG
,      COVER_LETTER_ID
,      REPLY_TO_MAIL
,      MAIL_SENDER_NAME
,      MAIL_SUBJECT
,      FROM_FAX_NO
,      ACCOUNTS_CLOSED_FLAG
,      ORG_ID
,      OBJECTIVE_CODE
,      COUNTRY_ID
,      CAMPAIGN_CALENDAR
,      START_PERIOD_NAME
,      END_PERIOD_NAME
,      PRIORITY
,      WORKFLOW_ITEM_KEY
,      TRANSACTION_CURRENCY_CODE
,      FUNCTIONAL_CURRENCY_CODE
,      BUDGET_AMOUNT_TC
,      BUDGET_AMOUNT_FC
,      LANGUAGE_CODE
,      TASK_ID
,      RELATED_EVENT_FROM
,      RELATED_EVENT_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ACTIVITY_ATTRIBUTE_CATEGORY
,      ACTIVITY_ATTRIBUTE1
,      ACTIVITY_ATTRIBUTE2
,      ACTIVITY_ATTRIBUTE3
,      ACTIVITY_ATTRIBUTE4
,      ACTIVITY_ATTRIBUTE5
,      ACTIVITY_ATTRIBUTE6
,      ACTIVITY_ATTRIBUTE7
,      ACTIVITY_ATTRIBUTE8
,      ACTIVITY_ATTRIBUTE9
,      ACTIVITY_ATTRIBUTE10
,      ACTIVITY_ATTRIBUTE11
,      ACTIVITY_ATTRIBUTE12
,      ACTIVITY_ATTRIBUTE13
,      ACTIVITY_ATTRIBUTE14
,      ACTIVITY_ATTRIBUTE15
,      SECURITY_GROUP_ID
,      QUERY_ID
,      INCLUDE_CONTENT_FLAG
,      CONTENT_TYPE
,      TEST_EMAIL_ADDRESS
,      SOURCE_FROM_PARENT
,      TRIG_REPEAT_FLAG
,      TGRP_EXCLUDE_PREV_FLAG
,      ORIG_CSCH_ID
,      COVER_LETTER_VERSION
,      LAST_ACTIVATION_DATE
,      USAGE
,      PURPOSE
,      SALES_METHODOLOGY_ID
,      LABEL_FND_ID
,      PRINTER_ADDRESS
,      REPEAT_WORKFLOW_ITEM_KEY
,      NOTIFY_ON_ACTIVATION_FLAG
,      ORIG_CUSTOM_SETUP_ID
,      SENDER_DISPLAY_NAME
,      DELIVERY_MODE
FROM AMS.AMS_CAMPAIGN_SCHEDULES_B;

Dependencies

[top of page]

AMS.AMS_CAMPAIGN_SCHEDULES_B does not reference any database object

AMS.AMS_CAMPAIGN_SCHEDULES_B is referenced by following:

AMS: AMS_CAMPAIGN_SCHEDULES_B#