Operation Details
Description: Searches for all 'Active', 'In-Edit' or 'Identical In-Edit' records with the given shared instance ID on the specified case.
Sterotype: nsmulti
SQL 
SELECT
  evidenceDescriptorID,
  caseID,
  participantID,
  statusCode,
  receivedDate,
  effectiveFrom,
  correctionSetID,
  successionID,
  relatedID,
  evidenceType,
  pendingRemovalInd,
  pendingUpdateInd,
  newInd,
  approvalRequestedInd,
  sharedInstanceID,
  sharedInd,
  changeReceivedDate,
  evidenceActivationDate,
  sharedUnchangedInd,
  sourceCaseID,
  changeReason,
  externalSourceCaseInd,
  versionNo
INTO
  :evidenceDescriptorID,
  :caseID,
  :participantID,
  :statusCode,
  :receivedDate,
  :effectiveFrom,
  :correctionSetID,
  :successionID,
  :relatedID,
  :evidenceType,
  :pendingRemovalInd,
  :pendingUpdateInd,
  :newInd,
  :approvalRequestedInd,
  :sharedInstanceID,
  :sharedInd,
  :changeReceivedDate,
  :evidenceActivationDate,
  :sharedUnchangedInd,
  :sourceCaseID,
  :changeReason,
  :externalSourceCaseInd,
  :versionNo 
FROM
  EvidenceDescriptor 
WHERE caseID = :caseID 
  AND sharedInstanceID = :sharedInstanceID 
  AND 
  (
    statusCode = :statusCode1 
    OR statusCode = :statusCode2 
    OR statusCode = :statusCode3 
  )