
/*------ ATD 407429 ------*/
DECLARE v_count NUMBER(1):=0;
BEGIN
SELECT count(*) INTO v_count FROM USER_TAB_COLUMNS WHERE table_name = 'ITEMFATURADO' AND column_name = 'DESTINOROTEIRIZADOR';
IF v_count<=0 then
EXECUTE IMMEDIATE 'ALTER TABLE ITEMFATURADO ADD DESTINOROTEIRIZADOR VARCHAR2(254) NULL';
END IF;
END;
/