Operation Details
Description: Retrieves the details of a case note @deprecated - replaced by {@link #readNote1()} @deprecated-since Version 6.0
Sterotype: ns
SQL 
SELECT
  CaseNote.caseNoteID,
  CaseNote.caseID,
  CaseNote.recordStatus,
  Note.sensitivityCode,
  Note.notesText,
  Note.creationDateTime,
  Note.priorityCode,
  Users.fullName,
  Note.userName,
  CaseNote.noteID,
  CaseNote.versionNo
INTO
  :caseNoteID,
  :caseID,
  :recordStatus,
  :sensitivityCode,
  :notesText,
  :creationDateTime,
  :priorityCode,
  :fullname,
  :userName,
  :noteID,
  :versionNo 
FROM
  CaseNote,
  Note,
  Users 
WHERE CaseNote.caseNoteID = :caseNoteID 
  AND Note.noteID = CaseNote.noteID 
  AND Note.userName = Users.userName