-------------------------------------------------------------------------------------------------------------------------------------------------
--            insert testatussolicitud 004(mantenimiento),005(anulado)
-------------------------------------------------------------------------------------------------------------------------------------------------
DELETE FROM TESTATUSSOLICITUD WHERE CSUBSISTEMA='06' AND CESTATUSSOLICITUD IN('004','005') AND FHASTA=FNCFHASTA;
DELETE FROM TESTATUSSOLICITUDID WHERE CSUBSISTEMA='06' AND CESTATUSSOLICITUD in ('004','005');
INSERT INTO TESTATUSSOLICITUDID (CSUBSISTEMA, CESTATUSSOLICITUD, COMANDO, TIPOCOMANDO) VALUES ('06', '004', null, null);
INSERT INTO TESTATUSSOLICITUDID (CSUBSISTEMA, CESTATUSSOLICITUD, COMANDO, TIPOCOMANDO) VALUES ('06', '005', null, null);
INSERT INTO TESTATUSSOLICITUD (CIDIOMA, CSUBSISTEMA, CESTATUSSOLICITUD, FHASTA, FDESDE, DESCRIPCION, VERSIONCONTROL) VALUES ('ES', '06', '004', TIMESTAMP '2999-12-31 00:00:00', TIMESTAMP '2014-11-13 00:00:00', 'MANTENIMIENTO', 0);
INSERT INTO TESTATUSSOLICITUD (CIDIOMA, CSUBSISTEMA, CESTATUSSOLICITUD, FHASTA, FDESDE, DESCRIPCION, VERSIONCONTROL) VALUES ('ES', '06', '005', TIMESTAMP '2999-12-31 00:00:00', TIMESTAMP '2014-11-13 00:00:00', 'ANULADA', 0);