View: WF_MESSAGES_VL

Product:	FND - Application Object Library
Description:	View of WF_MESSAGE and WF_MESSAGES_TL
Implementation/DBA Data:	APPS.WF_MESSAGES_VL

View Text

SELECT B.ROWID ROW_ID
, B.TYPE
, B.NAME
, B.PROTECT_LEVEL
, B.CUSTOM_LEVEL
, B.DEFAULT_PRIORITY
, B.READ_ROLE
, B.WRITE_ROLE
, T.DISPLAY_NAME
, T.DESCRIPTION
, T.SUBJECT
, T.BODY
, T.HTML_BODY
FROM WF_MESSAGES B
, WF_MESSAGES_TL T
WHERE B.TYPE = T.TYPE
AND B.NAME = T.NAME
AND T.LANGUAGE = USERENV('LANG')

Columns