Operation Details
Description: Retrieves a list of case notes the note is associated to.
Sterotype: nsmulti
SQL 
SELECT
  CaseNote.caseNoteID,
  CaseNote.caseID,
  CaseNote.recordStatus,
  Note.sensitivityCode,
  Note.creationDateTime,
  Note.priorityCode,
  Note.userName,
  Note.notesText,
  Note.subjectText,
  CaseNote.versionNo,
  Note.noteID
INTO
  :caseNoteID,
  :caseID,
  :recordStatus,
  :sensitivityCode,
  :creationDateTime,
  :priorityCode,
  :userName,
  :notesText,
  :subjectText,
  :versionNo,
  :noteID 
FROM
  Note,
  CaseNote
WHERE CaseNote.noteID = :noteID 
  AND Note.noteID = CaseNote.noteID