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_CAMPAIGN_SCHEDULES_VL

Object Details

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

View Type

MultiLingual view (a language resolved view of the data.)

This view is created for the general information about marketing campaign Schedules.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Row ID
SCHEDULE_ID	NUMBER		Yes	Unique identifier for schedule
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
CAMPAIGN_ID	NUMBER		Yes	Identifier for the Campaign.
USER_STATUS_ID	NUMBER		Yes	Identifier for the user status of the schedule.
STATUS_CODE	VARCHAR2	(30)	Yes	Status code for schedule.
STATUS_DATE	DATE		Yes	Date the status was last updated.
SOURCE_CODE	VARCHAR2	(30)	Yes	Source code for schedule.
USE_PARENT_CODE_FLAG	VARCHAR2	(1)	Yes	Flag indicating if the source code should be copied from Parent campaign.
START_DATE_TIME	DATE			Start date time of the schedule
END_DATE_TIME	DATE			End date time of the schedule.
TIMEZONE_ID	NUMBER	(15)		Identifier of the timezone the schedule is in.
ACTIVITY_TYPE_CODE	VARCHAR2	(30)	Yes	Activity Type code
ACTIVITY_ID	NUMBER			Identifier of the activity the schedule will execute.
ARC_MARKETING_MEDIUM_FROM	VARCHAR2	(30)		Code to indicator the type of the marketing medium
MARKETING_MEDIUM_ID	NUMBER			Identifier of the marketing medium of the schedule.
CUSTOM_SETUP_ID	NUMBER		Yes	Identifier of the setup used to create schedule.
TRIGGERABLE_FLAG	VARCHAR2	(1)	Yes	Flag to indicate if the schedule is triggerable.
TRIGGER_ID	NUMBER			Identifier of the Trigger associated to the schedule.
NOTIFY_USER_ID	NUMBER			Identifer of the Resource which should be notified if the trigger check met.
APPROVER_USER_ID	NUMBER			Identifier of the approver for the list execution if the trigger check is met.
OWNER_USER_ID	NUMBER		Yes	Identifier of the owner of the schedule.
ACTIVE_FLAG	VARCHAR2	(1)	Yes	Flag to indicate if the schedule is active.
COVER_LETTER_ID	NUMBER			Identifier of the cover letter to be executed for the schedule.
REPLY_TO_MAIL	VARCHAR2	(120)		Reply to email address.
MAIL_SENDER_NAME	VARCHAR2	(120)		Email address of the mail sender.
MAIL_SUBJECT	VARCHAR2	(240)		Subject of the email of fax
FROM_FAX_NO	VARCHAR2	(25)		From Fax no.
ACCOUNTS_CLOSED_FLAG	VARCHAR2	(1)	Yes	Flag to indicate if the accounts are closed for the schedule.
ORG_ID	NUMBER	(32)		Identifier of the organization.
OBJECTIVE_CODE	VARCHAR2	(30)		Purpose of the schedule.
COUNTRY_ID	NUMBER		Yes	Identifier of the country of the schedule.
CAMPAIGN_CALENDAR	VARCHAR2	(20)		Calendar used for schedule planning. Refers to the General Ledger calendar.
START_PERIOD_NAME	VARCHAR2	(15)		Start period name of schedule calendar.
END_PERIOD_NAME	VARCHAR2	(30)		End period name of schedule calendar.
PRIORITY	VARCHAR2	(30)		Priority of the schedule.
WORKFLOW_ITEM_KEY	VARCHAR2	(240)		Workflow item key. Created for future use.
TRANSACTION_CURRENCY_CODE	VARCHAR2	(15)		Transaction currency code.
FUNCTIONAL_CURRENCY_CODE	VARCHAR2	(15)		Functional currency code.
BUDGET_AMOUNT_TC	NUMBER			Budget amoun in Transaction currency code.
BUDGET_AMOUNT_FC	NUMBER			Budget amount in Functional currency.
LANGUAGE_CODE	VARCHAR2	(4)		Language of the schedule.
TASK_ID	NUMBER			Identifier of the task associated to the schedule.
RELATED_EVENT_FROM	VARCHAR2	(30)		Type of event schedule is promoting.
RELATED_EVENT_ID	NUMBER			Identifier of 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.
QUERY_ID	NUMBER			Identifier of the query attached to the email schedule.
INCLUDE_CONTENT_FLAG	VARCHAR2	(1)		Flag to indicate if the content name should be inluded in the email.
CONTENT_TYPE	VARCHAR2	(30)		Type of the content.
TEST_EMAIL_ADDRESS	VARCHAR2	(150)		Email address where the test email should be sent.
SCHEDULE_NAME	VARCHAR2	(240)	Yes	Name of the schedule.
DESCRIPTION	VARCHAR2	(4000)		Description of the schedule.
GREETING_TEXT	VARCHAR2	(4000)		Greeting Text for the Email schedules.
FOOTER_TEXT	VARCHAR2	(2000)		Footer Text for the Email schedules.
TRIG_REPEAT_FLAG	VARCHAR2	(1)
TGRP_EXCLUDE_PREV_FLAG	VARCHAR2	(1)
ORIG_CSCH_ID	NUMBER
COVER_LETTER_VERSION	NUMBER
LAST_ACTIVATION_DATE	DATE
USAGE	VARCHAR2	(30)
PURPOSE	VARCHAR2	(30)
SALES_METHODOLOGY_ID	NUMBER
LABEL_FND_ID	NUMBER			Identifier for the file generated for label.
PRINTER_ADDRESS	VARCHAR2	(255)		Address of the printer where content will be print for print schedule.
REPEAT_WORKFLOW_ITEM_KEY	VARCHAR2	(240)		Identifier for workflow item key created for Repeating Schedules
NOTIFY_ON_ACTIVATION_FLAG	VARCHAR2	(1)
ORIG_CUSTOM_SETUP_ID	NUMBER			Original custom setup id before migration
SENDER_DISPLAY_NAME	VARCHAR2	(240)
DELIVERY_MODE	VARCHAR2	(30)		Delivery Mode

