[Home] [Help] [Dependency Information]
Object Name: | SY_TEXT_TKN_TL |
---|---|
Object Type: | TABLE |
Owner: | GMA |
FND Design Data: | GMA.SY_TEXT_TKN_TL |
Subobject Name: | |
Status: | VALID |
Stores OPM Text Token definitions
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
SY_TEXT_TKN_TL_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX |
TEXT_KEY
LANG_CODE LANGUAGE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TEXT_KEY | VARCHAR2 | (32) | Yes | Text Token Name |
LANG_CODE | VARCHAR2 | (4) | Yes | Indicates language used in text. |
TEXT_CODE | NUMBER | (10) | ID which joins any rows of text in this table to the Text Table for this Module | |
TOKEN_DESC | VARCHAR2 | (70) | Yes | Description of the Text token. |
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 | |
LANGUAGE | VARCHAR2 | (4) | Yes | The value stored in this column represents the Language in which the data will be displayed. |
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. |
Cut, paste (and edit) the following text to query this object:
SELECT TEXT_KEY
, LANG_CODE
, TEXT_CODE
, TOKEN_DESC
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, LANGUAGE
, SOURCE_LANG
FROM GMA.SY_TEXT_TKN_TL;
GMA.SY_TEXT_TKN_TL does not reference any database object
GMA.SY_TEXT_TKN_TL is referenced by following:
|
|
|