VIEW: APPS.WF_MESSAGES_VL

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')