ALTER TABLE PR340_FR79_EXPLUATATION DISABLE CONSTRAINT PR340_FR79_EX_FK_PARENT;
TRUNCATE TABLE PR340_FR79_EXPLUATATION;
TRUNCATE TABLE PR340_FR79;
TRUNCATE TABLE POE_VOLS;



INSERT INTO POE_VOLS (
ID, VID, CODE, NAME, START_DATE, END_DATE, IS_ACTUAL, CHANGE_TYPE, CONFIRM_USER_ID, COMMENT_REJECT, COMMENTS_ANALYSTS,
  CREATE_USER_ID, CREATE_DATE, CABLE_TYPE_VOLS_ID, CIRCUIT_OPERATION_VOLS_ID, YEAR_INPUT, MARK_OF_WIRE_VL_CL_ID, POE_VL_VID,
  ENDING_VOLS, LENGTH, BEGINNING_VOLS)
  VALUES (
  1001, 1234567801,1001, 'Волс 1',TO_DATE('01-09-12', 'DD-MM-YY'),TO_DATE('21-09-12', 'DD-MM-YY'),1, 'I', 889313, NULL, NULL,
  889313,TO_DATE('01-12-15', 'DD-MM-YY'), 50, 2, 2013, 983, 1000800699, 'Волс энд1',111, 'Волс бэг1'
  );

