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_JTF_NOTES_V

Source

View Text - Preformatted


SELECT JJN.ACCESS_ID , JNB.JTF_NOTE_ID , JNB.PARENT_NOTE_ID , JNB.SOURCE_OBJECT_ID , JNB.SOURCE_OBJECT_CODE , JNB.NOTE_STATUS , JNB.ENTERED_BY , JNB.ENTERED_DATE , JNB.NOTE_TYPE , JNT.NOTES , JNT.LANGUAGE , TO_CHAR( JNB.SOURCE_OBJECT_ID) AS SOURCE_OBJECT_ID_CHAR FROM JTF_NOTES_B JNB , JTF_NOTES_TL JNT , JTM_JTF_NOTES_ACC JJN WHERE JNB.JTF_NOTE_ID = JNT.JTF_NOTE_ID AND JNB.JTF_NOTE_ID = JJN.JTF_NOTE_ID AND JNT.LANGUAGE = ASG_BASE.GET_LANGUAGE AND JJN.RESOURCE_ID = ASG_BASE.GET_RESOURCE_ID

View Text - HTML Formatted

SELECT JJN.ACCESS_ID
, JNB.JTF_NOTE_ID
, JNB.PARENT_NOTE_ID
, JNB.SOURCE_OBJECT_ID
, JNB.SOURCE_OBJECT_CODE
, JNB.NOTE_STATUS
, JNB.ENTERED_BY
, JNB.ENTERED_DATE
, JNB.NOTE_TYPE
, JNT.NOTES
, JNT.LANGUAGE
, TO_CHAR( JNB.SOURCE_OBJECT_ID) AS SOURCE_OBJECT_ID_CHAR
FROM JTF_NOTES_B JNB
, JTF_NOTES_TL JNT
, JTM_JTF_NOTES_ACC JJN
WHERE JNB.JTF_NOTE_ID = JNT.JTF_NOTE_ID
AND JNB.JTF_NOTE_ID = JJN.JTF_NOTE_ID
AND JNT.LANGUAGE = ASG_BASE.GET_LANGUAGE
AND JJN.RESOURCE_ID = ASG_BASE.GET_RESOURCE_ID