delete from TCOMPANIATRANSACCIONES where CSUBSISTEMA = '02' and CTRANSACCION = '3055'; delete from TSUBSISTEMATRANSACCIONES where CSUBSISTEMA = '02' and CTRANSACCION = '3055'; delete from TSUBSISTEMATRANSACCIONESID where CSUBSISTEMA = '02' and CTRANSACCION = '3055'; insert into TSUBSISTEMATRANSACCIONESID (CSUBSISTEMA, CTRANSACCION, VERSIONTRANSACCION, ORDENMENU, PRESENTARENMENU, INTERNA, FORMULARIOBASE, AFECTAINMOVILIZACION, CGRUPOTRANSACCION, PRESENTARENREVERSO, CNIVELMENU, LISTAVALOR, USACACHE, SUMACOMPONENTES, PROVISION, COMPLETARRUBROS, LOTEGENERICO, VERIFICANIVELSEGURIDAD, CUSUARIO_INGRESO, FINGRESO, ACUMULACONTADOR, PAGINA, ORIGENDESTINO, CONTROLAEFECTIVO, REQUIEREAUTORIZACION, EJECUTAENAUTORIZACION) values ('02', '3055', '01', 0, '1', '1', '1', '0', null, null, null, '0', '0', '0', '0', '0', null, null, null, null, null, null, null, null, null, '0'); insert into TSUBSISTEMATRANSACCIONES (CIDIOMA, CSUBSISTEMA, CTRANSACCION, VERSIONTRANSACCION, FHASTA, FDESDE, DESCRIPCION, SIGLAS, VERSIONCONTROL) values ('ES', '02', '3055', '01', TIMESTAMP '2999-12-31 00:00:00', TIMESTAMP '2011-11-16 16:17:05', 'MANTENIMIENTO DEL ESTATUS DE LA PERSONA', null, 0); insert into TCOMPANIATRANSACCIONES (CPERSONA_COMPANIA, CSUBSISTEMA, CTRANSACCION, VERSIONTRANSACCION, VERSIONCONTROL) values (2, '02', '3055', '01', 0); commit;