--ABS-168740
ALTER TABLE ERP_O_CLEANROOM_WEARERINVENTORY ADD (OLD_CUSTOMERNUMBER_WE NUMBER,
                                                 NEW_CUSTOMERNUMBER_WE NUMBER,
                                                 OLD_WEARERNUMBER_WE   NUMBER,
                                                 NEW_WEARERNUMBER_WE   NUMBER);

CREATE SEQUENCE SEQ_WEARER_LINK_HISTORY
START WITH 1
INCREMENT BY 1;
                                                 
CREATE TABLE WEARER_LINK_HISTORY (
WEARER_LINK_HISTORY_ID NUMBER NOT NULL,
OLD_CUSTOMERID         NUMBER,
NEW_CUSTOMERID         NUMBER, 
OLD_WEARERNUMBER       NUMBER,
NEW_WEARERNUMBER       NUMBER,
SYSTEMUSER_ID          NUMBER NOT NULL, 
TIMESTAMP              DATE   NOT NULL);

ALTER TABLE WEARER_LINK_HISTORY 
ADD CONSTRAINT PKWEARER_LINK_HISTORY PRIMARY KEY (WEARER_LINK_HISTORY_ID);
