[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| 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.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| 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
|
| 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 |
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;
AMS.AMS_CAMPAIGN_SCHEDULES_B does not reference any database object
AMS.AMS_CAMPAIGN_SCHEDULES_B is referenced by following:
APPS
AMS_CAMPAIGN_SCHEDULES_B
|
|
|
|