Operation Details
Description: Reads attachment details for the specified transcription request.
Sterotype: ns
SQL 
SELECT
  Attachment.attachmentID,
  attachmentContents,
  attachmentName,
  attachmentStatus,
  Attachment.versionNo,
  Attachment.fileLocation,
  Attachment.fileReference,
  Attachment.statusCode
INTO
  :attachmentID,
  :attachmentContents,
  :attachmentName,
  :attachmentStatus,
  :versionNo,
  :fileLocation,
  :fileReferenceNumber,
  :attachmentRecordStatus 
FROM
  HearingTranscriptionRequest,
  CaseAttachmentLink,
  Attachment 
WHERE hearingTranscriptionRequestID = :hearingTranscriptionRequestID 
  AND HearingTranscriptionRequest.caseAttachmentLinkID = CaseAttachmentLink.caseAttachmentLinkID 
  AND CaseAttachmentLink.attachmentID = Attachment.attachmentID