Operation Details
Description: Returns a list of locations based on a Product and Product Provider combination
Sterotype: nsmulti
SQL 
SELECT
  ProviderLocation.providerLocationID,
  ProviderLocation.name,
  ProviderLocation.startDate,
  ProviderLocation.endDate,
  ProviderLocation.statusCode,
  ProviderLocation.addressID,
  ProviderLocation.productProviderID
INTO
  :providerLocationID,
  :name,
  :startDate,
  :endDate,
  :statusCode,
  :addressID,
  :productProviderID 
FROM
  ProviderLocation,
  ProvisionLocation,
  ProductProvision 
WHERE ProviderLocation.providerLocationID = ProvisionLocation.providerLocationID 
  AND ProvisionLocation.productProvisionID = ProductProvision.productProvisionID 
  AND ProductProvision.productID = :productID 
  AND ProductProvision.providerConcernRoleID = :productProviderID