Operation Details
Description: This method returns a list of the other versions of a given evidence form available for a product. (if any)
Sterotype: nsmulti
SQL 
SELECT
  ProductEvidenceFormLink.evidenceFormID,
  EvidenceForm.evidenceNameCode,
  EvidenceForm.caseEvidenceType,
  EvidenceForm.startDate,
  EvidenceForm.endDate
INTO
  :evidenceFormID,
  :evidenceNameCode,
  :caseEvidenceType,
  :startDate,
  :endDate 
FROM
  ProductEvidenceFormLink,
  EvidenceForm 
WHERE 
  (
    
    (
      ProductEvidenceFormLink.productID = :productID 
      AND EvidenceForm.evidenceFormID = ProductEvidenceFormLink.evidenceFormID 
    ) 
    OR :productIDIsNull <> '0' 
  ) 
  AND EvidenceForm.caseEvidenceType = :caseEvidenceType 
  AND ProductEvidenceFormLink.recordStatus = :recordStatus 
  AND EvidenceForm.evidenceNameCode <> :evidenceNameCode