Operation Details
Description: This method returns a count of the evidence Forms, which can be added to a given Product Delivery case. These are the forms associated with the product, where no forms of that evidenceType have already been recorded.
Sterotype: ns
SQL 
SELECT
  COUNT(*)
INTO
  :recordCount 
FROM
  ProductEvidenceFormLink,
  EvidenceForm PRIMARYFORM 
WHERE ProductEvidenceFormLink.productID = :productID 
  AND ProductEvidenceFormLink.recordStatus = :recordStatus 
  AND PRIMARYFORM.evidenceFormID = ProductEvidenceFormLink.evidenceFormID 
  AND NOT EXISTS 
  ( 
  SELECT
    * 
  FROM
    CaseEvidence,
    CaseEvidenceType,
    CaseHeader,
    EvidenceForm OTHERFORM 
  WHERE CaseHeader.caseID = :caseID 
    AND 
    (
      CaseEvidence.caseID = CaseHeader.integratedCaseID 
      OR CaseEvidence.caseID = CaseHeader.caseID 
    ) 
    AND CaseEvidenceType.evidenceID = CaseEvidence.evidenceID 
    AND OTHERFORM.evidenceNameCode = CaseEvidenceType.evidenceFormName 
    AND PRIMARYFORM.caseEvidenceType = OTHERFORM.caseEvidenceType 
  )