FND Design Data [Home] [Help]

View: WF_MESSAGE_ATTRIBUTES_VL

Product: FND - Application Object Library
Description: View of WF_MESSAGE_ATTRIBUTES and WF_MESSAGE_ATTRIBUTES_TL
Implementation/DBA Data: ViewAPPS.WF_MESSAGE_ATTRIBUTES_VL
View Text

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

Columns

Name
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