--ABS-67076 Bulk Packing Assistant with Put Away Functionality ABS-81772
-- ADD/MODIFY COLUMNS
ALTER TABLE ACTIVESTOCKLOCATION ADD (OCCUPIEDBYROUTE_ID NUMBER NULL);
-- CREATE/RECREATE INDEXES 
CREATE INDEX XIF2ACTIVESTOCKLOCATION ON ACTIVESTOCKLOCATION (OCCUPIEDBYROUTE_ID);
-- CREATE/RECREATE PRIMARY, UNIQUE AND FOREIGN KEY CONSTRAINTS 
ALTER TABLE ACTIVESTOCKLOCATION
  ADD CONSTRAINT FK_ACTIVESTOCKLOC_ROUTE_ID FOREIGN KEY (OCCUPIEDBYROUTE_ID)
  REFERENCES ROUTE (ROUTE_ID) ON DELETE SET NULL;