
INSERT INTO AB3902T00 (CODENTIDAD,TIPO_ENTIDAD,BAJA,DESENTIDAD,CIFNIF,TIPOIDENTIF,CODTH,CODMUN,CP,DIRECCION) VALUES (AB3902Q00.NEXTVAL,1,0,'ARABAKO FORU ALDUNDIA','P0100000I',2,'01','001','01001','PLAZA DE LA PROVINCIA');
INSERT INTO AB3902T00 (CODENTIDAD,TIPO_ENTIDAD,BAJA,DESENTIDAD,CIFNIF,TIPOIDENTIF,CODTH,CODMUN,CP,DIRECCION) VALUES (AB3902Q00.NEXTVAL,1,0,'BIZKAIKO FORU ALDUNDIA','P4800000D',2,'48','013','48013','C-CAPUCHINOS DE BASURTO 2-4');
INSERT INTO AB3902T00 (CODENTIDAD,TIPO_ENTIDAD,BAJA,DESENTIDAD,CIFNIF,TIPOIDENTIF,CODTH,CODMUN,CP,DIRECCION) VALUES (AB3902Q00.NEXTVAL,1,0,'GIPUZKOAKO FORU ALDUNDIA','P2000000F',2,'20','004','20004','PL. GUIPUZCOA S/N');
INSERT INTO AB3902T00 (CODENTIDAD,TIPO_ENTIDAD,BAJA,DESENTIDAD,CIFNIF,TIPOIDENTIF,CODTH,CODMUN,CP,DIRECCION) VALUES (AB3902Q00.NEXTVAL,1,0,'ARABAKO BATZAR NAGUSIAK','P5100002D',2,'01','008','01008','VICENTE GOICOECHEA 2');
INSERT INTO AB3902T00 (CODENTIDAD,TIPO_ENTIDAD,BAJA,DESENTIDAD,CIFNIF,TIPOIDENTIF,CODTH,CODMUN,CP,DIRECCION) VALUES (AB3902Q00.NEXTVAL,1,0,'BIZKAIKO BATZAR NAGUSIAK','S9800001A',2,'48','008','48008','HURTADO DE AMEZAGA 6');

