Operation Details |
Description: | |
Sterotype: | nsmulti |
SQL |
SELECT va.verificationAttachmentLinkID, va.description, a.documentType, a.receiptDate, a.receiptDate, va.recordStatus INTO :verificationAttachmentLinkID, :description, :documentType, :dateReceived, :dateReceivedOpt, :recordStatus FROM VerificationAttachmentLink va, Attachment a WHERE va.verificationItemProvidedID = :verificationItemProvidedID AND va.attachmentID = a.attachmentID |