[Home] [Help] [Dependency Information]
Object Name: | WF_MESSAGE_ATTRIBUTES_VL |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | FND.WF_MESSAGE_ATTRIBUTES_VL |
Subobject Name: | |
Status: | VALID |
MultiLingual view (a language resolved view of the data.)
WF_MESSAGE_ATTRIBUTES_VL is a view that joins the translated,
language specific
values from WF_MESSAGE_ATTRIBUTES_TL with the non-displayed
data from WF_MESSAGE_ATTRIBUTES
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 | |
MESSAGE_TYPE | VARCHAR2 | (8) | Yes | Item type of the message |
MESSAGE_NAME | VARCHAR2 | (30) | Yes | Internal name of the message |
NAME | VARCHAR2 | (30) | Yes | Internal name |
SEQUENCE | NUMBER | Yes | Order of the attribute within the message | |
TYPE | VARCHAR2 | (8) | Yes | Type of attribute |
SUBTYPE | VARCHAR2 | (8) | Yes | Determines if attribute is send or respond |
VALUE_TYPE | VARCHAR2 | (8) | Yes | Defines if the default is a constant or a reference to a item attribute |
PROTECT_LEVEL | NUMBER | Yes | Level at which the data is protected | |
CUSTOM_LEVEL | NUMBER | Yes | Level of user who last updated the row | |
FORMAT | VARCHAR2 | (240) | Format mask or Lookup type | |
TEXT_DEFAULT | VARCHAR2 | (4000) | Default format if type is text | |
NUMBER_DEFAULT | NUMBER | Default format if type is number | ||
DATE_DEFAULT | DATE | Default format if type is date | ||
DISPLAY_NAME | VARCHAR2 | (80) | Yes | Name displayed to the user |
DESCRIPTION | VARCHAR2 | (240) | Description | |
ATTACH | VARCHAR2 | (1) |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, MESSAGE_TYPE
, MESSAGE_NAME
, NAME
, SEQUENCE
, TYPE
, SUBTYPE
, VALUE_TYPE
, PROTECT_LEVEL
, CUSTOM_LEVEL
, FORMAT
, TEXT_DEFAULT
, NUMBER_DEFAULT
, DATE_DEFAULT
, DISPLAY_NAME
, DESCRIPTION
, ATTACH
FROM APPS.WF_MESSAGE_ATTRIBUTES_VL;
|
|
|