Operation Details
Description: Returns a list of deductions associated with a particular product.
Sterotype: nsmulti
SQL 
SELECT
  DeductionProductLink.deductionProductLinkID,
  DeductionProductLink.deductionID,
  DeductionProductLink.priority,
  Deduction.deductionName,
  Deduction.versionNo
INTO
  :deductionProductLinkID,
  :deductionID,
  :priority,
  :deductionName,
  :versionNo
FROM
  DeductionProductLink,
  Deduction 
WHERE DeductionProductLink.productID = :productID 
  AND DeductionProductLink.deductionID = Deduction.deductionID 
ORDER BY DeductionProductLink.priority