--Order 20013755.140

ALTER TABLE SQITEMINCIRCULATION
  ADD (WEARERINVOICECATEGORY_ID NUMBER NULL);

CREATE INDEX XIF10SQITEMINCIRCULATION ON SQITEMINCIRCULATION
(WEARERINVOICECATEGORY_ID   ASC);

ALTER TABLE SQITEMINCIRCULATION
ADD CONSTRAINT WEARERINVCATEG_SQITEMINCIRC FOREIGN KEY (WEARERINVOICECATEGORY_ID) REFERENCES WEARERINVOICECATEGORY (WEARERINVOICECATEGORY_ID);

ALTER TABLE DELIVERYSCAN
  ADD (WEARERINVOICECATEGORY_ID NUMBER NULL);

CREATE INDEX XIF17DELIVERYSCAN ON DELIVERYSCAN
(WEARERINVOICECATEGORY_ID   ASC);

ALTER TABLE DELIVERYSCAN
ADD CONSTRAINT WEARERINVCATEG_DELIVERYSCAN FOREIGN KEY (WEARERINVOICECATEGORY_ID) REFERENCES WEARERINVOICECATEGORY (WEARERINVOICECATEGORY_ID);