VIEW: APPS.HXC_LAYOUT_COMP_MESSAGES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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