
/*------ ATD 397249 ------*/
DECLARE v_count NUMBER(1) := 0;   BEGIN   SELECT 1 INTO v_count FROM USER_TAB_COLUMNS WHERE Upper(table_name) = 'FILTROABASTECIMENTO' AND Upper(column_name) = 'FILIAL';   EXCEPTION   WHEN NO_DATA_FOUND THEN   EXECUTE IMMEDIATE 'ALTER TABLE FILTROABASTECIMENTO ADD FILIAL Char(5)';   END;  /  DECLARE v_count NUMBER(1) := 0;   BEGIN   SELECT 1 INTO v_count FROM USER_TAB_COLUMNS WHERE Upper(table_name) = 'SELECAOPRODUTOSABASTECIMENTO' AND Upper(column_name) = 'FILIAL';   EXCEPTION   WHEN NO_DATA_FOUND THEN   EXECUTE IMMEDIATE 'ALTER TABLE SELECAOPRODUTOSABASTECIMENTO ADD FILIAL Char(5)';   END;  /