Operation Details |
Description: | Counts the number of live evidence records for an evidence type version. Live records are considered the evidence records with status ACTIVE, INEDIT, IDENTICALINEDIT or NONIDENTICALINEDIT |
Sterotype: | ns |
SQL |
SELECT count(*) INTO :counter FROM ProductEvidenceTypeDefLink WHERE ProductEvidenceTypeDefLink.evidenceTypeDefID = :evidenceTypeDefID AND ProductEvidenceTypeDefLink.productID = :productID |