alter table venconceptoval disable constraint CONCEPTO_CONVAL_FK;

alter table venconceptoval disable constraint CONCEPTO_CONVALSAL_FK;

alter table liqcdetalle disable constraint CONCEPTO_LIQCDETALLE_FK;

alter table movimientocaja disable constraint CONCEPTO_MOVTOCAJA_FK;


update concepto set concepto=replace(concepto, 'DEPOSITO','DEP')
where concepto like 'DEPOSITO%';

update venconceptoval set concepto=replace(concepto, 'DEPOSITO','DEP')
where concepto like 'DEPOSITO%';

update venconceptoval set conceptosalida=replace(conceptosalida, 'DEPOSITO','DEP')
where conceptosalida like 'DEPOSITO%';

update liqcdetalle set concepto=replace(concepto, 'DEPOSITO','DEP')
where concepto like 'DEPOSITO%';
update movimientocaja set concepto=replace(concepto, 'DEPOSITO','DEP')
where concepto like 'DEPOSITO%';

select concepto from concepto
where formula like '%DEPOSITO%';

alter table venconceptoval enable constraint CONCEPTO_CONVAL_FK;

alter table venconceptoval enable constraint CONCEPTO_CONVALSAL_FK;

alter table liqcdetalle enable constraint CONCEPTO_LIQCDETALLE_FK;

alter table movimientocaja enable constraint CONCEPTO_MOVTOCAJA_FK;