Operation Details
Description: Method to return the current delivery frequency history record for a product using the product's unique identifier
Sterotype: ns
SQL 
SELECT
  ProductDeliveryFrequencyHist.prodDeliveryFreqHistoryID,
  ProductDeliveryFrequencyHist.productID,
  ProductDeliveryFrequencyHist.startDate,
  ProductDeliveryFrequencyHist.endDate,
  ProductDeliveryFrequencyHist.deliveryFrequency,
  ProductDeliveryFrequencyHist.versionNo
INTO
  :prodDeliveryFreqHistoryID,
  :productID,
  :startDate,
  :endDate,
  :deliveryFrequency,
  :versionNo 
FROM
  ProductDeliveryFrequencyHist 
WHERE ProductDeliveryFrequencyHist.productID = :productID 
  AND ProductDeliveryFrequencyHist.endDate IS NULL