VIEW: APPS.WF_MESSAGE_ATTRIBUTES_VL

Source

View Text - Preformatted

SELECT B.ROWID ROW_ID, B.MESSAGE_TYPE, B.MESSAGE_NAME, B.NAME, B.SEQUENCE, B.TYPE, B.SUBTYPE, B.VALUE_TYPE, B.PROTECT_LEVEL, B.CUSTOM_LEVEL, B.FORMAT, B.TEXT_DEFAULT, B.NUMBER_DEFAULT, B.DATE_DEFAULT, T.DISPLAY_NAME, T.DESCRIPTION, B.ATTACH, B.RENDER, B.CUSTOMIZATION_LEVEL FROM WF_MESSAGE_ATTRIBUTES B, WF_MESSAGE_ATTRIBUTES_TL T WHERE B.MESSAGE_NAME = T.MESSAGE_NAME AND B.MESSAGE_TYPE = T.MESSAGE_TYPE AND B.NAME = T.NAME AND T.LANGUAGE = USERENV('LANG')

View Text - HTML Formatted

SELECT B.ROWID ROW_ID
, B.MESSAGE_TYPE
, B.MESSAGE_NAME
, B.NAME
, B.SEQUENCE
, B.TYPE
, B.SUBTYPE
, B.VALUE_TYPE
, B.PROTECT_LEVEL
, B.CUSTOM_LEVEL
, B.FORMAT
, B.TEXT_DEFAULT
, B.NUMBER_DEFAULT
, B.DATE_DEFAULT
, T.DISPLAY_NAME
, T.DESCRIPTION
, B.ATTACH
, B.RENDER
, B.CUSTOMIZATION_LEVEL
FROM WF_MESSAGE_ATTRIBUTES B
, WF_MESSAGE_ATTRIBUTES_TL T
WHERE B.MESSAGE_NAME = T.MESSAGE_NAME
AND B.MESSAGE_TYPE = T.MESSAGE_TYPE
AND B.NAME = T.NAME
AND T.LANGUAGE = USERENV('LANG')