Operation Details
Description: Read the details of a case approval check
Sterotype: ns
SQL 
SELECT
  CaseApprovalCheck.caseApprovalCheckID,
  CaseApprovalCheck.typeCode,
  CaseApprovalCheck.percentage,
  CaseApprovalCheck.estimatedCost,
  CaseApprovalCheck.productID,
  CaseApprovalCheck.userName,
  CaseApprovalCheck.organisationUnitID,
  CaseApprovalCheck.statusCode,
  CaseApprovalCheck.comments,
  CaseApprovalCheck.versionNo,
  Product.name
INTO
  :caseApprovalCheckID,
  :typeCode,
  :percentage,
  :estimatedCost,
  :productID,
  :userName,
  :organisationUnitID,
  :statusCode,
  :comments,
  :versionNo,
  :productName 
FROM
  CaseApprovalCheck 
  
  LEFT OUTER JOIN
  
  Product 
  ON (Product.productID = CaseApprovalCheck.productID) 
WHERE CaseApprovalCheck.caseApprovalCheckID = :caseApprovalCheckID