Operation Details
Description: Retrieves a list of products not covered by a contract but provided by a concern
Sterotype: nsmulti
SQL 
SELECT
  Product.typeCode,
  ProductProvision.productID
INTO
  :typeCode,
  :productID 
FROM
  Product,
  ProductProvision 
WHERE ProductProvision.providerConcernRoleID = :concernRoleID 
  AND ProductProvision.productID NOT in 
  ( 
  SELECT
    productID 
  FROM
    ContractProductLink 
  WHERE ContractProductLink .contractID = :contractID 
  ) 
  AND Product.productID = ProductProvision.productID 
  AND Product.statusCode = :statusCode 
  AND ProductProvision.statusCode = :statusCode