Operation Details
Description: Returns a list of Product Deliveries based on the type and the Provider. Used as a driving cursor to the ProductDeliveriesByTypeAndProviderReport BPO
Sterotype: nsmulti
SQL 
SELECT
  ProductDelivery.caseID,
  ProductDelivery.productID,
  ProductDelivery.productType,
  ProductDelivery.productProviderID,
  ProductDelivery.providerLocationID,
  ProductDelivery.estDeliveryCost,
  CaseHeader.statusCode,
  CaseHeader.expectedStartDate,
  CaseHeader.expectedEndDate,
  CaseHeader.startDate,
  CaseHeader.endDate,
  ProductProvider.name,
  ProviderLocation.name
INTO
  :caseID,
  :productID,
  :productType,
  :productProviderID,
  :providerLocationID,
  :estDeliveryCost,
  :caseStatusCode,
  :expectedStartDate,
  :expectedEndDate,
  :startDate,
  :endDate,
  :productProviderName,
  :providerLocationName 
FROM
  ProductDelivery,
  CaseHeader,
  ProductProvider,
  ProviderLocation 
WHERE 
  (
    ProductDelivery.productType = :productDeliveryType 
    AND ProductDelivery.productProviderID = :productProviderID 
    AND ProductDelivery.productProviderID = ProductProvider.concernRoleID 
    AND ProductDelivery.providerLocationID = ProviderLocation.providerLocationID 
    AND ProductDelivery.caseID = CaseHeader.caseID 
    AND CaseHeader.statusCode <> :closedStatus 
  )