[Home] [Help] [Dependency Information]
Object Name: | AMS_EVENT_OFFERS_ALL_TL |
---|---|
Object Type: | TABLE |
Owner: | AMS |
FND Design Data: | AMS.AMS_EVENT_OFFERS_ALL_TL |
Subobject Name: | |
Status: | VALID |
AMS_EVENT_OFFERS_ALL_TL provides multi-lingual support (MLS) for each event offer that you define in Oracle Marketing. MLS enables you to store and print data that you define in multiple languages.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AMS_EVENT_OFFERS_ALL_TL_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
EVENT_OFFER_ID
LANGUAGE |
AMS_EVENT_OFFERS_ALL_TL_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
EVENT_OFFER_NAME
LANGUAGE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EVENT_OFFER_ID | NUMBER | Yes | Unique identifier | |
LANGUAGE | VARCHAR2 | (4) | Yes | Language of the current Record |
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 | (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. |
EVENT_OFFER_NAME | VARCHAR2 | (240) | Yes | Name of the event offer |
DESCRIPTION | VARCHAR2 | (4000) | Description of the event | |
EVENT_MKTG_MESSAGE | VARCHAR2 | (4000) | The marketing message associated with this event | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments |
Cut, paste (and edit) the following text to query this object:
SELECT EVENT_OFFER_ID
, LANGUAGE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, SOURCE_LANG
, EVENT_OFFER_NAME
, DESCRIPTION
, EVENT_MKTG_MESSAGE
, SECURITY_GROUP_ID
FROM AMS.AMS_EVENT_OFFERS_ALL_TL;
AMS.AMS_EVENT_OFFERS_ALL_TL does not reference any database object
AMS.AMS_EVENT_OFFERS_ALL_TL is referenced by following:
|
|
|