| Operation Details |  |
| Description: | Reads the case home page name and product type for a Product Delivery. |
| Sterotype: | ns |
| SQL | |
SELECT Product.caseHomePageName, Product.typeCode, CaseHeader.caseReference INTO :caseHomePageName, :typeCode, :caseReference FROM Product, ProductDelivery, CaseHeader WHERE ProductDelivery.caseID = :caseID AND ProductDelivery.productID = Product.productID AND CaseHeader.caseID = ProductDelivery.caseID |