Operation Details
Description: Reads details of a case attachment.
Sterotype: ns
SQL 
SELECT
  Attachment.attachmentName,
  Attachment.attachmentContents,
  Attachment.attachmentStatus,
  Attachment.receiptDate,
  Attachment.documentType,
  Attachment.fileLocation,
  Attachment.fileReference,
  Attachment.versionNo,
  CaseAttachmentLink.attachmentDate,
  CaseAttachmentLink.caseParticipantRoleID
INTO
  :attachmentName,
  :attachmentContents,
  :attachmentStatus,
  :receiptDate,
  :documentType,
  :fileLocation,
  :fileReference,
  :versionNo,
  :attachmentDate,
  :caseParticipantRoleID 
FROM
  Attachment,
  CaseAttachmentLink 
WHERE Attachment.attachmentID = :attachmentID 
  AND CaseAttachmentLink.attachmentID = Attachment.attachmentID