Operation Details
Description: COMMENTS=Retrieves details of all evidence approval checks for the specified organization unit.
Sterotype: nsmulti
SQL 
SELECT
  EvidenceApprovalCheck.evidenceApprovalCheckID,
  EvidenceApprovalCheck.typeCode,
  EvidenceApprovalCheck.percentage,
  EvidenceApprovalCheck.productID,
  EvidenceApprovalCheck.comments,
  EvidenceApprovalCheck.recordStatus,
  Product.name
INTO
  :evidenceApprovalCheckID,
  :typeCode,
  :percentage,
  :productID,
  :comments,
  :recordStatus,
  :productName 
FROM
  EvidenceApprovalCheck 
  
  LEFT OUTER JOIN
  
  Product 
  ON (Product.productID = EvidenceApprovalCheck.productID) 
WHERE EvidenceApprovalCheck.organisationUnitID = :organisationUnitID