Operation Details
Description: Retrieves a list of services supplied by a concern
Sterotype: nsmulti
SQL
SELECT
  ServiceSupplierLink.serviceID,
  ServiceSupplierLink.serviceSupplierLinkID,
  ServiceSupplierLink.supplierConcernRoleID,
  Service.typeCode,
  ServiceSupplierLink.startDate,
  ServiceSupplierLink.endDate,
  ServiceSupplierLink.statusCode,
  ServiceSupplierLink.versionNo,
  Service.versionNo
INTO
  :serviceID,
  :serviceSupplierLinkID,
  :supplierConcernRoleID,
  :typeCode,
  :startDate,
  :endDate,
  :statusCode,
  :serviceSupplierLinkVersionNo,
  :serviceVersionNo 
FROM
  ServiceSupplierLink,
  Service 
WHERE ServiceSupplierLink.supplierConcernRoleID = :supplierConcernRoleID 
  AND Service.serviceID = ServiceSupplierLink.serviceID