eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.WF_MESSAGES_VL

Object Details

Object Name:	WF_MESSAGES_VL
Object Type:	VIEW
Owner:	APPS
FND Design Data:	FND.WF_MESSAGES_VL
Subobject Name:
Status:	VALID

View Type

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.

[View Source]

Columns

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)

Query Text

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;

Dependencies

[top of page]

APPS.WF_MESSAGES_VL references the following:

APPS: WF_MESSAGES; WF_MESSAGES_TL

APPS.WF_MESSAGES_VL is referenced by following:

APPS: AZW_REPORT - show dependent code; WF_DIAGNOSTICS - show dependent code; WF_LOAD - show dependent code; WF_MAIL - show dependent code; WF_MESSAGES_VL_PUB - show dependent code; WF_NOTIFICATION - show dependent code; WF_ROUTE - show dependent code