ALTER TABLE PARAMPLANEJA ADD IDOBRIGINFOQTD VARCHAR2(1) DEFAULT 'N' NOT NULL
/
ALTER TABLE PARAMPLANEJA ADD CONSTRAINT CKC_IDOBRIGINFOQTD CHECK (IDOBRIGINFOQTD IN ('S', 'N'))
/
ALTER TABLE PLANRECPROD ADD QTDEVOLVIDA FLOAT(126) NULL
/
ALTER TABLE PLANRECPROD ADD QTLIBERADA FLOAT(126) NULL