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
|