
/*------ ATD 223990 ------*/
DECLARE v_count NUMBER(1) := 0;
BEGIN
  select 1 into v_count from USER_TAB_COLUMNS where upper(table_name) = 'ITNFSAICOMPLEMENTO' AND upper(column_name) = 'VALORFRETE';
EXCEPTION
  WHEN NO_DATA_FOUND THEN
    EXECUTE IMMEDIATE 'ALTER TABLE ITNFSAICOMPLEMENTO ADD VALORFRETE NUMERIC(15,2)';
END;

DECLARE v_count NUMBER(1) := 0;
BEGIN
  select 1 into v_count from USER_TAB_COLUMNS where upper(table_name) = 'ITNFSAICOMPLEMENTO' AND upper(column_name) = 'VALORDESPINCL';
EXCEPTION
  WHEN NO_DATA_FOUND THEN
    EXECUTE IMMEDIATE 'ALTER TABLE ITNFSAICOMPLEMENTO ADD VALORDESPINCL NUMERIC(15,2)';
END;