Operation Details |
Description: | |
Sterotype: | nsmulti |
SQL |
SELECT ED.evidenceDescriptorID INTO :evidenceDescriptorID FROM EvidenceDescriptor ED, EvidenceChangehistory ECH WHERE ED.caseID = :caseID AND ( ED.statusCode = :statusCode1 OR ED.statusCode = :statusCode2 ) AND ED.evidenceDescriptorID = ECH.evidenceDescriptorID |