Database SQL Operation: ProductDelivery.readProductSecurityDetails
Description: | Retrieves the product security details of the product which relates to this Product Delivery. |
Sterotype: | ns |
SELECT
Product.maintainSecurity,
Product.readSecurity,
Product.approveSecurity,
Product.createSecurity,
Product.locationSecurityLevel
INTO
:maintainSecurity,
:readSecurity,
:approveSecurity,
:createSecurity,
:locationSecurityLevel
FROM
ProductDelivery,
Product
WHERE ProductDelivery.caseID = :caseID
AND ProductDelivery.productID = Product.productID
|