Query Text

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


SELECT ROW_ID
,      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
,      QUERY_ID
,      INCLUDE_CONTENT_FLAG
,      CONTENT_TYPE
,      TEST_EMAIL_ADDRESS
,      SCHEDULE_NAME
,      DESCRIPTION
,      GREETING_TEXT
,      FOOTER_TEXT
,      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 APPS.AMS_CAMPAIGN_SCHEDULES_VL;

Dependencies

[top of page]

APPS.AMS_CAMPAIGN_SCHEDULES_VL references the following:

APPS: AMS_CAMPAIGN_SCHEDULES_B; AMS_CAMPAIGN_SCHEDULES_TL

APPS.AMS_CAMPAIGN_SCHEDULES_VL is referenced by following:

APPS: AMS_ACCESS_PVT - show dependent code; AMS_ACT_LIST_PVT - show dependent code; AMS_APPROVAL_PVT - show dependent code; AMS_APPROVAL_SUBMIT_PVT - show dependent code; AMS_APPROVAL_UTIL_PVT - show dependent code; AMS_CAMPAIGNRULES_PVT - show dependent code; AMS_CAMP_SCHEDULE_PVT - show dependent code; AMS_COPYELEMENTS_PVT - show dependent code; AMS_CPYUTILITY_PVT - show dependent code; AMS_LIST_ENTRIES_UWQ_V; AMS_LIST_SCH_UWQ_V; AMS_LIST_UTIL_PKG - show dependent code; AMS_PRETTY_URL_PVT - show dependent code; AMS_P_CAMPAIGN_SCHEDS_V; AMS_P_OSO_SOURCE_CODES_V; AMS_P_SOURCE_CODES_V; AMS_SCHEDULERULES_PVT - show dependent code; AMS_SCHEDULER_PVT - show dependent code; AMS_SOURCE_CODES_DETAILS_V; AMS_UTILITY_PVT - show dependent code; AMS_WFTRIG_PVT - show dependent code; AST_AMS_SOURCE_PKG - show dependent code; AST_GRP_CAMPAIGN_SCHEDS_V; AST_LS_CAMPAIGNS_V; AST_MLIST1_ALL_UWQ_V; AST_MLIST1_UWQ_V; AST_MLIST_ALLSECURE_UWQ_V; AST_MLIST_ALL_UWQ_V; AST_MLIST_SECURE_UWQ_V; AST_MLIST_UWQ_V; AST_RS_CAMPAIGN_SCHEDS_V; AST_SOURCE_ONLY_V; AST_UWQ_MLIST_MSG_PKG - show dependent code; IEC_AGENT_WORK_ASSIGNMENTS_V; IEC_BLNDG_SCH_REC_COUNT_V; IEC_GROUP_WORK_ASSIGNMENTS_V; OZF_ACTBUDGETRULES_PVT - show dependent code; OZF_ACTBUDGETS_PVT - show dependent code; OZF_FUND_CHECKBOOK_V; OZF_FUND_EXTENSION_PVT - show dependent code; OZF_FUND_RECONCILE_PVT - show dependent code; OZF_FUND_UTILIZED_PUB - show dependent code; OZF_MULTI_CURR_MIG_PVT - show dependent code; OZF_OBJECT_CHECKBOOK_V; OZF_OFFER_PVT - show dependent code; OZF_SCHEDULE_DENORM_PVT - show dependent code