Operation Details
Description: To retrieve product providers where the product provider, product provision and provision location are all active.
Sterotype: nsmulti
SQL 
SELECT
  ProductProvider.registeredName,
  ProductProvider.concernRoleID,
  ProviderLocation.name,
  ProvisionLocation.providerLocationID,
  ProvisionLocation.estimateCost,
  Address.addressData
INTO
  :productProviderName,
  :productProviderID,
  :locationName,
  :providerLocationID,
  :estimatedCost,
  :addressData 
FROM
  Product,
  ProductProvider,
  ProductProvision,
  ProvisionLocation,
  ProviderLocation,
  Address 
WHERE Product.productID = :productID 
  AND Product.statusCode = :statusCode 
  AND ProductProvision.statusCode = :statusCode 
  AND ProvisionLocation.statusCode = :statusCode 
  AND ProviderLocation.statusCode = :statusCode 
  AND ProductProvision.productID = Product.productID 
  AND ProductProvider.concernRoleID = ProductProvision.providerConcernRoleID 
  AND ProvisionLocation.productProvisionID = ProductProvision.productProvisionID 
  AND ProviderLocation.providerLocationID = ProvisionLocation.providerLocationID 
  AND Address.addressID = ProviderLocation.addressID