Operation Details
Description:  
Sterotype: nsmulti
SQL 
SELECT
  Verification.verificationID,
  VerificationRequirement.mandatory,
  Verification.dueDate,
  Verification.verificationStatus,
  VDIEDLink.evidenceDescriptorID,
  VDIEDLink.VDIEDLinkID,
  EvidenceDescriptor.statusCode,
  EvidenceDescriptor.correctionSetID  
  
INTO
  :verificationID,
  :mandatory,
  :dueDate,
  :verificationStatus,
  :evidenceDescriptorID,
  :VDIEDLinkID ,
  :evidenceStatus,
  :correctionSetID     
FROM
  Verification,
  VDIEDLink,
  EvidenceDescriptor,
  VerificationRequirement 
WHERE Verification.verificationLinkedID = :verificationLinkedID 
  AND Verification.verificationLinkedType = :verificationLinkedType 
  AND Verification.VDIEDLinkID = VDIEDLink.VDIEDLinkID 
  AND VDIEDLink.evidenceDescriptorID = EvidenceDescriptor.evidenceDescriptorID 
  AND Verification.verificationRequirementID = VerificationRequirement.verificationRequirementID 
  AND 
  (
    EvidenceDescriptor.statusCode = :evidenceDescriptorStatus1 
    OR EvidenceDescriptor.statusCode = :evidenceDescriptorStatus2 
    OR  EvidenceDescriptor.statusCode = :evidenceDescriptorStatus3
  ) 
ORDER BY Verification.dueDate DESC