Operation Details
Description: Returns the lowest deduction priority associated with a specified product. The lowest priority returned will be the highest numerical value i.e. in a list with priorities 1, 2, 3, 4, 5, the lowest priority would be 5.
Sterotype: ns
SQL 
SELECT
  MAX(priority)
INTO
  :priority 
FROM
  DeductionProductLink 
WHERE productID = :productID