Operation Details |
Description: | Retrieves a list of products covered by a contract |
Sterotype: | nsmulti |
SQL |
SELECT Product.typeCode, ContractProductLink.productID INTO :typeCode, :productID FROM Product, ContractProductLink WHERE ContractProductLink.contractID = :contractID AND Product.productID = ContractProductLink.productID |