Database SQL Operation: SOPerformanceMeasureLink.searchByServiceOffering
Description: | @deprecated since 7.0.0.0, This functionality forms part of a feature that is no longer relevant to the product strategy and will not be replaced. |
Sterotype: | nsmulti |
SELECT
SOPerformanceMeasureLink.soPerformanceMeasureLinkID,
SOPerformanceMeasureLink.serviceOfferingID,
SOPerformanceMeasureLink.recordStatus,
PerformanceMeasure.measure,
PerformanceMeasure.performanceMeasureID
INTO
:soPerformanceMeasureLinkID,
:serviceOfferingID,
:status,
:measure,
:performanceMeasureID
FROM
SOPerformanceMeasureLink,
PerformanceMeasure
WHERE SOPerformanceMeasureLink.serviceOfferingID = :serviceOfferingID
AND SOPerformanceMeasureLink.performanceMeasureID = PerformanceMeasure.performanceMeasureID
AND PerformanceMeasure.recordStatus = :status
|