Operation Details
Description: Used as driving cursor to RegisteredProductDeliveriesReport batch program. Returns all cases registered on a specific date or in a date range, depending on whether periodTo is populated in the input parameters.
Sterotype: nsmulti
SQL 
SELECT
  caseID,
  registrationDate,
  expectedStartDate,
  expectedEndDate,
  startDate,
  endDate,
  statusCode,
  caseTypeCode,
  ownerOrgObjectLinkID
INTO
  :caseID,
  :registrationDate,
  :expectedStartDate,
  :expectedEndDate,
  :startDate,
  :endDate,
  :statusCode,
  :caseTypeCode,
  :ownerOrgObjectLinkID 
FROM
  CaseHeader 
WHERE 
  (
    registrationDate = :periodFrom 
    AND :periodTo IS NULL 
  ) 
  OR 
  (
    registrationDate >= :periodFrom 
    AND registrationDate <= :periodTo 
  )