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.

[Home] [Help]

View: AST_NOTES_LITE_VL

Product:	AST - TeleSales
Description:
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT B.JTF_NOTE_ID
, B.SOURCE_OBJECT_ID
, B.SOURCE_OBJECT_CODE
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_LOGIN
, T.NOTES
, B.ENTERED_BY
, B.ENTERED_DATE
, OT.NAME
, B.NOTE_TYPE
, RES.SOURCE_NAME
, B.NOTE_STATUS
FROM JTF_RS_RESOURCE_EXTNS RES
, JTF_NOTES_B B
, JTF_NOTES_TL T
, JTF_OBJECTS_TL OT
WHERE B.JTF_NOTE_ID = T.JTF_NOTE_ID
AND T.LANGUAGE = USERENV('LANG')
AND B.SOURCE_OBJECT_CODE = OT.OBJECT_CODE
AND OT.LANGUAGE = USERENV('LANG')
AND RES.USER_ID(+) = B.CREATED_BY

Columns

Name
JTF_NOTE_ID
SOURCE_OBJECT_ID
SOURCE_OBJECT_CODE
CREATION_DATE
CREATED_BY
LAST_UPDATE_LOGIN
NOTES
ENTERED_BY
ENTERED_DATE
SOURCE_OBJECT_MEANING
NOTE_TYPE
ENTERED_BY_NAME
NOTE_STATUS