INSERT INTO AB3915T00 (CODENTIDAD,CODTECNICO) VALUES ((SELECT CODENTIDAD FROM AB3902T00 WHERE CIFNIF = 'P0100000I'),(SELECT CODTECNICO FROM AB3901T00 WHERE DOCIDENTIFICACION = '78906093Q' AND ROWNUM = 1));
INSERT INTO AB3915T00 (CODENTIDAD,CODTECNICO) VALUES ((SELECT CODENTIDAD FROM AB3902T00 WHERE CIFNIF = 'P0100000I'),(SELECT CODTECNICO FROM AB3901T00 WHERE DOCIDENTIFICACION = '16060862P' AND ROWNUM = 1));
INSERT INTO AB3915T00 (CODENTIDAD,CODTECNICO) VALUES ((SELECT CODENTIDAD FROM AB3902T00 WHERE CIFNIF = 'P0100000I'),(SELECT CODTECNICO FROM AB3901T00 WHERE DOCIDENTIFICACION = '15953171A' AND ROWNUM = 1));
INSERT INTO AB3915T00 (CODENTIDAD,CODTECNICO) VALUES ((SELECT CODENTIDAD FROM AB3902T00 WHERE CIFNIF = 'P0100000I'),(SELECT CODTECNICO FROM AB3901T00 WHERE DOCIDENTIFICACION = '30625243F' AND ROWNUM = 1));
INSERT INTO AB3915T00 (CODENTIDAD,CODTECNICO) VALUES ((SELECT CODENTIDAD FROM AB3902T00 WHERE CIFNIF = 'P0100000I'),(SELECT CODTECNICO FROM AB3901T00 WHERE DOCIDENTIFICACION = '30600619Q' AND ROWNUM = 1));
INSERT INTO AB3915T00 (CODENTIDAD,CODTECNICO) VALUES ((SELECT CODENTIDAD FROM AB3902T00 WHERE CIFNIF = 'P0100000I'),(SELECT CODTECNICO FROM AB3901T00 WHERE DOCIDENTIFICACION = '15982267G' AND ROWNUM = 1));
INSERT INTO AB3915T00 (CODENTIDAD,CODTECNICO) VALUES ((SELECT CODENTIDAD FROM AB3902T00 WHERE CIFNIF = 'P0100000I'),(SELECT CODTECNICO FROM AB3901T00 WHERE DOCIDENTIFICACION = '15903681D' AND ROWNUM = 1));
INSERT INTO AB3915T00 (CODENTIDAD,CODTECNICO) VALUES ((SELECT CODENTIDAD FROM AB3902T00 WHERE CIFNIF = 'P0100000I'),(SELECT CODTECNICO FROM AB3901T00 WHERE DOCIDENTIFICACION = '16298861A' AND ROWNUM = 1));
INSERT INTO AB3915T00 (CODENTIDAD,CODTECNICO) VALUES ((SELECT CODENTIDAD FROM AB3902T00 WHERE CIFNIF = 'P0100000I'),(SELECT CODTECNICO FROM AB3901T00 WHERE DOCIDENTIFICACION = '16286041V' AND ROWNUM = 1));
INSERT INTO AB3915T00 (CODENTIDAD,CODTECNICO) VALUES ((SELECT CODENTIDAD FROM AB3902T00 WHERE CIFNIF = 'P0100000I'),(SELECT CODTECNICO FROM AB3901T00 WHERE DOCIDENTIFICACION = '72721188H' AND ROWNUM = 1));
INSERT INTO AB3915T00 (CODENTIDAD,CODTECNICO) VALUES ((SELECT CODENTIDAD FROM AB3902T00 WHERE CIFNIF = 'P0100000I'),(SELECT CODTECNICO FROM AB3901T00 WHERE DOCIDENTIFICACION = '78899960R' AND ROWNUM = 1));
INSERT INTO AB3915T00 (CODENTIDAD,CODTECNICO) VALUES ((SELECT CODENTIDAD FROM AB3902T00 WHERE CIFNIF = 'P0100000I'),(SELECT CODTECNICO FROM AB3901T00 WHERE DOCIDENTIFICACION = '15956152V' AND ROWNUM = 1));
INSERT INTO AB3915T00 (CODENTIDAD,CODTECNICO) VALUES ((SELECT CODENTIDAD FROM AB3902T00 WHERE CIFNIF = 'P4800000D'),(SELECT CODTECNICO FROM AB3901T00 WHERE DOCIDENTIFICACION = '78906093Q' AND ROWNUM = 1));
INSERT INTO AB3915T00 (CODENTIDAD,CODTECNICO) VALUES ((SELECT CODENTIDAD FROM AB3902T00 WHERE CIFNIF = 'P4800000D'),(SELECT CODTECNICO FROM AB3901T00 WHERE DOCIDENTIFICACION = '16060862P' AND ROWNUM = 1));
INSERT INTO AB3915T00 (CODENTIDAD,CODTECNICO) VALUES ((SELECT CODENTIDAD FROM AB3902T00 WHERE CIFNIF = 'P4800000D'),(SELECT CODTECNICO FROM AB3901T00 WHERE DOCIDENTIFICACION = '15953171A' AND ROWNUM = 1));
INSERT INTO AB3915T00 (CODENTIDAD,CODTECNICO) VALUES ((SELECT CODENTIDAD FROM AB3902T00 WHERE CIFNIF = 'P4800000D'),(SELECT CODTECNICO FROM AB3901T00 WHERE DOCIDENTIFICACION = '15982267G' AND ROWNUM = 1));
INSERT INTO AB3915T00 (CODENTIDAD,CODTECNICO) VALUES ((SELECT CODENTIDAD FROM AB3902T00 WHERE CIFNIF = 'P4800000D'),(SELECT CODTECNICO FROM AB3901T00 WHERE DOCIDENTIFICACION = '72576110R' AND ROWNUM = 1));
INSERT INTO AB3915T00 (CODENTIDAD,CODTECNICO) VALUES ((SELECT CODENTIDAD FROM AB3902T00 WHERE CIFNIF = 'P4800000D'),(SELECT CODTECNICO FROM AB3901T00 WHERE DOCIDENTIFICACION = '29032576K' AND ROWNUM = 1));
INSERT INTO AB3915T00 (CODENTIDAD,CODTECNICO) VALUES ((SELECT CODENTIDAD FROM AB3902T00 WHERE CIFNIF = 'P4800000D'),(SELECT CODTECNICO FROM AB3901T00 WHERE DOCIDENTIFICACION = '16081005A' AND ROWNUM = 1));
INSERT INTO AB3915T00 (CODENTIDAD,CODTECNICO) VALUES ((SELECT CODENTIDAD FROM AB3902T00 WHERE CIFNIF = 'P4800000D'),(SELECT CODTECNICO FROM AB3901T00 WHERE DOCIDENTIFICACION = '30625243F' AND ROWNUM = 1));
INSERT INTO AB3915T00 (CODENTIDAD,CODTECNICO) VALUES ((SELECT CODENTIDAD FROM AB3902T00 WHERE CIFNIF = 'P2000000F'),(SELECT CODTECNICO FROM AB3901T00 WHERE DOCIDENTIFICACION = '78906093Q' AND ROWNUM = 1));
INSERT INTO AB3915T00 (CODENTIDAD,CODTECNICO) VALUES ((SELECT CODENTIDAD FROM AB3902T00 WHERE CIFNIF = 'P2000000F'),(SELECT CODTECNICO FROM AB3901T00 WHERE DOCIDENTIFICACION = '16060862P' AND ROWNUM = 1));
INSERT INTO AB3915T00 (CODENTIDAD,CODTECNICO) VALUES ((SELECT CODENTIDAD FROM AB3902T00 WHERE CIFNIF = 'P2000000F'),(SELECT CODTECNICO FROM AB3901T00 WHERE DOCIDENTIFICACION = '73219836A' AND ROWNUM = 1));
INSERT INTO AB3915T00 (CODENTIDAD,CODTECNICO) VALUES ((SELECT CODENTIDAD FROM AB3902T00 WHERE CIFNIF = 'P2000000F'),(SELECT CODTECNICO FROM AB3901T00 WHERE DOCIDENTIFICACION = '15953171A' AND ROWNUM = 1));
INSERT INTO AB3915T00 (CODENTIDAD,CODTECNICO) VALUES ((SELECT CODENTIDAD FROM AB3902T00 WHERE CIFNIF = 'P2000000F'),(SELECT CODTECNICO FROM AB3901T00 WHERE DOCIDENTIFICACION = '30625243F' AND ROWNUM = 1));
INSERT INTO AB3915T00 (CODENTIDAD,CODTECNICO) VALUES ((SELECT CODENTIDAD FROM AB3902T00 WHERE CIFNIF = 'P2000000F'),(SELECT CODTECNICO FROM AB3901T00 WHERE DOCIDENTIFICACION = '15982267G' AND ROWNUM = 1));
INSERT INTO AB3915T00 (CODENTIDAD,CODTECNICO) VALUES ((SELECT CODENTIDAD FROM AB3902T00 WHERE CIFNIF = 'P2000000F'),(SELECT CODTECNICO FROM AB3901T00 WHERE DOCIDENTIFICACION = '72435664Q' AND ROWNUM = 1));
INSERT INTO AB3915T00 (CODENTIDAD,CODTECNICO) VALUES ((SELECT CODENTIDAD FROM AB3902T00 WHERE CIFNIF = 'P2000000F'),(SELECT CODTECNICO FROM AB3901T00 WHERE DOCIDENTIFICACION = '15961717Q' AND ROWNUM = 1));
INSERT INTO AB3915T00 (CODENTIDAD,CODTECNICO) VALUES ((SELECT CODENTIDAD FROM AB3902T00 WHERE CIFNIF = 'P2000000F'),(SELECT CODTECNICO FROM AB3901T00 WHERE DOCIDENTIFICACION = '15986728A' AND ROWNUM = 1));
INSERT INTO AB3915T00 (CODENTIDAD,CODTECNICO) VALUES ((SELECT CODENTIDAD FROM AB3902T00 WHERE CIFNIF = 'P2000000F'),(SELECT CODTECNICO FROM AB3901T00 WHERE DOCIDENTIFICACION = '34096930M' AND ROWNUM = 1));
INSERT INTO AB3915T00 (CODENTIDAD,CODTECNICO) VALUES ((SELECT CODENTIDAD FROM AB3902T00 WHERE CIFNIF = 'P2000000F'),(SELECT CODTECNICO FROM AB3901T00 WHERE DOCIDENTIFICACION = '16081005A' AND ROWNUM = 1));
INSERT INTO AB3915T00 (CODENTIDAD,CODTECNICO) VALUES ((SELECT CODENTIDAD FROM AB3902T00 WHERE CIFNIF = 'P2000000F'),(SELECT CODTECNICO FROM AB3901T00 WHERE DOCIDENTIFICACION = '15944952H' AND ROWNUM = 1));
INSERT INTO AB3915T00 (CODENTIDAD,CODTECNICO) VALUES ((SELECT CODENTIDAD FROM AB3902T00 WHERE CIFNIF = 'P5100002D'),(SELECT CODTECNICO FROM AB3901T00 WHERE DOCIDENTIFICACION = '78906093Q' AND ROWNUM = 1));
INSERT INTO AB3915T00 (CODENTIDAD,CODTECNICO) VALUES ((SELECT CODENTIDAD FROM AB3902T00 WHERE CIFNIF = 'P5100002D'),(SELECT CODTECNICO FROM AB3901T00 WHERE DOCIDENTIFICACION = '16060862P' AND ROWNUM = 1));
INSERT INTO AB3915T00 (CODENTIDAD,CODTECNICO) VALUES ((SELECT CODENTIDAD FROM AB3902T00 WHERE CIFNIF = 'P5100002D'),(SELECT CODTECNICO FROM AB3901T00 WHERE DOCIDENTIFICACION = '15953171A' AND ROWNUM = 1));
INSERT INTO AB3915T00 (CODENTIDAD,CODTECNICO) VALUES ((SELECT CODENTIDAD FROM AB3902T00 WHERE CIFNIF = 'P5100002D'),(SELECT CODTECNICO FROM AB3901T00 WHERE DOCIDENTIFICACION = '15982267G' AND ROWNUM = 1));
INSERT INTO AB3915T00 (CODENTIDAD,CODTECNICO) VALUES ((SELECT CODENTIDAD FROM AB3902T00 WHERE CIFNIF = 'P5100002D'),(SELECT CODTECNICO FROM AB3901T00 WHERE DOCIDENTIFICACION = '30625243F' AND ROWNUM = 1));
INSERT INTO AB3915T00 (CODENTIDAD,CODTECNICO) VALUES ((SELECT CODENTIDAD FROM AB3902T00 WHERE CIFNIF = 'P5100002D'),(SELECT CODTECNICO FROM AB3901T00 WHERE DOCIDENTIFICACION = '78899960R' AND ROWNUM = 1));
INSERT INTO AB3915T00 (CODENTIDAD,CODTECNICO) VALUES ((SELECT CODENTIDAD FROM AB3902T00 WHERE CIFNIF = 'P5100002D'),(SELECT CODTECNICO FROM AB3901T00 WHERE DOCIDENTIFICACION = '16265638S' AND ROWNUM = 1));
INSERT INTO AB3915T00 (CODENTIDAD,CODTECNICO) VALUES ((SELECT CODENTIDAD FROM AB3902T00 WHERE CIFNIF = 'S9800001A'),(SELECT CODTECNICO FROM AB3901T00 WHERE DOCIDENTIFICACION = '78906093Q' AND ROWNUM = 1));
INSERT INTO AB3915T00 (CODENTIDAD,CODTECNICO) VALUES ((SELECT CODENTIDAD FROM AB3902T00 WHERE CIFNIF = 'S9800001A'),(SELECT CODTECNICO FROM AB3901T00 WHERE DOCIDENTIFICACION = '16060862P' AND ROWNUM = 1));
INSERT INTO AB3915T00 (CODENTIDAD,CODTECNICO) VALUES ((SELECT CODENTIDAD FROM AB3902T00 WHERE CIFNIF = 'S9800001A'),(SELECT CODTECNICO FROM AB3901T00 WHERE DOCIDENTIFICACION = '15953171A' AND ROWNUM = 1));
INSERT INTO AB3915T00 (CODENTIDAD,CODTECNICO) VALUES ((SELECT CODENTIDAD FROM AB3902T00 WHERE CIFNIF = 'S9800001A'),(SELECT CODTECNICO FROM AB3901T00 WHERE DOCIDENTIFICACION = '15982267G' AND ROWNUM = 1));
INSERT INTO AB3915T00 (CODENTIDAD,CODTECNICO) VALUES ((SELECT CODENTIDAD FROM AB3902T00 WHERE CIFNIF = 'S9800001A'),(SELECT CODTECNICO FROM AB3901T00 WHERE DOCIDENTIFICACION = '30625243F' AND ROWNUM = 1));
INSERT INTO AB3915T00 (CODENTIDAD,CODTECNICO) VALUES ((SELECT CODENTIDAD FROM AB3902T00 WHERE CIFNIF = 'S9800001A'),(SELECT CODTECNICO FROM AB3901T00 WHERE DOCIDENTIFICACION = '16081005A' AND ROWNUM = 1));
INSERT INTO AB3915T00 (CODENTIDAD,CODTECNICO) VALUES ((SELECT CODENTIDAD FROM AB3902T00 WHERE CIFNIF = 'S9800001A'),(SELECT CODTECNICO FROM AB3901T00 WHERE DOCIDENTIFICACION = '30562583E' AND ROWNUM = 1));

commit;

exit;