-- ORDER 20011858



---------------- PACKINGNOTE --------------------

ALTER TABLE PACKINGNOTE DROP COLUMN WEIGHTOVERRRIDE_ID;



---------------- PACKINGNOTECONTAINER --------------------


ALTER TABLE PACKINGNOTECONTAINER ADD (WEIGHTOVERRRIDE_ID NUMBER NULL);

CREATE  INDEX XIF16PACKINGNOTECONTAINER ON PACKINGNOTECONTAINER
(WEIGHTOVERRRIDE_ID   ASC);

ALTER TABLE PACKINGNOTECONTAINER
ADD CONSTRAINT PNCONTAINER_WEIGHTOVERRRIDE_ID FOREIGN KEY (WEIGHTOVERRRIDE_ID) REFERENCES WEIGHTOVERRIDE (WEIGHTOVERRIDE_ID) ON DELETE SET NULL;