Operation Details
Description: Return a list of ProductDeliveryPatternInfo records by productDeliveryPatternID, recordStatus and effectiveDate, where the records are greater than effectiveDate.
Sterotype: nsmulti
SQL 
SELECT
  productDeliveryPatternInfoID,
  productDeliveryPatternID,
  deliveryMethodID,
  name,
  nameTextID,
  maximumAmount,
  deliveryFrequency,
  coverPattern,
  offset,
  fromDate,
  recordStatus,
  comments
INTO
  :productDeliveryPatternInfoID,
  :productDeliveryPatternID,
  :deliveryMethodID,
  :name,
  :nameTextID,
  :maximumAmount,
  :deliveryFrequency,
  :coverPattern,
  :offset,
  :fromDate,
  :recordStatus,
  :comments 
FROM
  ProductDeliveryPatternInfo 
WHERE 
  (
    :productDeliveryPatternID = productDeliveryPatternID 
  ) 
  AND 
  (
    :recordStatus = recordStatus 
  ) 
  AND 
  (
    fromDate > :effectiveDate 
  ) 
ORDER BY fromDate