Operation Details |
Description: | Method to return a list of ProductDeliveryPattern records by caseID. |
Sterotype: | nsmulti |
SQL |
SELECT ProductDeliveryPattern.productDeliveryPatternID, ProductDeliveryPattern.productID INTO :productDeliveryPatternID, :productID FROM ProductDeliveryPattern, ProductDelivery WHERE ProductDelivery.caseID = :caseID AND ProductDeliveryPattern.productID = ProductDelivery.productID |