--SO 20012786.30 Improve 'Scans And Counts' functionality


ALTER TABLE DELIVERYVARIATIONS
	ADD (PLANTDEPARTMENT_ID NUMBER NULL);

CREATE  INDEX XIF10DELIVERYVARIATIONS ON DELIVERYVARIATIONS
(PLANTDEPARTMENT_ID   ASC);

ALTER TABLE DELIVERYVARIATIONS
ADD CONSTRAINT DELIVERYVAR_PLANTDEPARTMENT_ID FOREIGN KEY (PLANTDEPARTMENT_ID) REFERENCES PLANTDEPARTMENT (PLANTDEPARTMENT_ID) ON DELETE SET NULL;