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: CSM.CSF_M_NOTES_INQ#

Source

View Text - Preformatted


select CLID$$CS CLID$$CS, JTF_NOTE_ID JTF_NOTE_ID, SOURCE_OBJECT_ID SOURCE_OBJECT_ID, SOURCE_OBJECT_CODE SOURCE_OBJECT_CODE, NOTES NOTES, NOTE_STATUS NOTE_STATUS, ENTERED_BY ENTERED_BY, ENTERED_DATE ENTERED_DATE, NOTE_TYPE NOTE_TYPE, LAST_UPDATE_DATE LAST_UPDATE_DATE, DMLTYPE$$ DMLTYPE$$, SEQNO$$ SEQNO$$, TRANID$$ TRANID$$, VERSION$$ VERSION$$, PARENT_NOTE_ID PARENT_NOTE_ID, CREATED_BY CREATED_BY, LAST_UPDATED_BY LAST_UPDATED_BY, SERVER_LAST_UPDATE_DATE SERVER_LAST_UPDATE_DATE, SOURCE_NAME#1 SOURCE_NAME, NOTES_DETAIL NOTES_DETAIL from "CSM"."CSF_M_NOTES_INQ"

View Text - HTML Formatted

SELECT CLID$$CS CLID$$CS
, JTF_NOTE_ID JTF_NOTE_ID
, SOURCE_OBJECT_ID SOURCE_OBJECT_ID
, SOURCE_OBJECT_CODE SOURCE_OBJECT_CODE
, NOTES NOTES
, NOTE_STATUS NOTE_STATUS
, ENTERED_BY ENTERED_BY
, ENTERED_DATE ENTERED_DATE
, NOTE_TYPE NOTE_TYPE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, DMLTYPE$$ DMLTYPE$$
, SEQNO$$ SEQNO$$
, TRANID$$ TRANID$$
, VERSION$$ VERSION$$
, PARENT_NOTE_ID PARENT_NOTE_ID
, CREATED_BY CREATED_BY
, LAST_UPDATED_BY LAST_UPDATED_BY
, SERVER_LAST_UPDATE_DATE SERVER_LAST_UPDATE_DATE
, SOURCE_NAME#1 SOURCE_NAME
, NOTES_DETAIL NOTES_DETAIL
FROM "CSM"."CSF_M_NOTES_INQ"