Operation Details
Description: Reads a summary list of product providers for a product.
Sterotype: nsmulti
SQL 
SELECT
  ProductProvision.productProvisionID,
  ProductProvision.providerConcernRoleID,
  ProductProvider.name,
  ProductProvision.creationDate,
  ProductProvision.startDate,
  ProductProvision.endDate,
  ProductProvision.statusCode,
  ProductProvision.versionNo
INTO
  :productProvisionID,
  :providerConcernRoleID,
  :productProviderName,
  :creationDate,
  :startDate,
  :endDate,
  :statusCode,
  :versionNo 
FROM
  ProductProvision,
  ProductProvider 
WHERE :productID = ProductProvision.productID 
  AND ProductProvision.providerConcernRoleID = ProductProvider.concernRoleID