Operation Details
Description: Retrieves all products where the evidence can be shared. The details retrieved include product ID, name and product type.
Sterotype: nsmulti
SQL 
SELECT
  DISTINCT Product.productID,
  Product.name,
  Product.typeCode
INTO
  :productID,
  :productName,
  :productType 
FROM
  Product,
  ProductEvidenceLink 
WHERE ProductEvidenceLink.shareableInd = :shareableInd 
  AND ProductEvidenceLink.productID =Product.productID 
  AND Product.statusCode = :statusCode 
  AND Product.benefitInd = :benefitInd