Operation Details
Description: Reads a summary list of Provision Location details for ProvisionID
Sterotype: nsmulti
SQL
SELECT
  ProvisionLocation.provisionLocationID,
  ProvisionLocation.providerLocationID,
  ProvisionLocation.productProvisionID,
  ProviderLocation.name,
  ProvisionLocation.creationDate,
  ProvisionLocation.startDate,
  ProvisionLocation.endDate,
  ProvisionLocation.statusCode,
  ProvisionLocation.versionNo
INTO
  :provisionLocationID,
  :providerLocationID,
  :productProvisionID,
  :providerLocationName,
  :creationDate,
  :startDate,
  :endDate,
  :statusCode,
  :versionNo 
FROM
  ProvisionLocation,
  ProviderLocation 
WHERE :productProvisionID = ProvisionLocation.productProvisionID 
  AND ProvisionLocation.providerLocationID = ProviderLocation.providerLocationID