ALTER TABLE AUTOFORNE ADD LISTACDSUBGRPROD VARCHAR2(100) 
/  

ALTER TABLE PARASUPRI ADD IDUTLITEMRUPTURA VARCHAR2(1) DEFAULT 'N' NULL    
        CONSTRAINT CKC_PARASUPRI_IDUTLITEMRUPTURA CHECK (IDUTLITEMRUPTURA IS NULL OR (IDUTLITEMRUPTURA IN ('S','N')))
/

ALTER TABLE AUTGRUPOP DROP CONSTRAINT CKC_IDAUTGRUPOP 
/

ALTER TABLE AUTGRUPOP ADD CONSTRAINT CKC_IDAUTGRUPOP CHECK (  
   IDAUTGRUPOP IN ('PCMP','PROD','INAC','ALAC','ENAC','VIAC','INDF','STAR','VALI', 
                   'CONT','VPLA','VPLT','VERI','QUAL','VLIB','CINS','CANA','LLOT', 
                   'FINC','TARE','IRET','RCUS','MABD','BLPR','CARD','REIP','ENAF', 
                   'CAAF','ABAF','APRC','PLPR','CFEC','APBC','REBC','BSOL','BKGA', 
                   'ARRV','SFOS','LBPS','APCO','EFCO','CACO','ALCO','LCMR','LRCD', 
                   'EXBR','EXBP','PROP','APAF','GEAF','RECC','EXCP','EMAP','ACSA', 
                   'AAPR','ACRM','COIM','ACTF','ACPS','PSUP','MTRA','PAOC','INCT', 
                   'CMIS','CENA','GECO','ESVN','GEST','GGER','GAUD','CRMP','CRMR', 
                   'CDGE','ALAT','ACET','ATPR','CLOT','ADSO','APSG','BLOL','AUDP', 
                   'CPRC','SVOL','PROC','DELI','METC','CONF','LOGS','LOGC','PEOL', 
                   'EXAF','SBTP','ACEP','DPAP','ATLC','PEME','PRVE','PRVC','EEEA',
                   'BLIP','TPED','ALTC','ALTP','ALEE','ALEP','AUPA','ALAF','IINP', 
                   'LIRB','ALOP','CQTD','EXCA','IEIA','COFO','CRAF', 'RRPE'))
/