-- ABS-16152/ ABS-29833/ ABS-15624

ALTER TABLE DELIVERYSCAN
  DROP CONSTRAINT DELIVERYSCAN_ROUTECONTROL_ID;

ALTER TABLE DELIVERYSCAN
  ADD CONSTRAINT DELIVERYSCAN_ROUTECONTROL_ID FOREIGN KEY (ROUTECONTROL_ID)
  REFERENCES ROUTECONTROL (ROUTECONTROL_ID) ON DELETE SET NULL;