Operation Details
Description:  
Sterotype: nsmulti
SQL 
SELECT
  AdminICEvidenceLink.adminICEvidenceLinkID,
  AdminICEvidenceLink.adminIntegratedCaseID,
  AdminICEvidenceLink.evidenceMetadataID,
  AdminICEvidenceLink.shareableInd,
  AdminICEvidenceLink.category,
  AdminICEvidenceLink.sortOrder,
  AdminICEvidenceLink.quickLinkInd,
  EvidenceMetadata.evidenceType
INTO
  :evidenceTypeLinkID,
  :associatedID,
  :evidenceTypeID,
  :shareableInd,
  :category,
  :sortOrder,
  :quickLinkInd,
  :evidenceTypeCode 
FROM
  AdminICEvidenceLink,
  EvidenceMetadata 
WHERE AdminICEvidenceLink.adminIntegratedCaseID = :adminIntegratedCaseID 
  AND EvidenceMetadata.evidenceMetadataID = AdminICEvidenceLink.evidenceMetadataID 
  AND EvidenceMetadata.recordStatus = :recordStatus