Operation Details
Description: This readmulti will read all of the products provided by the provider
Sterotype: nsmulti
SQL
SELECT
  ProductProvision.productID,
  Product.name,
  ProductProvision.productProvisionID,
  Product.typeCode,
  ProductProvision.startDate,
  ProductProvision.endDate
INTO
  :productID,
  :name,
  :productProvisionID,
  :typeCode,
  :startDate,
  :endDate 
FROM
  Product,
  ProductProvision 
WHERE ProductProvision.providerConcernRoleID = :concernRoleID 
  AND Product.productID = ProductProvision.productID