Operation Details
Description: COMMENTS=Returns details of EvidenceApprovalCheck record.
Sterotype: ns
SQL 
SELECT
  EvidenceApprovalCheck.evidenceApprovalCheckID,
  EvidenceApprovalCheck.typeCode,
  EvidenceApprovalCheck.percentage,
  EvidenceApprovalCheck.productID,
  EvidenceApprovalCheck.userName,
  EvidenceApprovalCheck.organisationUnitID,
  EvidenceApprovalCheck.recordStatus,
  EvidenceApprovalCheck.comments,
  EvidenceApprovalCheck.versionNo,
  Product.name
INTO
  :evidenceApprovalCheckID,
  :typeCode,
  :percentage,
  :productID,
  :userName,
  :organisationUnitID,
  :recordStatus,
  :comments,
  :versionNo,
  :productName 
FROM
  EvidenceApprovalCheck 
  
  LEFT OUTER JOIN
  
  Product 
  ON (Product.productID = EvidenceApprovalCheck.productID) 
WHERE EvidenceApprovalCheck.evidenceApprovalCheckID = :evidenceApprovalCheckID