-- ABS-146943
ALTER TABLE ERP_U_LOST_CUSTOMER ADD (CUSTOMERACTIVE VARCHAR2(1) DEFAULT 'N' NOT NULL
                                                    CONSTRAINT CHK_ERP_U_LOST_CUST_CUSTOMERACTIVE CHECK (CUSTOMERACTIVE IN ('Y', 'N')));