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
|