Operation Details
Description: Returns the delivery method ID for the product delivery pattern.
Sterotype: ns
SQL 
SELECT
  ProductDeliveryPatternInfo.deliveryMethodID
INTO
  :deliveryMethodID 
FROM
  ProductDeliveryPatternInfo 
WHERE 
  (
    :productDeliveryPatternID = productDeliveryPatternID 
  ) 
  AND 
  (
    fromDate = 
    ( 
    SELECT
      MAX(fromDate) 
    FROM
      ProductDeliveryPatternInfo 
    WHERE 
      (
        :productDeliveryPatternID = productDeliveryPatternID 
      ) 
      AND 
      (
        fromDate <= :fromDate 
      ) 
    ) 
  )