[Home] [Help] [Dependency Information]
Object Name: | WF_MESSAGES_VL |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | FND.WF_MESSAGES_VL |
Subobject Name: | |
Status: | VALID |
MultiLingual view (a language resolved view of the data.)
WF_MESSAGES_VL is a view that joins the translated,
language specific
values from WF_MESSAGES_TL with the non translation dependent
data in WF_MESSAGES
to form complete zoom entities. Oracle Aplication Object Library
uses this view to display translated information in languages
installed at your site.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Unique row identifier | |
TYPE | VARCHAR2 | (8) | Yes | Item type that owns the message |
NAME | VARCHAR2 | (30) | Yes | Internal name |
PROTECT_LEVEL | NUMBER | Yes | Level at which the data is protected | |
CUSTOM_LEVEL | NUMBER | Yes | Level of user who last updated the row | |
DEFAULT_PRIORITY | NUMBER | Priority given to a message | ||
READ_ROLE | VARCHAR2 | (320) | Not currently used | |
WRITE_ROLE | VARCHAR2 | (320) | Not currently used | |
DISPLAY_NAME | VARCHAR2 | (80) | Yes | Name displayed to the user |
DESCRIPTION | VARCHAR2 | (240) | Description | |
SUBJECT | VARCHAR2 | (240) | Yes | The subject line of the message |
BODY | VARCHAR2 | (4000) | Body text of message to be sent | |
HTML_BODY | VARCHAR2 | (4000) |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, TYPE
, NAME
, PROTECT_LEVEL
, CUSTOM_LEVEL
, DEFAULT_PRIORITY
, READ_ROLE
, WRITE_ROLE
, DISPLAY_NAME
, DESCRIPTION
, SUBJECT
, BODY
, HTML_BODY
FROM APPS.WF_MESSAGES_VL;
|
|
|