
/*------ ATD 283864 ------*/
DECLARE v_count NUMBER:=0;
BEGIN
SELECT Count(1) INTO v_count FROM USER_TAB_COLUMNS WHERE UPPER(table_name) = 'ITEMFILEST' AND Upper(COLUMN_NAME) = 'BLOQUEIAABASTECIMENTO';
IF v_count = 0 THEN
EXECUTE IMMEDIATE 'ALTER TABLE ITEMFILEST ADD BLOQUEIAABASTECIMENTO NUMERIC(1,0) DEFAULT 0 NOT NULL';
END IF;
END;