VIEW: APPS.CSF_M_MESSAGES_V

Source

View Text - Preformatted

SELECT acc.access_id, msg.APPLICATION_ID, msg.LANGUAGE_CODE, msg.MESSAGE_NAME, msg.MESSAGE_NUMBER, msg.MESSAGE_TEXT, msg.DESCRIPTION, msg.TYPE, msg.MAX_LENGTH FROM fnd_new_messages msg, csm_messages_acc acc WHERE msg.language_code = asg_base.get_language AND acc.application_id = msg.application_id AND acc.message_name = msg.message_name AND acc.language_code = msg.language_code

View Text - HTML Formatted

SELECT ACC.ACCESS_ID
, MSG.APPLICATION_ID
, MSG.LANGUAGE_CODE
, MSG.MESSAGE_NAME
, MSG.MESSAGE_NUMBER
, MSG.MESSAGE_TEXT
, MSG.DESCRIPTION
, MSG.TYPE
, MSG.MAX_LENGTH
FROM FND_NEW_MESSAGES MSG
, CSM_MESSAGES_ACC ACC
WHERE MSG.LANGUAGE_CODE = ASG_BASE.GET_LANGUAGE
AND ACC.APPLICATION_ID = MSG.APPLICATION_ID
AND ACC.MESSAGE_NAME = MSG.MESSAGE_NAME
AND ACC.LANGUAGE_CODE = MSG.LANGUAGE_CODE