Operation Details
Description: Reads a list of the services supplied by a Service Supplier but not covered by the current contract
Sterotype: nsmulti
SQL 
SELECT
  Service.typeCode,
  ServiceSupplierLink.serviceID
INTO
  :typeCode,
  :serviceID 
FROM
  Service,
  ServiceSupplierLink 
WHERE ServiceSupplierLink.supplierConcernRoleID = :concernRoleID 
  AND ServiceSupplierLink.serviceID NOT in 
  ( 
  SELECT
    serviceID 
  FROM
    ContractServiceLink 
  WHERE ContractServiceLink .contractID = :contractID 
  ) 
  AND Service.serviceID = ServiceSupplierLink.serviceID 
  AND Service.statusCode = :statusCode 
  AND ServiceSupplierLink.statusCode = :statusCode