VIEW: APPS.CSM_NEW_MESSAGES_V

Source

View Text - Preformatted

SELECT acc.access_id, b.message_id, b.message_name, acc.level_id, acc.level_value, acc.language, b.message_type, b.message_length, acc.message_text, acc.description, b.created_by, b.creation_date, b.last_updated_by, b.last_update_date from csm_new_messages b, csm_new_messages_acc acc,asg_user au WHERE b.message_id = acc.message_id AND acc.language = asg_base.get_language AND acc.user_id = asg_base.get_user_id AND au.user_id = acc.user_id AND NVL(au.multi_platform,'N')='N'

View Text - HTML Formatted

SELECT ACC.ACCESS_ID
, B.MESSAGE_ID
, B.MESSAGE_NAME
, ACC.LEVEL_ID
, ACC.LEVEL_VALUE
, ACC.LANGUAGE
, B.MESSAGE_TYPE
, B.MESSAGE_LENGTH
, ACC.MESSAGE_TEXT
, ACC.DESCRIPTION
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
FROM CSM_NEW_MESSAGES B
, CSM_NEW_MESSAGES_ACC ACC
, ASG_USER AU
WHERE B.MESSAGE_ID = ACC.MESSAGE_ID
AND ACC.LANGUAGE = ASG_BASE.GET_LANGUAGE
AND ACC.USER_ID = ASG_BASE.GET_USER_ID
AND AU.USER_ID = ACC.USER_ID
AND NVL(AU.MULTI_PLATFORM
, 'N')='N'