-- ABS-167856 OutOfMemory error when generating PackingNotes with Load Optimizer
UPDATE PLANTPRODUCTSETTINGS SET PACKINGPRODUCTTYPE = NULL WHERE PACKINGPRODUCTTYPE NOT IN (1, 2);
COMMIT;

ALTER TABLE PLANTPRODUCTSETTINGS ADD CONSTRAINT PACKINGPRODUCTTYPE_VALID CHECK (PACKINGPRODUCTTYPE IN (1, 2));
