ALTER TABLE DEDUCAOROP ADD CDSERVFILI VARCHAR2(05) NULL
/
ALTER TABLE PARFILIALROP ADD IDAPURETIPLA VARCHAR2(01) DEFAULT 'N' NOT NULL
      CONSTRAINT CKC_IDAPURETIPLA_PARFILIALROP CHECK (IDAPURETIPLA IN ('S','N'))
/
ALTER TABLE PARFILIALROP ADD IDAPURETIEST VARCHAR2(01) DEFAULT 'N' NOT NULL
      CONSTRAINT CKC_IDAPURETIEST_PARFILIALROP CHECK (IDAPURETIEST IN ('S','N'))
/
ALTER TABLE EXTRATOCONS ADD NRORG NUMBER DEFAULT SYS_CONTEXT('nrorg_ctx','nrorg') NOT NULL
/
ALTER TABLE EXTRATOCONS ADD IDATIVO VARCHAR2(1) DEFAULT 'S' NOT NULL
/
ALTER TABLE EXTRATOCONS ADD CONSTRAINT CKC_IDATIVO_EXTRATOCONS CHECK (IDATIVO IN ('S', 'N'))
/
ALTER TABLE EXTRATOCONS ADD DTINCLUSAO DATE NULL
/
ALTER TABLE EXTRATOCONS ADD DTULTATU DATE NULL
/
ALTER TABLE EXTRATOCONS ADD NRORGINCLUSAO NUMBER DEFAULT 1 NULL
/
ALTER TABLE EXTRATOCONS ADD CDOPERINCLUSAO VARCHAR2(12) DEFAULT '1' NULL
/
ALTER TABLE EXTRATOCONS ADD NRORGULTATU NUMBER DEFAULT 1 NULL
/
ALTER TABLE EXTRATOCONS ADD CDOPERULTATU VARCHAR2(12) DEFAULT '1' NULL
/
ALTER TABLE REMPRODNUTR ADD (
IDATIVO VARCHAR2(1) DEFAULT 'S' NOT NULL
CONSTRAINT CKC_IDATIVO_REMPRODNUTR CHECK (IDATIVO IN ('S','N')),
DTINCLUSAO DATE NULL,
DTULTATU DATE NULL,
NRORGINCLUSAO NUMBER DEFAULT SYS_CONTEXT('nrorg_ctx','nrorg') NULL,
CDOPERINCLUSAO VARCHAR2(12) DEFAULT '1' NULL,
NRORGULTATU NUMBER DEFAULT SYS_CONTEXT('nrorg_ctx','nrorg') NULL,
CDOPERULTATU VARCHAR2(12) DEFAULT '1'
)
/
ALTER TABLE SIT_LOGPROD ADD (
IDATIVO VARCHAR2(1) DEFAULT 'S' NOT NULL
CONSTRAINT CKC_IDATIVO_SIT_LOGPROD CHECK (IDATIVO IN ('S','N')),
DTINCLUSAO DATE NULL,
DTULTATU DATE NULL,
NRORGINCLUSAO NUMBER DEFAULT SYS_CONTEXT('nrorg_ctx','nrorg') NULL,
CDOPERINCLUSAO VARCHAR2(12) DEFAULT '1' NULL,
NRORGULTATU NUMBER DEFAULT SYS_CONTEXT('nrorg_ctx','nrorg') NULL,
CDOPERULTATU VARCHAR2(12) DEFAULT '1'
)