[Home] [Help] [Dependency Information]
Object Name: | IEM_IMT_TEXTS |
---|---|
Object Type: | TABLE |
Owner: | IEM |
Subobject Name: | |
Status: | VALID |
Stores text and retrieves keywords.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IEM_IMT_TEXTS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
MESSAGE_ID
MESSAGE_TYPE MESSAGE_PART MESSAGE_FORMAT |
SYS_IL0000402092C00008$$ | LOB | UNIQUE | APPS_TS_TX_DATA | |
IEM_IMT_INDEX | DOMAIN | NONUNIQUE | IMT_FORMAT |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
MESSAGE_ID | NUMBER | (15) | Yes | Unique Message id. |
MESSAGE_TYPE | NUMBER | (15) | Type of message. | |
MESSAGE_PART | NUMBER | (15) | Message part. | |
MESSAGE_FORMAT | NUMBER | (15) | Format of message. | |
IMT_FORMAT | VARCHAR2 | (10) | Oracle text format. | |
IMT_CHARSET | VARCHAR2 | (50) | Oracle text characterset. | |
IMT_LANG | VARCHAR2 | (10) | Oracle Text language. | |
MESSAGE_TEXT | CLOB | (4000) | Text of message |
Cut, paste (and edit) the following text to query this object:
SELECT MESSAGE_ID
, MESSAGE_TYPE
, MESSAGE_PART
, MESSAGE_FORMAT
, IMT_FORMAT
, IMT_CHARSET
, IMT_LANG
, MESSAGE_TEXT
FROM IEM.IEM_IMT_TEXTS;
IEM.IEM_IMT_TEXTS does not reference any database object
IEM.IEM_IMT_TEXTS is referenced by following:
|
|
|