[Home] [Help] [Dependency Information]
Object Name: | AMS_CAMPAIGN_SCHEDULES_TL |
---|---|
Object Type: | TABLE |
Owner: | AMS |
FND Design Data: | AMS.AMS_CAMPAIGN_SCHEDULES_TL |
Subobject Name: | |
Status: | VALID |
This table contains the schedule attributes which need to be translated.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AMS_CAMPAIGN_SCHEDULES_TL_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
SCHEDULE_ID
LANGUAGE |
AMS_CAMPAIGN_SCHEDULES_TL_FUN1 | FUNCTION-BASED NORMAL | NONUNIQUE | APPS_TS_TX_IDX | UPPER("SCHEDULE_NAME") |
AMS_CAMPAIGN_SCHEDULES_TL_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
SCHEDULE_NAME
LANGUAGE |
AMS_CAMPAIGN_SCHEDULE_TL_U2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
LANGUAGE
SCHEDULE_NAME CAMPAIGN_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SCHEDULE_ID | NUMBER | Yes | Identifier for the Schedule. | |
LANGUAGE | VARCHAR2 | (4) | Yes | Language. |
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. | |
SOURCE_LANG | VARCHAR2 | (240) | Yes | The language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well. |
SCHEDULE_NAME | VARCHAR2 | (240) | Yes | Name of the Schedule. |
CAMPAIGN_ID | NUMBER | Campaign to which the schedule belongs. Denormalized column. | ||
DESCRIPTION | VARCHAR2 | (4000) | Description | |
SECURITY_GROUP_ID | VARCHAR2 | (240) | Used in Hosted environments. | |
GREETING_TEXT | VARCHAR2 | (4000) | Greeting of the email to be sent. | |
FOOTER_TEXT | VARCHAR2 | (2000) | Footer text to be sent with the email. |
Cut, paste (and edit) the following text to query this object:
SELECT SCHEDULE_ID
, LANGUAGE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, SOURCE_LANG
, SCHEDULE_NAME
, CAMPAIGN_ID
, DESCRIPTION
, SECURITY_GROUP_ID
, GREETING_TEXT
, FOOTER_TEXT
FROM AMS.AMS_CAMPAIGN_SCHEDULES_TL;
AMS.AMS_CAMPAIGN_SCHEDULES_TL does not reference any database object
AMS.AMS_CAMPAIGN_SCHEDULES_TL is referenced by following:
|
|
|