
/*------ ATD 376376 ------*/
-- COLUNA ICMS_MEDIO_SUPORTADO
DECLARE v_count NUMBER(1) := 0;
BEGIN
SELECT 1 INTO v_count FROM USER_TAB_COLUMNS WHERE Upper(table_name) = 'RESSARCIMENTO_ST' AND Upper(column_name) = 'ICMS_MEDIO_SUPORTADO';
EXCEPTION
WHEN NO_DATA_FOUND THEN
EXECUTE IMMEDIATE 'ALTER TABLE RESSARCIMENTO_ST ADD ICMS_MEDIO_SUPORTADO NUMERIC(18,5)';
END;
/
-- COLUNA BASEST_MEDIA
DECLARE v_count NUMBER(1) := 0;
BEGIN
SELECT 1 INTO v_count FROM USER_TAB_COLUMNS WHERE Upper(table_name) = 'RESSARCIMENTO_ST' AND Upper(column_name) = 'BASEST_MEDIA';
EXCEPTION
WHEN NO_DATA_FOUND THEN
EXECUTE IMMEDIATE 'ALTER TABLE RESSARCIMENTO_ST ADD BASEST_MEDIA NUMERIC(18,5)';
END;
