-- ABS-106868/ ABS-135067
ALTER TABLE PLANTPRODUCTSETTINGS ADD (SUPPRESSONPACKINGREPORTS NUMBER DEFAULT 0 NOT NULL
                                                               CONSTRAINT CHK_PPS_SUPPRESSONPR CHECK (SUPPRESSONPACKINGREPORTS IN (0, 1, 2)));

COMMENT ON COLUMN PLANTPRODUCTSETTINGS.SUPPRESSONPACKINGREPORTS
  IS '0 = Inherit
1 = No
2 = Yes
';


ALTER TABLE PRODUCT ADD (SUPPRESSONPACKINGREPORTS NUMBER DEFAULT 1 NOT NULL
                                                  CONSTRAINT CHK_PRODUCT_SUPPRESSONPR CHECK (SUPPRESSONPACKINGREPORTS IN (1, 2)));

COMMENT ON COLUMN PRODUCT.SUPPRESSONPACKINGREPORTS
  IS '1 = No 
2 = Yes
';


ALTER TABLE PRODUCTLISTPERCUSTOMER ADD (SUPPRESSONPACKINGREPORTS NUMBER DEFAULT 0 NOT NULL
                                       CONSTRAINT CHK_PLPC_SUPPRESSONPR CHECK (SUPPRESSONPACKINGREPORTS IN (0, 1, 2)));
 
COMMENT ON COLUMN PRODUCTLISTPERCUSTOMER.SUPPRESSONPACKINGREPORTS
  IS '0 = Inherit
1 = No
2 = Yes
';


