Operation Details
Description: Returns a list of service suppliers matching the type
Sterotype: nsmulti
SQL 
SELECT
  ServiceSupplier.concernRoleID,
  ServiceSupplier.name,
  ServiceSupplier.statusCode,
  ServiceSupplier.comments,
  ServiceSupplier.primaryAlternateID,
  ServiceSupplier.paymentFrequency,
  ServiceSupplier.primaryAlternateID,
  ServiceSupplier.methodOfPmtCode,
  ServiceSupplier.nextPaymentDate
INTO
  :concernRoleID,
  :name,
  :statusCode,
  :comments,
  :primaryAlternateID,
  :paymentFrequency,
  :primaryAlternateID,
  :methodOfPmtCode,
  :nextPaymentDate 
FROM
  Service,
  ServiceSupplier,
  ServiceSupplierLink 
WHERE Service.serviceID = ServiceSupplierLink.serviceID 
  AND ServiceSupplier.concernRoleID = ServiceSupplierLink.supplierConcernRoleID 
  AND Service.typeCode = :typeCode