eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.JTM_FND_NEW_MESSAGES_V

Source

View Text - Preformatted


SELECT ACC.ACCESS_ID, BAS.APPLICATION_ID, BAS.LANGUAGE_CODE, BAS.MESSAGE_NUMBER, BAS.MESSAGE_NAME, BAS.MESSAGE_TEXT, BAS.CREATION_DATE, BAS.CREATED_BY, BAS.LAST_UPDATE_DATE, BAS.LAST_UPDATED_BY, BAS.LAST_UPDATE_LOGIN, BAS.DESCRIPTION, BAS.TYPE, BAS.MAX_LENGTH FROM FND_NEW_MESSAGES BAS, JTM_FND_NEW_MESSAGES_ACC ACC WHERE BAS.LANGUAGE_CODE = asg_base.get_language AND BAS.LANGUAGE_CODE = ACC.LANGUAGE_CODE AND BAS.APPLICATION_ID = ACC.APPLICATION_ID AND BAS.MESSAGE_NAME = ACC.MESSAGE_NAME

View Text - HTML Formatted

SELECT ACC.ACCESS_ID
, BAS.APPLICATION_ID
, BAS.LANGUAGE_CODE
, BAS.MESSAGE_NUMBER
, BAS.MESSAGE_NAME
, BAS.MESSAGE_TEXT
, BAS.CREATION_DATE
, BAS.CREATED_BY
, BAS.LAST_UPDATE_DATE
, BAS.LAST_UPDATED_BY
, BAS.LAST_UPDATE_LOGIN
, BAS.DESCRIPTION
, BAS.TYPE
, BAS.MAX_LENGTH
FROM FND_NEW_MESSAGES BAS
, JTM_FND_NEW_MESSAGES_ACC ACC
WHERE BAS.LANGUAGE_CODE = ASG_BASE.GET_LANGUAGE
AND BAS.LANGUAGE_CODE = ACC.LANGUAGE_CODE
AND BAS.APPLICATION_ID = ACC.APPLICATION_ID
AND BAS.MESSAGE_NAME = ACC.MESSAGE_NAME