-- ABS-146943 
ALTER TABLE ERP_U_LOST_CUSTOMER ADD (WEARERSINACTIVE VARCHAR2(1) DEFAULT 'N' NOT NULL
                                                     CONSTRAINT CHK_ERP_U_LOST_CUST_WEARERSINACTIVE CHECK (WEARERSINACTIVE IN ('Y', 'N')),
                                     FLAGITEMS VARCHAR2(1) DEFAULT 'N' NOT NULL
                                                     CONSTRAINT CHK_ERP_U_LOST_CUST_FLAGITEMS CHECK (FLAGITEMS IN ('Y', 'N')),
                                     FLAGSTARTDATE DATE NULL);

ALTER TABLE ERP_U_LOST_CUSTOMER
  ADD CONSTRAINT CHK_ERP_U_LOST_CUST_FLAG
  CHECK ((FLAGSTARTDATE IS NULL AND FLAGITEMS = 'N') OR (FLAGSTARTDATE IS NOT NULL AND FLAGITEMS = 'Y'));
