Operation Details |
Description: | @deprecated by searchProvisionByProductID1. @deprecated-since V6.0. Reads a summary list of product providers for a product. |
Sterotype: | nsmulti |
SQL |
SELECT ProductProvision.productProvisionID, ProductProvision.providerConcernRoleID, ProductProvider.name, ProductProvision.startDate, ProductProvision.endDate, ProductProvision.statusCode, ProductProvision.versionNo INTO :productProvisionID, :providerConcernRoleID, :productProviderName, :startDate, :endDate, :statusCode, :versionNo FROM ProductProvision, ProductProvider WHERE :productID = ProductProvision.productID AND ProductProvision.providerConcernRoleID = ProductProvider.concernRoleID |