--ABS-168740

--WEARER_LINK_HISTORY TABLE
ALTER TABLE WEARER_LINK_HISTORY ADD (TRANSFERRED_WE VARCHAR2(1) DEFAULT 'N' NOT NULL CONSTRAINT CHK_WEARERLINKHISTORY_TRANSFERRED CHECK (TRANSFERRED_WE IN ('Y', 'N')));

--ERP_O_CLEANROOM
ALTER TABLE ERP_O_CLEANROOM_WEARERINVENTORY ADD (TRANSFERRED_WE VARCHAR2(1) DEFAULT 'N' NOT NULL CONSTRAINT CHK_ERPCLEANROOMWEARERINV_TRANSFERRED CHECK (TRANSFERRED_WE IN ('Y', 'N')));
