[Home] [Help] [Dependency Information]
Object Name: | AMS_CAMPAIGNS_ALL_TL |
---|---|
Object Type: | TABLE |
Owner: | AMS |
FND Design Data: | AMS.AMS_CAMPAIGNS_ALL_TL |
Subobject Name: | |
Status: | VALID |
This table contains the campaign attributes which need to be translated.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AMS_CAMPAIGNS_ALL_TL_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
CAMPAIGN_ID
LANGUAGE |
AMS_CAMPAIGNS_ALL_TL_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
CAMPAIGN_NAME
LANGUAGE |
AMS_CAMPAIGNS_ALL_TL_N2 | FUNCTION-BASED NORMAL | NONUNIQUE | APPS_TS_TX_IDX | UPPER("CAMPAIGN_NAME") |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CAMPAIGN_ID | NUMBER | Yes | Unique identifier | |
LANGUAGE | VARCHAR2 | (4) | Yes | Language of the current record |
CREATION_DATE | DATE | Yes | Standard WHO Column | |
CREATED_BY | NUMBER | (15) | Yes | Standard WHO Column |
LAST_UPDATE_DATE | DATE | Yes | Standard WHO Column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard WHO Column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard WHO Column | |
SOURCE_LANG | VARCHAR2 | (4) | 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. |
CAMPAIGN_NAME | VARCHAR2 | (240) | Yes | Campaign name |
CAMPAIGN_THEME | VARCHAR2 | (4000) | Campaign theme | |
DESCRIPTION | VARCHAR2 | (4000) | Campaign description | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments |
Cut, paste (and edit) the following text to query this object:
SELECT CAMPAIGN_ID
, LANGUAGE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, SOURCE_LANG
, CAMPAIGN_NAME
, CAMPAIGN_THEME
, DESCRIPTION
, SECURITY_GROUP_ID
FROM AMS.AMS_CAMPAIGNS_ALL_TL;
AMS.AMS_CAMPAIGNS_ALL_TL does not reference any database object
AMS.AMS_CAMPAIGNS_ALL_TL is referenced by following:
|
|
|