DBA Data[Home] [Help] [Dependency Information]

TABLE: APPLSYS.WF_MESSAGES_TL

Object Details
Object Name: WF_MESSAGES_TL
Object Type: TABLE
Owner: APPLSYS
FND Design Data: TableFND.WF_MESSAGES_TL
Subobject Name:
Status: VALID


Translation table for the WF_MESSAGES table.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
WF_MESSAGES_TL_PK NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnTYPE
ColumnNAME
ColumnLANGUAGE
ColumnZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
TYPE VARCHAR2 (8) Yes Item type that owns the message
NAME VARCHAR2 (30) Yes Internal name of the message
LANGUAGE VARCHAR2 (4) Yes Language
DISPLAY_NAME VARCHAR2 (80) Yes Message name displayed to the user
SUBJECT VARCHAR2 (240) Yes The subject line of the message
PROTECT_LEVEL NUMBER
Yes Level at which the data is protected
CUSTOM_LEVEL NUMBER
Yes Level of user who last updated the row
DESCRIPTION VARCHAR2 (240)
Description
BODY VARCHAR2 (4000)
Body text of message to be sent
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.
HTML_BODY VARCHAR2 (4000)
The html version of the body text of message to be sent
SECURITY_GROUP_ID VARCHAR2 (32)
identifier reserved for hosting environment
ZD_EDITION_NAME VARCHAR2 (30) Yes
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT TYPE
,      NAME
,      LANGUAGE
,      DISPLAY_NAME
,      SUBJECT
,      PROTECT_LEVEL
,      CUSTOM_LEVEL
,      DESCRIPTION
,      BODY
,      SOURCE_LANG
,      HTML_BODY
,      SECURITY_GROUP_ID
,      ZD_EDITION_NAME
FROM APPLSYS.WF_MESSAGES_TL;

Dependencies

[top of page]

APPLSYS.WF_MESSAGES_TL does not reference any database object

APPLSYS.WF_MESSAGES_TL is referenced by following:

SchemaAPPLSYS
ViewWF_MESSAGES_TL#