---ABS-146678

--UPDATE ERP_O_ROUTECONTROL TABLE
ALTER TABLE ERP_O_ROUTECONTROL ADD TRUCKCODE_BACKUP VARCHAR2(12);

UPDATE ERP_O_ROUTECONTROL ER SET ER.TRUCKCODE_BACKUP=ER.TRUCKCODE;
COMMIT;

UPDATE ERP_O_ROUTECONTROL ER SET ER.TRUCKCODE = NULL; 
COMMIT;

ALTER TABLE ERP_O_ROUTECONTROL MODIFY TRUCKCODE VARCHAR2(12);

UPDATE ERP_O_ROUTECONTROL ER SET ER.TRUCKCODE=ER.TRUCKCODE_BACKUP;
COMMIT;

ALTER TABLE ERP_O_ROUTECONTROL DROP COLUMN TRUCKCODE_BACKUP;


