[Home] [Help]
View: HXC_LAYOUT_COMP_MESSAGES_V
View Text
SELECT BASE.LAYOUT_COMP_PROMPT_ID
, BASE.LAYOUT_COMPONENT_ID
, BASE.PROMPT_ALIAS
, MSG.MESSAGE_TEXT
, MSG.MESSAGE_NAME
FROM HXC_LAYOUT_COMP_PROMPTS BASE
, FND_NEW_MESSAGES MSG
WHERE BASE.ATTRIBUTE_CODE = MSG.MESSAGE_NAME
AND BASE.ATTRIBUTE_APPLICATION_ID = MSG.APPLICATION_ID
AND BASE.PROMPT_TYPE = 'FND_MESSAGE'
AND MSG.LANGUAGE_CODE = USERENV('LANG')
Columns
Name |
LAYOUT_COMP_PROMPT_ID |
LAYOUT_COMPONENT_ID |
PROMPT_ALIAS |
MESSAGE_TEXT |
MESSAGE_NAME |