ALTER TABLE ITEMAUTF ADD LISTACDSUBGRPROD VARCHAR2(500) 
/

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

ALTER TABLE ITEMAUTF DROP CONSTRAINT CKC_ITEMAUTF_IDTPGERARUP 
/

ALTER TABLE ITEMAUTF ADD CONSTRAINT CKC_ITEMAUTF_IDTPGERARUP CHECK (IDTPGERARUP IS NULL OR IDTPGERARUP IN ('A','S','T','U', 'P'))
/

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

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 ITEMSOLI DROP CONSTRAINT CKC_ITEMSOLI_IDITEMRUPTURA
/

ALTER TABLE ITEMSOLI ADD CONSTRAINT CKC_ITEMSOLI_IDITEMRUPTURA CHECK (IDITEMRUPTURA IS NULL OR IDITEMRUPTURA IN ('S','N', 'P'))
/