Operation Details
Description: Operation to read all milestone deliveries where the expected end date has reached and the status is either Not Started or In Progress.
Sterotype: nsmulti
SQL 
SELECT
  milestoneDeliveryID,
  milestoneConfigurationID,
  caseID,
  ownerUserName,
  expectedStartDate,
  expectedEndDate,
  actualStartDate,
  actualEndDate,
  comments,
  status
INTO
  :milestoneDeliveryID,
  :milestoneConfigurationID,
  :caseID,
  :ownerUserName,
  :expectedStartDate,
  :expectedEndDate,
  :actualStartDate,
  :actualEndDate,
  :comments,
  :status 
FROM
  MilestoneDelivery 
WHERE status <> :status 
  AND expectedEndDate < :endDate