Operation Details
Description: reads a list of services not supplied by the service supplier on the current date, with a status of normal
Sterotype: nsmulti
SQL 
SELECT
  Service.serviceID,
  Service.typeCode,
  Service.startDate,
  Service.endDate
INTO
  :serviceID,
  :typeCode,
  :startDate,
  :endDate 
FROM
  Service 
WHERE Service.statusCode = :statusCode 
  AND Service.serviceID NOT in 
  ( 
  SELECT
    ServiceSupplierLink.serviceID 
  FROM
    ServiceSupplierLink 
  WHERE ServiceSupplierLink.supplierConcernRoleID = :supplierConcernRoleID 
    AND 
    (
      ServiceSupplierLink.endDate IS NULL 
      OR ServiceSupplierLink.endDate >= :currentDate 
    ) 
    AND ServiceSupplierLink.statusCode = :statusCode 
  )