INSERT INTO POE_VOLS (  ID, VID, CODE, NAME, START_DATE, END_DATE, IS_ACTUAL, CHANGE_TYPE, CONFIRM_USER_ID, COMMENT_REJECT, COMMENTS_ANALYSTS,  CREATE_USER_ID, CREATE_DATE, CABLE_TYPE_VOLS_ID, CIRCUIT_OPERATION_VOLS_ID, YEAR_INPUT, MARK_OF_WIRE_VL_CL_ID, POE_VL_VID,  ENDING_VOLS, LENGTH, BEGINNING_VOLS)
VALUES (
  1002, 1234567802,1002, 'Волс 2',TO_DATE('01-09-12', 'DD-MM-YY'),TO_DATE('21-09-12', 'DD-MM-YY'),1, 'I', 889313, NULL, NULL,
  889313,TO_DATE('01-12-15', 'DD-MM-YY'), 50, 2, 2013, 983, 1000800699, 'Волс энд1',111, 'Волс бэг1'
);
INSERT INTO POE_VOLS (  ID, VID, CODE, NAME, START_DATE, END_DATE, IS_ACTUAL, CHANGE_TYPE, CONFIRM_USER_ID, COMMENT_REJECT, COMMENTS_ANALYSTS,  CREATE_USER_ID, CREATE_DATE, CABLE_TYPE_VOLS_ID, CIRCUIT_OPERATION_VOLS_ID, YEAR_INPUT, MARK_OF_WIRE_VL_CL_ID, POE_VL_VID,  ENDING_VOLS, LENGTH, BEGINNING_VOLS)
VALUES (
  1003, 1234567803,1003, 'Волс 3',TO_DATE('01-09-12', 'DD-MM-YY'),TO_DATE('21-09-12', 'DD-MM-YY'),1, 'I', 889313, NULL, NULL,
  889313,TO_DATE('01-12-15', 'DD-MM-YY'), 50, 2, 2013, 983, 1000800699, 'Волс энд1',111, 'Волс бэг1'
);
INSERT INTO POE_VOLS (  ID, VID, CODE, NAME, START_DATE, END_DATE, IS_ACTUAL, CHANGE_TYPE, CONFIRM_USER_ID, COMMENT_REJECT, COMMENTS_ANALYSTS,  CREATE_USER_ID, CREATE_DATE, CABLE_TYPE_VOLS_ID, CIRCUIT_OPERATION_VOLS_ID, YEAR_INPUT, MARK_OF_WIRE_VL_CL_ID, POE_VL_VID,  ENDING_VOLS, LENGTH, BEGINNING_VOLS)
VALUES (
  1004, 1234567804,1004, 'Волс 4',TO_DATE('01-09-12', 'DD-MM-YY'),TO_DATE('21-09-12', 'DD-MM-YY'),1, 'I', 889313, NULL, NULL,
  889313,TO_DATE('01-12-15', 'DD-MM-YY'), 50, 2, 2013, 983, 1000800699, 'Волс энд1',111, 'Волс бэг1'
);
INSERT INTO POE_VOLS (  ID, VID, CODE, NAME, START_DATE, END_DATE, IS_ACTUAL, CHANGE_TYPE, CONFIRM_USER_ID, COMMENT_REJECT, COMMENTS_ANALYSTS,  CREATE_USER_ID, CREATE_DATE, CABLE_TYPE_VOLS_ID, CIRCUIT_OPERATION_VOLS_ID, YEAR_INPUT, MARK_OF_WIRE_VL_CL_ID, POE_VL_VID,  ENDING_VOLS, LENGTH, BEGINNING_VOLS)
VALUES (
  1005, 1234567805,1005, 'Волс 5',TO_DATE('01-09-12', 'DD-MM-YY'),TO_DATE('21-09-12', 'DD-MM-YY'),1, 'I', 889313, NULL, NULL,
  889313,TO_DATE('01-12-15', 'DD-MM-YY'), 50, 2, 2013, 983, 1000800699, 'Волс энд1',111, 'Волс бэг1'
);
INSERT INTO POE_VOLS (  ID, VID, CODE, NAME, START_DATE, END_DATE, IS_ACTUAL, CHANGE_TYPE, CONFIRM_USER_ID, COMMENT_REJECT, COMMENTS_ANALYSTS,  CREATE_USER_ID, CREATE_DATE, CABLE_TYPE_VOLS_ID, CIRCUIT_OPERATION_VOLS_ID, YEAR_INPUT, MARK_OF_WIRE_VL_CL_ID, POE_VL_VID,  ENDING_VOLS, LENGTH, BEGINNING_VOLS)
VALUES (
  1006, 1234567806,1006, 'Волс 6',TO_DATE('01-09-12', 'DD-MM-YY'),TO_DATE('21-09-12', 'DD-MM-YY'),1, 'I', 889313, NULL, NULL,
  889313,TO_DATE('01-12-15', 'DD-MM-YY'), 50, 2, 2013, 983, 1000800699, 'Волс энд1',111, 'Волс бэг1'
);
INSERT INTO POE_VOLS (  ID, VID, CODE, NAME, START_DATE, END_DATE, IS_ACTUAL, CHANGE_TYPE, CONFIRM_USER_ID, COMMENT_REJECT, COMMENTS_ANALYSTS,  CREATE_USER_ID, CREATE_DATE, CABLE_TYPE_VOLS_ID, CIRCUIT_OPERATION_VOLS_ID, YEAR_INPUT, MARK_OF_WIRE_VL_CL_ID, POE_VL_VID,  ENDING_VOLS, LENGTH, BEGINNING_VOLS)
VALUES (
  1007, 1234567807,1007, 'Волс 7',TO_DATE('01-09-12', 'DD-MM-YY'),TO_DATE('21-09-12', 'DD-MM-YY'),1, 'I', 889313, NULL, NULL,
  889313,TO_DATE('01-12-15', 'DD-MM-YY'), 50, 2, 2013, 983, 1000800699, 'Волс энд1',111, 'Волс бэг1'
);


