Operation Details
Description: Retrieves the details of the product delivery necessary for case evaluation.
Sterotype: ns
SQL 
SELECT
  ProductDelivery.productID,
  ProductDelivery.freqOverrideInd,
  ProductDelivery.recipConcernRoleID,
  ProductDelivery.productProviderID,
  ProductDelivery.providerLocationID,
  ProductDelivery.versionNo,
  Product.estimatedCost,
  Product.estimateCostInd,
  Product.defaultProductDelPatternID
INTO
  :productID,
  :freqOverrideInd,
  :recipConcernRoleID,
  :productProviderID,
  :providerLocationID,
  :versionNo,
  :estimatedCost,
  :estimateCostInd,
  :defaultProductDelPatternID 
FROM
  ProductDelivery,
  Product 
WHERE ProductDelivery.caseID = :caseID 
  AND Product.productID = ProductDelivery.productID