Operation Details
Description: This method will retrieve all of the evidence forms available to be added to an integrated case.
Sterotype: nsmulti
SQL 
SELECT
  ProductEvidenceFormLink.evidenceFormID,
  EvidenceForm.evidenceNameCode,
  EvidenceForm.caseEvidenceType,
  EvidenceForm.startDate,
  EvidenceForm.endDate
INTO
  :evidenceFormID,
  :evidenceNameCode,
  :caseEvidenceType,
  :startDate,
  :endDate 
FROM
  ProductEvidenceFormLink,
  EvidenceForm,
  ProductCategory,
  Product 
WHERE 
  (
    ProductCategory.categoryCode = :integratedCaseType 
    AND Product.statusCode = :recordStatus 
    AND Product.productID = ProductCategory.productID 
  ) 
  AND ProductEvidenceFormLink.productID = Product.productID 
  AND ProductEvidenceFormLink.recordStatus = :recordStatus 
  AND EvidenceForm.evidenceFormID = ProductEvidenceFormLink.evidenceFormID 
  AND NOT EXISTS 
  ( 
  SELECT
    * 
  FROM
    CaseEvidence,
    CaseEvidenceType 
  WHERE CaseEvidence.caseID = :caseID 
    AND CaseEvidenceType.evidenceID = CaseEvidence.evidenceID 
    AND EvidenceForm.evidenceNameCode = CaseEvidenceType.evidenceFormName 
  )