[Home] [Help] [Dependency Information]
Object Name: | AMS_CAMPAIGN_SCHEDULES |
---|---|
Object Type: | TABLE |
Owner: | AMS |
FND Design Data: | AMS.AMS_CAMPAIGN_SCHEDULES |
Subobject Name: | |
Status: | VALID |
AMS_CAMPAIGN_SCHEDULES stores the schedule details of execution campaigns.
Campaign planners can define the status, associate the collateral used, the promotional offer to be given and the dates for this schedule.
Tablespace: | APPS_TS_ARCHIVE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AMS_CAMPAIGN_SCHEDULES_U1 | NORMAL | UNIQUE | APPS_TS_ARCHIVE | CAMPAIGN_SCHEDULE_ID |
AMS_CAMPAIGN_SCHEDULES_N1 | NORMAL | NONUNIQUE | APPS_TS_ARCHIVE | CAMPAIGN_ID |
AMS_CAMPAIGN_SCHEDULES_N2 | NORMAL | NONUNIQUE | APPS_TS_ARCHIVE | FREQUENCY_UOM_CODE |
AMS_CAMPAIGN_SCHEDULES_N3 | NORMAL | NONUNIQUE | APPS_TS_ARCHIVE | ACTIVITY_OFFER_ID |
AMS_CAMPAIGN_SCHEDULES_N4 | NORMAL | NONUNIQUE | APPS_TS_ARCHIVE | DELIVERABLE_ID |
AMS_CAMPAIGN_SCHEDULES_N5 | NORMAL | NONUNIQUE | APPS_TS_ARCHIVE | USER_STATUS_ID |
AMS_CAMPAIGN_SCHEDULES_N6 | NORMAL | NONUNIQUE | APPS_TS_ARCHIVE | STATUS_CODE |
AMS_CAMPAIGN_SCHEDULES_N7 | NORMAL | NONUNIQUE | APPS_TS_ARCHIVE | SOURCE_CODE |
AMS_CAMPAIGN_SCHEDULES_N8 | NORMAL | NONUNIQUE | APPS_TS_ARCHIVE | INBOUND_DSCRIPT_NAME |
AMS_CAMPAIGN_SCHEDULES_N9 | NORMAL | NONUNIQUE | APPS_TS_ARCHIVE | OUTBOUND_DSCRIPT_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CAMPAIGN_SCHEDULE_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 | |
CAMPAIGN_ID | NUMBER | Yes | Campaign identifier | |
USER_STATUS_ID | NUMBER | Yes | Identifier of the current user status | |
STATUS_CODE | VARCHAR2 | (30) | Yes | Current system status code |
STATUS_DATE | DATE | Yes | Date when the status was last updated | |
SOURCE_CODE | VARCHAR2 | (30) | Yes | Source code |
FORECASTED_START_DATE_TIME | DATE | Forecasted start date and time | ||
FORECASTED_END_DATE_TIME | DATE | Forecasted end date and time | ||
ACTUAL_START_DATE_TIME | DATE | Actual start date and time | ||
ACTUAL_END_DATE_TIME | DATE | Actual end date and time | ||
FREQUENCY | NUMBER | (15) | The frequency of the schedule | |
FREQUENCY_UOM_CODE | VARCHAR2 | (3) | Unit of the frequency | |
ACTIVITY_OFFER_ID | NUMBER | Identifier of the activity offer associated with this schedule | ||
DELIVERABLE_ID | NUMBER | Identifier of the deliverable associated with this schedule | ||
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 | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
TRIGGERED_FLAG | VARCHAR2 | (1) | Yes | Flag that indicates if this schedule was created automatically by triggers |
ACTIVE_FLAG | VARCHAR2 | (1) | Flag that indicates if the schedule is enabled | |
INBOUND_DSCRIPT_NAME | VARCHAR2 | (256) | Inbound deployed script name | |
OUTBOUND_DSCRIPT_NAME | VARCHAR2 | (256) | Outbound deployed script name | |
INBOUND_URL | VARCHAR2 | (120) | Inbound URL | |
INBOUND_EMAIL_ID | VARCHAR2 | (120) | Inbound email id | |
INBOUND_PHONE_NO | VARCHAR2 | (25) | Inbound phone number | |
CHANNEL_ID | NUMBER | (38) | Identifier of the channel associated with this schedule | |
COVER_LETTER | NUMBER | The cover letter associated to this schedule | ||
REPLYTO_MAIL_ID | VARCHAR2 | (120) | The email ID to be replyed to | |
MAIL_SENDER_NAME | VARCHAR2 | (120) | Name of the mail sender | |
MAIL_SUBJECT | VARCHAR2 | (240) | Subject of the mail | |
FROM_FAX_NO | VARCHAR2 | (25) | The incoming fax number | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments |
Cut, paste (and edit) the following text to query this object:
SELECT CAMPAIGN_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
, FORECASTED_START_DATE_TIME
, FORECASTED_END_DATE_TIME
, ACTUAL_START_DATE_TIME
, ACTUAL_END_DATE_TIME
, FREQUENCY
, FREQUENCY_UOM_CODE
, ACTIVITY_OFFER_ID
, DELIVERABLE_ID
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, TRIGGERED_FLAG
, ACTIVE_FLAG
, INBOUND_DSCRIPT_NAME
, OUTBOUND_DSCRIPT_NAME
, INBOUND_URL
, INBOUND_EMAIL_ID
, INBOUND_PHONE_NO
, CHANNEL_ID
, COVER_LETTER
, REPLYTO_MAIL_ID
, MAIL_SENDER_NAME
, MAIL_SUBJECT
, FROM_FAX_NO
, SECURITY_GROUP_ID
FROM AMS.AMS_CAMPAIGN_SCHEDULES;
AMS.AMS_CAMPAIGN_SCHEDULES does not reference any database object
AMS.AMS_CAMPAIGN_SCHEDULES is referenced by following:
|
|
|