INSERT INTO PR340_FR79 ( ID, DRAFT_USER_ID, POWER_FACILITIES_ID, STATUS, FORMS_ID, CREATE_USER_ID, POE_VOLS_VID)
VALUES (
  541, 889313, 108104, 1, 23659, 889313, 1234567801
);
INSERT INTO PR340_FR79 ( ID, DRAFT_USER_ID, POWER_FACILITIES_ID, STATUS, FORMS_ID, CREATE_USER_ID, POE_VOLS_VID)
VALUES (
  542, 889313, 108104, 1, 23659, 889313, 1234567802
);
INSERT INTO PR340_FR79 ( ID, DRAFT_USER_ID, POWER_FACILITIES_ID, STATUS, FORMS_ID, CREATE_USER_ID, POE_VOLS_VID)
VALUES (
  543, 889313, 108104, 1, 23659, 889313, 1234567803
);
INSERT INTO PR340_FR79 ( ID, DRAFT_USER_ID, POWER_FACILITIES_ID, STATUS, FORMS_ID, CREATE_USER_ID, POE_VOLS_VID)
VALUES (
  544, 889313, 108104, 1, 23659, 889313, 1234567804
);
INSERT INTO PR340_FR79 ( ID, DRAFT_USER_ID, POWER_FACILITIES_ID, STATUS, FORMS_ID, CREATE_USER_ID, POE_VOLS_VID)
VALUES (
  545, 889313, 108104, 1, 23659, 889313, 1234567805
);
INSERT INTO PR340_FR79 ( ID, DRAFT_USER_ID, POWER_FACILITIES_ID, STATUS, FORMS_ID, CREATE_USER_ID, POE_VOLS_VID)
VALUES (
  546, 889313, 108104, 1, 23659, 889313, 1234567806
);


INSERT INTO PR340_FR79_EXPLUATATION (ID,NAME_MAINTENANCE_TOOL, MARK, COMMISSION_YEAR, PR340_FR79_ID, CERTIFIED, AMORTIZATION_PERIOD, DATE_LAST_MAINTENANCE, DATE_NEXT_MAINTENANCE)
  VALUES (1,'Cредство обслуживания 1','Марка 1', 1999, 541, 1, 20,TO_DATE('01-09-10', 'DD-MM-YY'),TO_DATE('01-09-11', 'DD-MM-YY') );
INSERT INTO PR340_FR79_EXPLUATATION (ID,NAME_MAINTENANCE_TOOL, MARK, COMMISSION_YEAR, PR340_FR79_ID, CERTIFIED, AMORTIZATION_PERIOD, DATE_LAST_MAINTENANCE, DATE_NEXT_MAINTENANCE)
VALUES (2,'Cредство обслуживания 2','Марка 2', 2000, 542, 1, 21,TO_DATE('01-09-10', 'DD-MM-YY'),TO_DATE('01-09-11', 'DD-MM-YY') );
INSERT INTO PR340_FR79_EXPLUATATION (ID,NAME_MAINTENANCE_TOOL, MARK, COMMISSION_YEAR, PR340_FR79_ID, CERTIFIED, AMORTIZATION_PERIOD, DATE_LAST_MAINTENANCE, DATE_NEXT_MAINTENANCE)
VALUES (3,'Cредство обслуживания 3','Марка 3', 2001, 543, 1, 22,TO_DATE('01-09-10', 'DD-MM-YY'),TO_DATE('01-09-11', 'DD-MM-YY') );
INSERT INTO PR340_FR79_EXPLUATATION (ID,NAME_MAINTENANCE_TOOL, MARK, COMMISSION_YEAR, PR340_FR79_ID, CERTIFIED, AMORTIZATION_PERIOD, DATE_LAST_MAINTENANCE, DATE_NEXT_MAINTENANCE)
VALUES (4,'Cредство обслуживания 4','Марка 4', 2002, 544, 1, 23,TO_DATE('01-09-10', 'DD-MM-YY'),TO_DATE('01-09-11', 'DD-MM-YY') );
INSERT INTO PR340_FR79_EXPLUATATION (ID,NAME_MAINTENANCE_TOOL, MARK, COMMISSION_YEAR, PR340_FR79_ID, CERTIFIED, AMORTIZATION_PERIOD, DATE_LAST_MAINTENANCE, DATE_NEXT_MAINTENANCE)
VALUES (5,'Cредство обслуживания 5','Марка 5', 2003, 545, 1, 24,TO_DATE('01-09-10', 'DD-MM-YY'),TO_DATE('01-09-11', 'DD-MM-YY') );




ALTER TABLE PR340_FR79_EXPLUATATION ENABLE CONSTRAINT PR340_FR79_EX_FK_PARENT;