Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- home poi inserts
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Allman Brent');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'AMARA-KORBA Anwer');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Anderson Michael');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Bader-Jones Mark');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Bain William');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Baker Keith');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Christian Linda');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Barnes Simon');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Barrow Kenny');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Barton Tom');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Barzev Georgi');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Bjelanovic Bojan');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Boland Lewis');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Bouchadour Hassan');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Bowman Paul');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Boynton Carl');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Bremner Adam');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Buckley Christopher');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Lumsden Jack');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Budek Artur');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Bushell Nick');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Carroll Elliot');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Chaney Lewis');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Chrisholme Leigh');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Christopher Mason');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Clark Jason');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Coblenz Eddie');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Coulson Josh');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Crowe Matthew');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Dall John');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Davis Gareth');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Dawidziuk Pawel');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Deighton Barry');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Dixon Robert');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Dobson Glen');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Donald Billy (william)');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Donaldson John');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Douglas Ian');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Drouen Niels');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Drury Michael');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Pauley Raymond');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Edwards Lotti');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'McAvoy Mark');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Egan Andrew');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'El Maachi Rachid');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Ellis Chraig');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Fachnie Kenny');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Fadinger Daniel');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Farahbakhsh Soheil');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Fiedler Daniel');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Fleming Lewis');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Gallagher Joseph');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Giacomuzzi Sergio');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Gilles Andrej');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Glancy J.A.');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Golubic Tomislav');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Gott Tim');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Grainger Stuart');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Gray Barrie');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Greenwood John');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Hannant James');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Hare Darryl');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Harll Peter');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Hart Paul');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Hartland John');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Harvey Paul');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Hercigonja-Starcevic Josip');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Holt Jonathan');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Hopkins Richard');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Hubbard Adrian');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Jackson Andrew');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Johnson Lewis');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Jones Charlie');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Jones Clive');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Jones Kevin');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Julian Brooker');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Kalicharan Astrid');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Kay Peter');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Kazula Krystian');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Kazula Tomasz');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Kevill Adrian');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Knauerhase juergen');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Knight Ben');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Kowal tomasz');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Kusnierz Wojciech');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Lee John');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Lew Slawomir');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Little Mark');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Little William');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Macphee Kevin');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Marin Danko');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Mason Christopher');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'McAulay Scott');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'McAulay Bernard');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'McClure John');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'McCormick William');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'McGlinchey Mark');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'McGuire Martin');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'McIntosh Richard');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'McLaughlin Alan');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'McLeod Gregg');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'McLeod Scott');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'McLeod mark');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Miller Billy');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Miniero Anthony');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Mitchell Barry');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Moon Paul');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Mowat Andrew');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Muir Graeme');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Munro David');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Nderi Del');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Nes David');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Nixon Phili');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Owen Gavin');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Parsonage Mark');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Pennock kevin');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Persoons Gustaaf');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Philips Nathan');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Plant Gary');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Poeschel Falk');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Prentice David');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Prokop Rafal');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Prokop Andrzej');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Read Jordan');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Roberts Shaun');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Robinson Andrew');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Robinson Andy');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Hickingbotham Dale');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Fenwick Stephen');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Rose Ben');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Ross Avril');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Rowan Michael');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Rozak Les');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Rumis Dave');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Ryan Jason');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Sarkar Abhishek');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Shepley Anthony');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Shepley William');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Sims Chris');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Sinclair Krik');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Slater Steven');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Smith Sean');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Smith Scott');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Smith Garry');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Springbett Sam');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Stavru Marius');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Stuart Stephen');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Swainston Richard');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Swanson James');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Szafulski Dariusz');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Tait Andrew');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Tevenan Denis');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Thomas David');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Thompson John');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Tomczyk Stanislaw');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Toth Benny');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Ulley Andrew');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Underhill Ian');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Van Rhijn Jorrit');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Vandenbulcke Mathias');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Virk Steven');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Walker Daniel');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Weatherill Jamie');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Weltevreden Mirjam');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Wilkinson Paul');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Williams Neil');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Williamson Mark');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Williamson John');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Hipperson Paul');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Wilson Matthew');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Wisby Mel');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Wright John');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Wright Wayne');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Wykman Martin');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Wynne Keith');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Yontucu Gokce');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Young Chris');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Yusof Fairuz');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'Zarusinski Max');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'CHAVDAROV Toma');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'MUDRA Mihaly');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'GERE Lajos');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'HAJDU Janos');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'KULCSAR Gergo');
- INSERT INTO oc_poi (poi_id, oc_poi_category_id, snapping_circle, lm_date, lm_comment, lm_name, oc_poi_status_id, name) VALUES (seq_oc_poi_id.NEXTVAL, 102013, 200, SYSDATE, 'Siemens load 2020', 'PSI', 0,'ZENTAI Peter');
- COMMIT;
- -- person inserts
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Brent','Allman',104954,'','Grosvenor','',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Allman Brent' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Anwer','AMARA-KORBA',104954,'GB47 9985 260','Siemens UK','58.43.22-161.19',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='AMARA-KORBA Anwer' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Michael','Anderson',104954,'','Turner Lovell','',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Anderson Michael' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Mark','Bader-Jones',104954,'','Vital','',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Bader-Jones Mark' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'William','Bain',104954,'','Grosvenor','',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Bain William' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Keith','Baker',104954,'GB47 9985 260','Siemens','63.44.02-135.78',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Baker Keith' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Linda','Christian',104954,'','Turner Lovell','',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Christian Linda' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Simon','Barnes',104954,'GB47 9985 260','Siemens UK','85.50.07-389.81',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Barnes Simon' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Kenny','Barrow',104954,'GB29 0665 382','Triton Knoll','70.49.16-217.49',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Barrow Kenny' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Tom','Barton',104954,'','Grosvenor','',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Barton Tom' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Georgi','Barzev',104954,'','Vysiion','',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Barzev Georgi' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Bojan','Bjelanovic',104954,'GB16 7135 309','Siemens','78.44.18-401.35',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Bjelanovic Bojan' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Lewis','Boland',104954,'','Volker Infra','',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Boland Lewis' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Hassan','Bouchadour',104954,'NL00 2465 077B 26','Harvey Nash','86.46.16-447.37',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Bouchadour Hassan' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Paul','Bowman',104954,'GB68 7768 062','Wardpower','60.49.23_237.94',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Bowman Paul' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Carl','Boynton',104954,'GB29 1902 688','Siemens UK','84.41.07-365.21',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Boynton Carl' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Adam','Bremner',104954,'GB29 7287 108','JGC','97.45.03-145.80',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Bremner Adam' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Christopher','Buckley',104954,'GB91 8490 403','Triton Knoll','56.50.19-107.73',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Buckley Christopher' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Jack','Lumsden',104954,'','Volker Infra','',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Lumsden Jack' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Artur','Budek',104954,'','Vital','',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Budek Artur' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Nick','Bushell',104954,'GB31 9924 968','siemens','88.49.23-407.27',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Bushell Nick' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Elliot','Carroll',104954,'GB16 6495 569','Grosvenor','76.51.29-195.15',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Carroll Elliot' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Lewis','Chaney',104954,'','Turner Lovell','',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Chaney Lewis' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Leigh','Chrisholme',104954,'GB16 6495 569','4k enterprise Ltd','76.51.29-195.15',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Chrisholme Leigh' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Mason','Christopher',104954,'GB47 9985 260','Siemens Metering','62.52.13-237.69',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Christopher Mason' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Jason','Clark',104954,'GB47 9985 260','Siemens','97.48.03-151.95',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Clark Jason' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Eddie','Coblenz',104954,'GB47 9985 260','Siemens','78.51.07-135.01',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Coblenz Eddie' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Josh','Coulson',104954,'','Grosvenor','',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Coulson Josh' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Matthew','Crowe',104954,'','Vital','',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Crowe Matthew' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'John','Dall',104954,'','Vital','',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Dall John' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Gareth','Davis',104954,'','Vysiion','',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Davis Gareth' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Pawel','Dawidziuk',104954,'GB47 9985 260','Siemens UK','83.45.17-445.36',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Dawidziuk Pawel' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Barry','Deighton',104954,'','Grosvenor','',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Deighton Barry' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Robert','Dixon',104954,'','Turner Lovell','',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Dixon Robert' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Glen','Dobson',104954,'','Volker Infra','',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Dobson Glen' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Billy (william)','Donald',104954,'','Vital','',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Donald Billy (william)' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'John','Donaldson',104954,'','Turner Lovell','',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Donaldson John' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Ian','Douglas',104954,'','Grosvenor','',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Douglas Ian' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Niels','Drouen',104954,'NL00 1920 509B 01','Boskalis (Client)','90.52.28-339.08',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Drouen Niels' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Michael','Drury',104954,'','Turner Lovell','',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Drury Michael' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Raymond','Pauley',104954,'','Volker Infra','',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Pauley Raymond' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Lotti','Edwards',104954,'','Siemens UK','',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Edwards Lotti' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Mark','McAvoy',104954,'','Volker Infra','',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='McAvoy Mark' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Andrew','Egan',104954,'','Grosvenor','',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Egan Andrew' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Rachid','El Maachi',104954,'NL23 8235 336B 01','Harvey Nash','77.49.16-403.10',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='El Maachi Rachid' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Chraig','Ellis',104954,'GB47 9985 260','Siemens UK','80.51.01-365.90',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Ellis Chraig' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Kenny','Fachnie',104954,'','Grosvenor','',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Fachnie Kenny' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Daniel','Fadinger',104954,'ATU1 4715 405','Siemens','96.46.18-201.45',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Fadinger Daniel' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Soheil','Farahbakhsh',104954,'','Siemens (visitor)','',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Farahbakhsh Soheil' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Daniel','Fiedler',104954,'ATU1 4715 405','Siemens','92.43.13-307.81',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Fiedler Daniel' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Lewis','Fleming',104954,'','Volker Infra','',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Fleming Lewis' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Joseph','Gallagher',104954,'36311','Triton Knoll','83.51.17-207.25',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Gallagher Joseph' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Sergio','Giacomuzzi',104954,'','Moser Glaser','',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Giacomuzzi Sergio' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Andrej','Gilles',104954,'DE32 5998 031','Siemens GE','88.51.13-211.52',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Gilles Andrej' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'J.A.','Glancy',104954,'GB47 9985 260','Siemens Metering','62.44.14-217.03',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Glancy J.A.' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Tomislav','Golubic',104954,'HR62 4711 9246 6','ETDS','82.48.27-455.17',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Golubic Tomislav' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Tim','Gott',104954,'GB65 1711 651','Tellemachus','69.49.29-305.35',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Gott Tim' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Stuart','Grainger',104954,'','Vital','',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Grainger Stuart' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Barrie','Gray',104954,'','Turner Lovell','',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Gray Barrie' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'John','Greenwood',104954,'GB47 9985 260','Siemens Metering','78.48.24-391.87',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Greenwood John' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'James','Hannant',104954,'GB47 9985 260','Siemens Metering','82.52.31-343.37',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Hannant James' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Darryl','Hare',104954,'GB13 9869 944','NSV','89.45.10-415.14',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Hare Darryl' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Peter','Harll',104954,'','Burdock','',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Harll Peter' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Paul','Hart',104954,'','Volker Infra','',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Hart Paul' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'John','Hartland',104954,'','Turner Lovell','',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Hartland John' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Paul','Harvey',104954,'','Vysiion','',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Harvey Paul' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Josip','Hercigonja-Starcevic',104954,'HR36 2555 4147 6','ETDS','68.48.08-351.09',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Hercigonja-Starcevic Josip' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Jonathan','Holt',104954,'','Grosvenor','',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Holt Jonathan' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Richard','Hopkins',104954,'','Vysiion','',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Hopkins Richard' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Adrian','Hubbard',104954,'GB68 7768 062','Wardpower','65.50.07-217.27',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Hubbard Adrian' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Andrew','Jackson',104954,'GB13 9869 944','NSV','85.41.15-429.29',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Jackson Andrew' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Lewis','Johnson',104954,'GB47 9985 260','Siemens','97.43.29-139.68',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Johnson Lewis' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Charlie','Jones',104954,'39173','Volker Infra','98.46.24-149.56',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Jones Charlie' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Clive','Jones',104954,'GB42 4894 330','Volker Infra','60.41.14-219.35',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Jones Clive' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Kevin','Jones',104954,'GB42 4894 330','Volker Infra','82.43.20-395.58',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Jones Kevin' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Brooker','Julian',104954,'GB47 9985 260','Siemens UK','72.52.14-285.07',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Julian Brooker' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Astrid','Kalicharan',104954,'NL85 9479 602B 01','Siemens','67.47.05-086.45',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Kalicharan Astrid' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Peter','Kay',104954,'GB33 8521 555','Grosvenor','69.52.19-115.61',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Kay Peter' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Krystian','Kazula',104954,'GB47 9985 260','Vital','95.42.07-185.51',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Kazula Krystian' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Tomasz','Kazula',104954,'GB47 9985 260','Vital','72.45.27-133.11',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Kazula Tomasz' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Adrian','Kevill',104954,'GB32 1116 852','Vital','70.41.26-715.68',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Kevill Adrian' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'juergen','Knauerhase',104954,'CHE1 0524 4053','Moser Glaser','61.45.14-175.31',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Knauerhase juergen' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Ben','Knight',104954,'GB13 5555 706','Dalepowersolutions','93.47.08-207.89',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Knight Ben' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'tomasz','Kowal',104954,'44218','Vital','69.43.27-133.31',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Kowal tomasz' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Wojciech','Kusnierz',104954,'GB47 9985 260','Vital','70.41.26-395.97',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Kusnierz Wojciech' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'John','Lee',104954,'GB89 5216 886','Siemens','69.51.16-115.47',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Lee John' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Slawomir','Lew',104954,'50222','Vital','68.42.11-323.02',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Lew Slawomir' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Mark','Little',104954,'GB26 3186 357','Vital','89.50.11-357.77',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Little Mark' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'William','Little',104954,'GB47 9985 260','Siemens','61.48.26-229.26',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Little William' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Kevin','Macphee',104954,'GB47 9985 260','Siemens UK','78.46.22-363.64',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Macphee Kevin' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Danko','Marin',104954,'41537','Vital','84.47.05-389.02',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Marin Danko' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Christopher','Mason',104954,'GB47 9985 260','Siemens Metering','62.52.13-237.69',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Mason Christopher' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Scott','McAulay',104954,'GB23 0584 327','Vital','87.44.08-411.29',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='McAulay Scott' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Bernard','McAulay',104954,'52238','Vital','53.42.23-125.10',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='McAulay Bernard' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'John','McClure',104954,'','Siemens GE','',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='McClure John' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'William','McCormick',104954,'','Turner Lovell','',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='McCormick William' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Mark','McGlinchey',104954,'GB73 0757 237','Volker Infra','77.49.15-405.38',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='McGlinchey Mark' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Martin','McGuire',104954,'50067','Vital','69.50.24-363.37',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='McGuire Martin' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Richard','McIntosh',104954,'GB63 8895 377','Grosvenor','85.52.30-363.13',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='McIntosh Richard' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Alan','McLaughlin',104954,'GB10 9408 719','Grosvenor','69.41.29-381.97',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='McLaughlin Alan' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Gregg','McLeod',104954,'GB33 8521 555','Grosvenor','77.51.22-383.58',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='McLeod Gregg' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Scott','McLeod',104954,'GB47 9985 260','Siemens CIS','83.52.10-371.78',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='McLeod Scott' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'mark','McLeod',104954,'GB33 8521 555','Grosvenor','89.49.24-311.17',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='McLeod mark' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Billy','Miller',104954,'GB17 1654 210','Siemens','66.51.02-279.46',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Miller Billy' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Anthony','Miniero',104954,'GB18 0773 394','Amtec power solutions','86.50.29-133.86',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Miniero Anthony' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Barry','Mitchell',104954,'GB22 2438 292','Siemens CIS','85.49.27-431.14',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Mitchell Barry' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Paul','Moon',104954,'GB33 8521 555','Grosvenor','80.42.16-413.14',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Moon Paul' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Andrew','Mowat',104954,'GB29 7287 108','JGC','66.45.08-279.18',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Mowat Andrew' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Graeme','Muir',104954,'','Turner Lovell','',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Muir Graeme' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'David','Munro',104954,'56175','Siemens CIS','81.50.03-473.33',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Munro David' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Del','Nderi',104954,'GB47 9985 260','','94.50.26-205.78',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Nderi Del' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'David','Nes',104954,'','Turner Lovell','',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Nes David' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Phili','Nixon',104954,'','Vital','',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Nixon Phili' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Gavin','Owen',104954,'GB42 4894 330','Volker Infra','69.41.29-393.85',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Owen Gavin' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Mark','Parsonage',104954,'GB63 8895 377','Grosvenor','75.49.04-337.06',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Parsonage Mark' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'kevin','Pennock',104954,'GB13 5555 706','Dalepowersolutions','64.47.13-255.58',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Pennock kevin' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Gustaaf','Persoons',104954,'','Burdock','',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Persoons Gustaaf' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Nathan','Philips',104954,'GB42 4894 330','Volker Infra','82.49.30-457.29',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Philips Nathan' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Gary','Plant',104954,'39715','Vysiion','68.43.01-437.01',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Plant Gary' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Falk','Poeschel',104954,'DE12 9274 202','Siemens','71.46.03-065.09',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Poeschel Falk' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'David','Prentice',104954,'45801','Turner Lovell','62.43.01-365.44',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Prentice David' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Rafal','Prokop',104954,'GB47 9985 260','Vital','95.52.05-181.88',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Prokop Rafal' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Andrzej','Prokop',104954,'GB47 9985 260','Siemens','72.42.21-397.03',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Prokop Andrzej' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Jordan','Read',104954,'GB65 1711 651','Tellemachus','95.47.16-165.30',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Read Jordan' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Shaun','Roberts',104954,'GB47 9985 260','Siemens','61.48.15-117.80',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Roberts Shaun' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Andrew','Robinson',104954,'GB42 4894 330','Volker Infra','88.50.28-323.65',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Robinson Andrew' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Andy','Robinson',104954,'','Volker Infra','',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Robinson Andy' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Dale','Hickingbotham',104954,'','NSV (Cient)','',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Hickingbotham Dale' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Stephen','Fenwick',104954,'','NSV (Client)','',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Fenwick Stephen' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Ben','Rose',104954,'GB52 4921 354','Triton Knoll','88.51.04-271.68',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Rose Ben' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Avril','Ross',104954,'46800','Turner Lovell','72.44.24-110.20',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Ross Avril' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Michael','Rowan',104954,'47859','Vital','81.49.17-391.76',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Rowan Michael' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Les','Rozak',104954,'GB47 9985 260','Siemens CIS','73.45.02-369.61',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Rozak Les' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Dave','Rumis',104954,'GB47 9985 260','Siemens','62.41.20-227.83',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Rumis Dave' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Jason','Ryan',104954,'','Vital','',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Ryan Jason' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Abhishek','Sarkar',104954,'','Siemens','',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Sarkar Abhishek' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Anthony','Shepley',104954,'GB63 8895 377','Grosvenor','77.52.28-379.83',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Shepley Anthony' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'William','Shepley',104954,'GB63 8895 377','Grosvenor','65.44.03-329.90',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Shepley William' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Chris','Sims',104954,'GB47 9985 260','Siemens UK (visitor)','98.42.25-157.87',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Sims Chris' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Krik','Sinclair',104954,'GB73 0757 237','Volker Infra','83.41.12-335.74',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Sinclair Krik' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Steven','Slater',104954,'GB47 9985 260','Siemens','76.52.17-383.97',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Slater Steven' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Sean','Smith',104954,'GB13 5555 706','Siemens','86.48.05-423.17',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Smith Sean' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Scott','Smith',104954,'GB19 2970 668','Triton Knoll','87.48.19-363.66',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Smith Scott' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Garry','Smith',104954,'GB33 8521 555','Grosvenor','70.52.14-375.69',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Smith Garry' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Sam','Springbett',104954,'48050','Vital','94.43.20-257.60',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Springbett Sam' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Marius','Stavru',104954,'GB66 7132 627','Vysiion','92.46.19-255.71',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Stavru Marius' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Stephen','Stuart',104954,'GB53 6862 615','Siemens','61.49.26-235.27',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Stuart Stephen' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Richard','Swainston',104954,'','Siemens','',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Swainston Richard' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'James','Swanson',104954,'GB29 7287 108','JGC','82.45.16-409.81',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Swanson James' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Dariusz','Szafulski',104954,'GB47 9985 260','Vital','70.41.26-397.95',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Szafulski Dariusz' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Andrew','Tait',104954,'GB47 9985 260','Siemens','96.48.17-129.64',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Tait Andrew' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Denis','Tevenan',104954,'44529','Vital','71.49.24-341.94',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Tevenan Denis' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'David','Thomas',104954,'GB31 9408 108','Vital','73.46.11-389.69',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Thomas David' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'John','Thompson',104954,'GB81 3184 448','Turner Lovell','62.44.28-231.54',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Thompson John' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Stanislaw','Tomczyk',104954,'GB47 9985 260','Vital','75.41.07-125.72',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Tomczyk Stanislaw' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Benny','Toth',104954,'GB16 9870 750','Turner Lovell','58.43.11-205.14',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Toth Benny' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Andrew','Ulley',104954,'GB45 7767 494','Wardpower','71.43.09-389.66',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Ulley Andrew' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Ian','Underhill',104954,'GB66 7132 627','Vysiion','68.46.24-365.83',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Underhill Ian' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Jorrit','Van Rhijn',104954,'NL00 1920 509B 01','Boskalis (Client)','89.43.18-257.15',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Van Rhijn Jorrit' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Mathias','Vandenbulcke',104954,'','Netwerk','',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Vandenbulcke Mathias' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Steven','Virk',104954,'GB42 4894 330','Volker Infra','93.50.13-219.45',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Virk Steven' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Daniel','Walker',104954,'GB91 0328 264','Turner Lovell','95.46.16-237.48',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Walker Daniel' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Jamie','Weatherill',104954,'GB31 4907 606','Turner Lovell','87.44.12-293.27',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Weatherill Jamie' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Mirjam','Weltevreden',104954,'NL18 8114 075B 01','Harvey Nash','76.48.12-104.13',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Weltevreden Mirjam' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Paul','Wilkinson',104954,'GB90 2972 031','Volker Infra','71.43.05-331.50',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Wilkinson Paul' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Neil','Williams',104954,'50546','Vital','60.50.02-095.97',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Williams Neil' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Mark','Williamson',104954,'GB42 4894 330','Volker Infra','81.50.25-369.59',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Williamson Mark' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'John','Williamson',104954,'','Siemens UK','',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Williamson John' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Paul','Hipperson',104954,'','Siemens Metering','',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Hipperson Paul' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Matthew','Wilson',104954,'39169','Volker Infra','99.47.02-113.04',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Wilson Matthew' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Mel','Wisby',104954,'38373','Turner Lovell','64.41.26-257.12',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Wisby Mel' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'John','Wright',104954,'GB19 2140 721','Volker Infra','65.45.02-319.40',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Wright John' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Wayne','Wright',104954,'GB19 2140 721','Volker Infra','71.48.17-303.44',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Wright Wayne' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Martin','Wykman',104954,'GB66 7132 627','Vysiion','72.47.25-373.39',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Wykman Martin' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Keith','Wynne',104954,'GB61 0644 963','Charnevel','71.44.17-333.83',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Wynne Keith' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Gokce','Yontucu',104954,'GB19 6963 933','Siemens','76.49.26-415.65',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Yontucu Gokce' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Chris','Young',104954,'GB65 1711 651','Tellemachus','68.48.20-341.47',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Young Chris' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Fairuz','Yusof',104954,'GB15 8729 271','Siemens','84.45.27-291.08',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Yusof Fairuz' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Max','Zarusinski',104954,'GB28 2885 261','sub of siemens','82.46.26-385.06',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='Zarusinski Max' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Toma','CHAVDAROV',104954,'0883.386.027','Zelfstandig','01.01.1969',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='CHAVDAROV Toma' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Mihaly','MUDRA',104954,'BE 0436.490.892','Interim AGO','',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='MUDRA Mihaly' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Lajos','GERE',104954,'HU26 2655 77','KISS VILL TEAM KORLATOLT','73.49.11-197.88',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='GERE Lajos' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Janos','HAJDU',104954,'HU26 2655 77','KISS VILL TEAM KORLATOLT','85.41.19-191.50',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='HAJDU Janos' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Gergo','KULCSAR',104954,'HU26 2655 77','KISS VILL TEAM KORLATOLT','83.51.15-197.95',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='KULCSAR Gergo' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- INSERT INTO person (person_id, vehicle_owner_id, first_name, last_name, vo_person_category_id, real_employer_tin, real_employer_name, niss,lm_date,lm_comment,lm_name,person_status_id, home_poi_id) VALUES (seq_person_id.NEXTVAL,101390,'Peter','ZENTAI',104954,'HU26 2655 77','KISS VILL TEAM KORLATOLT','72.45.30-283.62',SYSDATE,'Siemens load 2020','PSI',0,(SELECT poi_id FROM oc_poi WHERE name='ZENTAI Peter' AND TRUNC(lm_date)=TRUNC(SYSDATE) AND lm_comment='Siemens load 2020' AND lm_name='PSI'));
- COMMIT;
- -- key_code inserts
- --insert into key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) values (seq_key_code_id.nextval,101390,(select person_id from person where vo_person_category_id = 104954 and vehicle_owner_id = 101390 and first_name = 'Brent' AND last_name ='Allman' and trunc(lm_date) = trunc(sysdate) and lm_comment = 'Siemens load 2020' and lm_name='PSI'),null,'PSI',sysdate,'Siemens load 2020',13,to_date('19/12/2019','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Anwer' AND last_name ='AMARA-KORBA' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 7953 0189 4034','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('31/12/2020','dd/MM/yyyy'));
- --insert into key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) values (seq_key_code_id.nextval,101390,(select person_id from person where vo_person_category_id = 104954 and vehicle_owner_id = 101390 and first_name = 'Michael' AND last_name ='Anderson' and trunc(lm_date) = trunc(sysdate) and lm_comment = 'Siemens load 2020' and lm_name='PSI'),null,'PSI',sysdate,'Siemens load 2020',13,to_date('07/07/2020','dd/MM/yyyy'));
- --insert into key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) values (seq_key_code_id.nextval,101390,(select person_id from person where vo_person_category_id = 104954 and vehicle_owner_id = 101390 and first_name = 'Mark' AND last_name ='Bader-Jones' and trunc(lm_date) = trunc(sysdate) and lm_comment = 'Siemens load 2020' and lm_name='PSI'),null,'PSI',sysdate,'Siemens load 2020',13,to_date('31/12/2019','dd/MM/yyyy'));
- --insert into key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) values (seq_key_code_id.nextval,101390,(select person_id from person where vo_person_category_id = 104954 and vehicle_owner_id = 101390 and first_name = 'William' AND last_name ='Bain' and trunc(lm_date) = trunc(sysdate) and lm_comment = 'Siemens load 2020' and lm_name='PSI'),null,'PSI',sysdate,'Siemens load 2020',13,to_date('01/02/2020','dd/MM/yyyy'));
- --insert into key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) values (seq_key_code_id.nextval,101390,(select person_id from person where vo_person_category_id = 104954 and vehicle_owner_id = 101390 and first_name = 'Keith' AND last_name ='Baker' and trunc(lm_date) = trunc(sysdate) and lm_comment = 'Siemens load 2020' and lm_name='PSI'),'24911 8102 0601 8045','PSI',sysdate,'Siemens load 2020',13,to_date('31/03/2020','dd/MM/yyyy'));
- --insert into key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) values (seq_key_code_id.nextval,101390,(select person_id from person where vo_person_category_id = 104954 and vehicle_owner_id = 101390 and first_name = 'Linda' AND last_name ='Christian' and trunc(lm_date) = trunc(sysdate) and lm_comment = 'Siemens load 2020' and lm_name='PSI'),null,'PSI',sysdate,'Siemens load 2020',13,null);
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Simon' AND last_name ='Barnes' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8045 0162 2063','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('31/03/2020','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Kenny' AND last_name ='Barrow' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8089 0524 7075','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('19/07/2019','dd/MM/yyyy'));
- --insert into key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) values (seq_key_code_id.nextval,101390,(select person_id from person where vo_person_category_id = 104954 and vehicle_owner_id = 101390 and first_name = 'Tom' AND last_name ='Barton' and trunc(lm_date) = trunc(sysdate) and lm_comment = 'Siemens load 2020' and lm_name='PSI'),null,'PSI',sysdate,'Siemens load 2020',13,to_date('31/12/2019','dd/MM/yyyy'));
- --insert into key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) values (seq_key_code_id.nextval,101390,(select person_id from person where vo_person_category_id = 104954 and vehicle_owner_id = 101390 and first_name = 'Georgi' AND last_name ='Barzev' and trunc(lm_date) = trunc(sysdate) and lm_comment = 'Siemens load 2020' and lm_name='PSI'),null,'PSI',sysdate,'Siemens load 2020',13,to_date('30/09/2019','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Bojan' AND last_name ='Bjelanovic' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8052 0034 8080','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('15/08/2020','dd/MM/yyyy'));
- --insert into key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) values (seq_key_code_id.nextval,101390,(select person_id from person where vo_person_category_id = 104954 and vehicle_owner_id = 101390 and first_name = 'Lewis' AND last_name ='Boland' and trunc(lm_date) = trunc(sysdate) and lm_comment = 'Siemens load 2020' and lm_name='PSI'),null,'PSI',sysdate,'Siemens load 2020',13,to_date('18/12/2019','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Hassan' AND last_name ='Bouchadour' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8266 0027 7008','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('31/12/2019','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Paul' AND last_name ='Bowman' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8232 0652 5010','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('31/01/2020','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Carl' AND last_name ='Boynton' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8108 0242 8074','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('04/05/2020','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Adam' AND last_name ='Bremner' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8213 0715 9086','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('30/11/2019','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Christopher' AND last_name ='Buckley' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8166 0594 4088','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('31/03/2020','dd/MM/yyyy'));
- --insert into key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) values (seq_key_code_id.nextval,101390,(select person_id from person where vo_person_category_id = 104954 and vehicle_owner_id = 101390 and first_name = 'Jack' AND last_name ='Lumsden' and trunc(lm_date) = trunc(sysdate) and lm_comment = 'Siemens load 2020' and lm_name='PSI'),null,'PSI',sysdate,'Siemens load 2020',13,to_date('15/11/2019','dd/MM/yyyy'));
- --insert into key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) values (seq_key_code_id.nextval,101390,(select person_id from person where vo_person_category_id = 104954 and vehicle_owner_id = 101390 and first_name = 'Artur' AND last_name ='Budek' and trunc(lm_date) = trunc(sysdate) and lm_comment = 'Siemens load 2020' and lm_name='PSI'),null,'PSI',sysdate,'Siemens load 2020',13,to_date('31/12/2019','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Nick' AND last_name ='Bushell' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8198 0815 5036','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('29/12/2019','dd/MM/yyyy'));
- --insert into key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) values (seq_key_code_id.nextval,101390,(select person_id from person where vo_person_category_id = 104954 and vehicle_owner_id = 101390 and first_name = 'Elliot' AND last_name ='Carroll' and trunc(lm_date) = trunc(sysdate) and lm_comment = 'Siemens load 2020' and lm_name='PSI'),'24911 8040 0510 0015','PSI',sysdate,'Siemens load 2020',13,to_date('19/12/2019','dd/MM/yyyy'));
- --insert into key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) values (seq_key_code_id.nextval,101390,(select person_id from person where vo_person_category_id = 104954 and vehicle_owner_id = 101390 and first_name = 'Lewis' AND last_name ='Chaney' and trunc(lm_date) = trunc(sysdate) and lm_comment = 'Siemens load 2020' and lm_name='PSI'),null,'PSI',sysdate,'Siemens load 2020',13,to_date('20/12/2019','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Leigh' AND last_name ='Chrisholme' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8040 0510 0015','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('07/08/2020','dd/MM/yyyy'));
- --insert into key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) values (seq_key_code_id.nextval,101390,(select person_id from person where vo_person_category_id = 104954 and vehicle_owner_id = 101390 and first_name = 'Mason' AND last_name ='Christopher' and trunc(lm_date) = trunc(sysdate) and lm_comment = 'Siemens load 2020' and lm_name='PSI'),'24911 8269 0499 8046','PSI',sysdate,'Siemens load 2020',13,to_date('13/12/2019','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Jason' AND last_name ='Clark' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8225 0018 6045','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('28/08/2020','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Eddie' AND last_name ='Coblenz' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8068 0366 7094','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('31/03/2020','dd/MM/yyyy'));
- --insert into key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) values (seq_key_code_id.nextval,101390,(select person_id from person where vo_person_category_id = 104954 and vehicle_owner_id = 101390 and first_name = 'Josh' AND last_name ='Coulson' and trunc(lm_date) = trunc(sysdate) and lm_comment = 'Siemens load 2020' and lm_name='PSI'),null,'PSI',sysdate,'Siemens load 2020',13,to_date('20/12/2019','dd/MM/yyyy'));
- --insert into key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) values (seq_key_code_id.nextval,101390,(select person_id from person where vo_person_category_id = 104954 and vehicle_owner_id = 101390 and first_name = 'Matthew' AND last_name ='Crowe' and trunc(lm_date) = trunc(sysdate) and lm_comment = 'Siemens load 2020' and lm_name='PSI'),null,'PSI',sysdate,'Siemens load 2020',13,to_date('20/12/2019','dd/MM/yyyy'));
- --insert into key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) values (seq_key_code_id.nextval,101390,(select person_id from person where vo_person_category_id = 104954 and vehicle_owner_id = 101390 and first_name = 'John' AND last_name ='Dall' and trunc(lm_date) = trunc(sysdate) and lm_comment = 'Siemens load 2020' and lm_name='PSI'),null,'PSI',sysdate,'Siemens load 2020',13,to_date('31/12/2019','dd/MM/yyyy'));
- --insert into key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) values (seq_key_code_id.nextval,101390,(select person_id from person where vo_person_category_id = 104954 and vehicle_owner_id = 101390 and first_name = 'Gareth' AND last_name ='Davis' and trunc(lm_date) = trunc(sysdate) and lm_comment = 'Siemens load 2020' and lm_name='PSI'),null,'PSI',sysdate,'Siemens load 2020',13,to_date('30/09/2019','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Pawel' AND last_name ='Dawidziuk' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8120 0081 6029','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('31/07/2020','dd/MM/yyyy'));
- --insert into key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) values (seq_key_code_id.nextval,101390,(select person_id from person where vo_person_category_id = 104954 and vehicle_owner_id = 101390 and first_name = 'Barry' AND last_name ='Deighton' and trunc(lm_date) = trunc(sysdate) and lm_comment = 'Siemens load 2020' and lm_name='PSI'),null,'PSI',sysdate,'Siemens load 2020',13,to_date('31/01/2020','dd/MM/yyyy'));
- --insert into key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) values (seq_key_code_id.nextval,101390,(select person_id from person where vo_person_category_id = 104954 and vehicle_owner_id = 101390 and first_name = 'Robert' AND last_name ='Dixon' and trunc(lm_date) = trunc(sysdate) and lm_comment = 'Siemens load 2020' and lm_name='PSI'),null,'PSI',sysdate,'Siemens load 2020',13,null);
- --insert into key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) values (seq_key_code_id.nextval,101390,(select person_id from person where vo_person_category_id = 104954 and vehicle_owner_id = 101390 and first_name = 'Glen' AND last_name ='Dobson' and trunc(lm_date) = trunc(sysdate) and lm_comment = 'Siemens load 2020' and lm_name='PSI'),null,'PSI',sysdate,'Siemens load 2020',13,to_date('18/12/2019','dd/MM/yyyy'));
- --insert into key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) values (seq_key_code_id.nextval,101390,(select person_id from person where vo_person_category_id = 104954 and vehicle_owner_id = 101390 and first_name = 'Billy (william)' AND last_name ='Donald' and trunc(lm_date) = trunc(sysdate) and lm_comment = 'Siemens load 2020' and lm_name='PSI'),null,'PSI',sysdate,'Siemens load 2020',13,to_date('15/11/2019','dd/MM/yyyy'));
- --insert into key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) values (seq_key_code_id.nextval,101390,(select person_id from person where vo_person_category_id = 104954 and vehicle_owner_id = 101390 and first_name = 'John' AND last_name ='Donaldson' and trunc(lm_date) = trunc(sysdate) and lm_comment = 'Siemens load 2020' and lm_name='PSI'),null,'PSI',sysdate,'Siemens load 2020',13,to_date('31/08/2020','dd/MM/yyyy'));
- --insert into key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) values (seq_key_code_id.nextval,101390,(select person_id from person where vo_person_category_id = 104954 and vehicle_owner_id = 101390 and first_name = 'Ian' AND last_name ='Douglas' and trunc(lm_date) = trunc(sysdate) and lm_comment = 'Siemens load 2020' and lm_name='PSI'),null,'PSI',sysdate,'Siemens load 2020',13,to_date('30/01/2020','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Niels' AND last_name ='Drouen' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8172 0993 5055','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('02/10/2020','dd/MM/yyyy'));
- --insert into key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) values (seq_key_code_id.nextval,101390,(select person_id from person where vo_person_category_id = 104954 and vehicle_owner_id = 101390 and first_name = 'Michael' AND last_name ='Drury' and trunc(lm_date) = trunc(sysdate) and lm_comment = 'Siemens load 2020' and lm_name='PSI'),null,'PSI',sysdate,'Siemens load 2020',13,to_date('30/03/2020','dd/MM/yyyy'));
- --insert into key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) values (seq_key_code_id.nextval,101390,(select person_id from person where vo_person_category_id = 104954 and vehicle_owner_id = 101390 and first_name = 'Raymond' AND last_name ='Pauley' and trunc(lm_date) = trunc(sysdate) and lm_comment = 'Siemens load 2020' and lm_name='PSI'),null,'PSI',sysdate,'Siemens load 2020',13,to_date('06/12/2019','dd/MM/yyyy'));
- --insert into key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) values (seq_key_code_id.nextval,101390,(select person_id from person where vo_person_category_id = 104954 and vehicle_owner_id = 101390 and first_name = 'Lotti' AND last_name ='Edwards' and trunc(lm_date) = trunc(sysdate) and lm_comment = 'Siemens load 2020' and lm_name='PSI'),null,'PSI',sysdate,'Siemens load 2020',13,null);
- --insert into key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) values (seq_key_code_id.nextval,101390,(select person_id from person where vo_person_category_id = 104954 and vehicle_owner_id = 101390 and first_name = 'Mark' AND last_name ='McAvoy' and trunc(lm_date) = trunc(sysdate) and lm_comment = 'Siemens load 2020' and lm_name='PSI'),null,'PSI',sysdate,'Siemens load 2020',13,to_date('18/12/2019','dd/MM/yyyy'));
- --insert into key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) values (seq_key_code_id.nextval,101390,(select person_id from person where vo_person_category_id = 104954 and vehicle_owner_id = 101390 and first_name = 'Andrew' AND last_name ='Egan' and trunc(lm_date) = trunc(sysdate) and lm_comment = 'Siemens load 2020' and lm_name='PSI'),null,'PSI',sysdate,'Siemens load 2020',13,to_date('01/02/2020','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Rachid' AND last_name ='El Maachi' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8036 0042 3096','PSI',SYSDATE,'Siemens load 2020',13,NULL);
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Chraig' AND last_name ='Ellis' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8120 0933 4084','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('31/12/2020','dd/MM/yyyy'));
- --insert into key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) values (seq_key_code_id.nextval,101390,(select person_id from person where vo_person_category_id = 104954 and vehicle_owner_id = 101390 and first_name = 'Kenny' AND last_name ='Fachnie' and trunc(lm_date) = trunc(sysdate) and lm_comment = 'Siemens load 2020' and lm_name='PSI'),null,'PSI',sysdate,'Siemens load 2020',13,to_date('31/12/2019','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Daniel' AND last_name ='Fadinger' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8199 0905 4048','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('17/12/2019','dd/MM/yyyy'));
- --insert into key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) values (seq_key_code_id.nextval,101390,(select person_id from person where vo_person_category_id = 104954 and vehicle_owner_id = 101390 and first_name = 'Soheil' AND last_name ='Farahbakhsh' and trunc(lm_date) = trunc(sysdate) and lm_comment = 'Siemens load 2020' and lm_name='PSI'),null,'PSI',sysdate,'Siemens load 2020',13,null);
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Daniel' AND last_name ='Fiedler' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8263 0688 6055','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('03/11/2019','dd/MM/yyyy'));
- --insert into key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) values (seq_key_code_id.nextval,101390,(select person_id from person where vo_person_category_id = 104954 and vehicle_owner_id = 101390 and first_name = 'Lewis' AND last_name ='Fleming' and trunc(lm_date) = trunc(sysdate) and lm_comment = 'Siemens load 2020' and lm_name='PSI'),null,'PSI',sysdate,'Siemens load 2020',13,to_date('18/12/2019','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Joseph' AND last_name ='Gallagher' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8089 0620 8054','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('30/04/2020','dd/MM/yyyy'));
- --insert into key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) values (seq_key_code_id.nextval,101390,(select person_id from person where vo_person_category_id = 104954 and vehicle_owner_id = 101390 and first_name = 'Sergio' AND last_name ='Giacomuzzi' and trunc(lm_date) = trunc(sysdate) and lm_comment = 'Siemens load 2020' and lm_name='PSI'),null,'PSI',sysdate,'Siemens load 2020',13,null);
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Andrej' AND last_name ='Gilles' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8277 0136 7076','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('27/01/2020','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'J.A.' AND last_name ='Glancy' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8269 0496 7006','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('13/12/2019','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Tomislav' AND last_name ='Golubic' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8185 0084 1028','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('31/12/2019','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Tim' AND last_name ='Gott' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8198 0110 2069','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('23/11/2019','dd/MM/yyyy'));
- --insert into key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) values (seq_key_code_id.nextval,101390,(select person_id from person where vo_person_category_id = 104954 and vehicle_owner_id = 101390 and first_name = 'Stuart' AND last_name ='Grainger' and trunc(lm_date) = trunc(sysdate) and lm_comment = 'Siemens load 2020' and lm_name='PSI'),null,'PSI',sysdate,'Siemens load 2020',13,to_date('29/11/2019','dd/MM/yyyy'));
- --insert into key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) values (seq_key_code_id.nextval,101390,(select person_id from person where vo_person_category_id = 104954 and vehicle_owner_id = 101390 and first_name = 'Barrie' AND last_name ='Gray' and trunc(lm_date) = trunc(sysdate) and lm_comment = 'Siemens load 2020' and lm_name='PSI'),null,'PSI',sysdate,'Siemens load 2020',13,to_date('28/08/2020','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'John' AND last_name ='Greenwood' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8269 0501 8028','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('13/12/2019','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'James' AND last_name ='Hannant' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8225 0767 8034','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('12/12/2019','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Darryl' AND last_name ='Hare' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8232 0771 7043','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('27/03/2020','dd/MM/yyyy'));
- --insert into key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) values (seq_key_code_id.nextval,101390,(select person_id from person where vo_person_category_id = 104954 and vehicle_owner_id = 101390 and first_name = 'Peter' AND last_name ='Harll' and trunc(lm_date) = trunc(sysdate) and lm_comment = 'Siemens load 2020' and lm_name='PSI'),null,'PSI',sysdate,'Siemens load 2020',13,null);
- --insert into key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) values (seq_key_code_id.nextval,101390,(select person_id from person where vo_person_category_id = 104954 and vehicle_owner_id = 101390 and first_name = 'Paul' AND last_name ='Hart' and trunc(lm_date) = trunc(sysdate) and lm_comment = 'Siemens load 2020' and lm_name='PSI'),null,'PSI',sysdate,'Siemens load 2020',13,to_date('18/12/2019','dd/MM/yyyy'));
- --insert into key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) values (seq_key_code_id.nextval,101390,(select person_id from person where vo_person_category_id = 104954 and vehicle_owner_id = 101390 and first_name = 'John' AND last_name ='Hartland' and trunc(lm_date) = trunc(sysdate) and lm_comment = 'Siemens load 2020' and lm_name='PSI'),null,'PSI',sysdate,'Siemens load 2020',13,to_date('31/12/2019','dd/MM/yyyy'));
- --insert into key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) values (seq_key_code_id.nextval,101390,(select person_id from person where vo_person_category_id = 104954 and vehicle_owner_id = 101390 and first_name = 'Paul' AND last_name ='Harvey' and trunc(lm_date) = trunc(sysdate) and lm_comment = 'Siemens load 2020' and lm_name='PSI'),null,'PSI',sysdate,'Siemens load 2020',13,to_date('31/10/2019','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Josip' AND last_name ='Hercigonja-Starcevic' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8185 0059 4066','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('20/10/2020','dd/MM/yyyy'));
- --insert into key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) values (seq_key_code_id.nextval,101390,(select person_id from person where vo_person_category_id = 104954 and vehicle_owner_id = 101390 and first_name = 'Jonathan' AND last_name ='Holt' and trunc(lm_date) = trunc(sysdate) and lm_comment = 'Siemens load 2020' and lm_name='PSI'),null,'PSI',sysdate,'Siemens load 2020',13,to_date('31/12/2019','dd/MM/yyyy'));
- --insert into key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) values (seq_key_code_id.nextval,101390,(select person_id from person where vo_person_category_id = 104954 and vehicle_owner_id = 101390 and first_name = 'Richard' AND last_name ='Hopkins' and trunc(lm_date) = trunc(sysdate) and lm_comment = 'Siemens load 2020' and lm_name='PSI'),null,'PSI',sysdate,'Siemens load 2020',13,to_date('22/11/2019','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Adrian' AND last_name ='Hubbard' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8232 0652 6077','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('31/10/2019','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Andrew' AND last_name ='Jackson' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8232 0764 0025','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('27/03/2020','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Lewis' AND last_name ='Johnson' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8198 0003 3032','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('31/07/2020','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Charlie' AND last_name ='Jones' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8228 0877 3018','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('18/12/2019','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Clive' AND last_name ='Jones' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8229 0051 7073','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('18/03/2020','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Kevin' AND last_name ='Jones' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8229 0052 5027','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('18/03/2020','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Brooker' AND last_name ='Julian' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 7969 0380 4026','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('01/04/2020','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Astrid' AND last_name ='Kalicharan' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8135 0272 3095','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('01/09/2020','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Peter' AND last_name ='Kay' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8250 0989 5078','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('20/12/2019','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Krystian' AND last_name ='Kazula' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8117 0957 8088','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('31/12/2019','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Tomasz' AND last_name ='Kazula' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8117 0955 6069','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('31/12/2020','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Adrian' AND last_name ='Kevill' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8179 0515 0060','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('25/10/2019','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'juergen' AND last_name ='Knauerhase' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8212 0005 6051','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('01/04/2020','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Ben' AND last_name ='Knight' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8232 0401 4068','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('15/12/2019','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'tomasz' AND last_name ='Kowal' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8152 0678 3011','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('31/12/2019','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Wojciech' AND last_name ='Kusnierz' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8125 0805 1048','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('31/12/2019','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'John' AND last_name ='Lee' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8081 0076 9039','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('27/03/2020','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Slawomir' AND last_name ='Lew' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8199 0922 2052','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('20/12/2019','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Mark' AND last_name ='Little' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8199 0710 0080','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('20/12/2019','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'William' AND last_name ='Little' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8198 0103 8049','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('20/12/2019','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Kevin' AND last_name ='Macphee' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8128 0881 9045','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('31/08/2020','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Danko' AND last_name ='Marin' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8133 0085 6007','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('17/04/2020','dd/MM/yyyy'));
- --insert into key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) values (seq_key_code_id.nextval,101390,(select person_id from person where vo_person_category_id = 104954 and vehicle_owner_id = 101390 and first_name = 'Christopher' AND last_name ='Mason' and trunc(lm_date) = trunc(sysdate) and lm_comment = 'Siemens load 2020' and lm_name='PSI'),'24911 8269 0499 8046','PSI',sysdate,'Siemens load 2020',13,to_date('13/12/2019','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Scott' AND last_name ='McAulay' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8220 0803 2004','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('30/04/2020','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Bernard' AND last_name ='McAulay' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8219 0401 1047','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('31/03/2020','dd/MM/yyyy'));
- --insert into key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) values (seq_key_code_id.nextval,101390,(select person_id from person where vo_person_category_id = 104954 and vehicle_owner_id = 101390 and first_name = 'John' AND last_name ='McClure' and trunc(lm_date) = trunc(sysdate) and lm_comment = 'Siemens load 2020' and lm_name='PSI'),null,'PSI',sysdate,'Siemens load 2020',13,null);
- --insert into key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) values (seq_key_code_id.nextval,101390,(select person_id from person where vo_person_category_id = 104954 and vehicle_owner_id = 101390 and first_name = 'William' AND last_name ='McCormick' and trunc(lm_date) = trunc(sysdate) and lm_comment = 'Siemens load 2020' and lm_name='PSI'),null,'PSI',sysdate,'Siemens load 2020',13,to_date('26/06/2020','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Mark' AND last_name ='McGlinchey' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8110 0099 6095','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('15/11/2019','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Martin' AND last_name ='McGuire' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8198 0284 7002','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('20/12/2019','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Richard' AND last_name ='McIntosh' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8121 0566 8082','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('23/08/2019','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Alan' AND last_name ='McLaughlin' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8250 0010 2055','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('31/12/2019','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Gregg' AND last_name ='McLeod' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8250 0008 9057','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('31/01/2020','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Scott' AND last_name ='McLeod' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8271 0992 9073','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('31/12/2019','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'mark' AND last_name ='McLeod' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8171 0305 0076','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('31/01/2020','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Billy' AND last_name ='Miller' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8052 0050 0079','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('07/01/2020','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Anthony' AND last_name ='Miniero' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8052 0038 3000','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('07/08/2020','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Barry' AND last_name ='Mitchell' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8240 0324 1009','PSI',SYSDATE,'Siemens load 2020',13,NULL);
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Paul' AND last_name ='Moon' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8250 0997 9080','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('31/12/2019','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Andrew' AND last_name ='Mowat' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8213 0716 0056','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('30/11/2019','dd/MM/yyyy'));
- --insert into key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) values (seq_key_code_id.nextval,101390,(select person_id from person where vo_person_category_id = 104954 and vehicle_owner_id = 101390 and first_name = 'Graeme' AND last_name ='Muir' and trunc(lm_date) = trunc(sysdate) and lm_comment = 'Siemens load 2020' and lm_name='PSI'),null,'PSI',sysdate,'Siemens load 2020',13,null);
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'David' AND last_name ='Munro' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8268 0565 8018','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('21/12/2019','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Del' AND last_name ='Nderi' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8246 0916 2082','PSI',SYSDATE,'Siemens load 2020',13,NULL);
- --insert into key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) values (seq_key_code_id.nextval,101390,(select person_id from person where vo_person_category_id = 104954 and vehicle_owner_id = 101390 and first_name = 'David' AND last_name ='Nes' and trunc(lm_date) = trunc(sysdate) and lm_comment = 'Siemens load 2020' and lm_name='PSI'),null,'PSI',sysdate,'Siemens load 2020',13,to_date('15/01/2020','dd/MM/yyyy'));
- --insert into key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) values (seq_key_code_id.nextval,101390,(select person_id from person where vo_person_category_id = 104954 and vehicle_owner_id = 101390 and first_name = 'Phili' AND last_name ='Nixon' and trunc(lm_date) = trunc(sysdate) and lm_comment = 'Siemens load 2020' and lm_name='PSI'),null,'PSI',sysdate,'Siemens load 2020',13,null);
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Gavin' AND last_name ='Owen' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8229 0049 3017','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('18/03/2020','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Mark' AND last_name ='Parsonage' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8067 0759 8003','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('30/09/2019','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'kevin' AND last_name ='Pennock' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8276 0430 8003','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('15/12/2019','dd/MM/yyyy'));
- --insert into key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) values (seq_key_code_id.nextval,101390,(select person_id from person where vo_person_category_id = 104954 and vehicle_owner_id = 101390 and first_name = 'Gustaaf' AND last_name ='Persoons' and trunc(lm_date) = trunc(sysdate) and lm_comment = 'Siemens load 2020' and lm_name='PSI'),null,'PSI',sysdate,'Siemens load 2020',13,null);
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Nathan' AND last_name ='Philips' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8229 0054 6076','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('18/03/2020','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Gary' AND last_name ='Plant' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8248 0775 3092','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('13/12/2019','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Falk' AND last_name ='Poeschel' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8200 0648 9093','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('03/04/2020','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'David' AND last_name ='Prentice' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8164 0464 3092','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('28/08/2020','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Rafal' AND last_name ='Prokop' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8176 0019 0014','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('09/10/2019','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Andrzej' AND last_name ='Prokop' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8082 0747 4083','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('31/03/2020','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Jordan' AND last_name ='Read' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8278 0917 3070','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('06/12/2019','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Shaun' AND last_name ='Roberts' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8110 0294 9093','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('31/03/2020','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Andrew' AND last_name ='Robinson' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8228 0874 3045','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('18/12/2019','dd/MM/yyyy'));
- --insert into key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) values (seq_key_code_id.nextval,101390,(select person_id from person where vo_person_category_id = 104954 and vehicle_owner_id = 101390 and first_name = 'Andy' AND last_name ='Robinson' and trunc(lm_date) = trunc(sysdate) and lm_comment = 'Siemens load 2020' and lm_name='PSI'),null,'PSI',sysdate,'Siemens load 2020',13,null);
- --insert into key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) values (seq_key_code_id.nextval,101390,(select person_id from person where vo_person_category_id = 104954 and vehicle_owner_id = 101390 and first_name = 'Dale' AND last_name ='Hickingbotham' and trunc(lm_date) = trunc(sysdate) and lm_comment = 'Siemens load 2020' and lm_name='PSI'),null,'PSI',sysdate,'Siemens load 2020',13,to_date('29/05/2020','dd/MM/yyyy'));
- --insert into key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) values (seq_key_code_id.nextval,101390,(select person_id from person where vo_person_category_id = 104954 and vehicle_owner_id = 101390 and first_name = 'Stephen' AND last_name ='Fenwick' and trunc(lm_date) = trunc(sysdate) and lm_comment = 'Siemens load 2020' and lm_name='PSI'),null,'PSI',sysdate,'Siemens load 2020',13,to_date('29/05/2020','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Ben' AND last_name ='Rose' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8248 0548 4068','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('31/12/2019','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Avril' AND last_name ='Ross' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8171 0041 0027','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('31/08/2020','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Michael' AND last_name ='Rowan' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8179 0206 0028','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('11/10/2019','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Les' AND last_name ='Rozak' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8227 0074 7028','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('31/12/2019','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Dave' AND last_name ='Rumis' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8165 0897 0084','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('30/06/2020','dd/MM/yyyy'));
- --insert into key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) values (seq_key_code_id.nextval,101390,(select person_id from person where vo_person_category_id = 104954 and vehicle_owner_id = 101390 and first_name = 'Jason' AND last_name ='Ryan' and trunc(lm_date) = trunc(sysdate) and lm_comment = 'Siemens load 2020' and lm_name='PSI'),null,'PSI',sysdate,'Siemens load 2020',13,to_date('20/12/2019','dd/MM/yyyy'));
- --insert into key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) values (seq_key_code_id.nextval,101390,(select person_id from person where vo_person_category_id = 104954 and vehicle_owner_id = 101390 and first_name = 'Abhishek' AND last_name ='Sarkar' and trunc(lm_date) = trunc(sysdate) and lm_comment = 'Siemens load 2020' and lm_name='PSI'),null,'PSI',sysdate,'Siemens load 2020',13,null);
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Anthony' AND last_name ='Shepley' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8190 0229 9018','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('30/09/2019','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'William' AND last_name ='Shepley' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8067 0766 9007','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('30/09/2019','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Chris' AND last_name ='Sims' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8176 0849 4087','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('30/06/2020','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Krik' AND last_name ='Sinclair' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8102 0382 9046','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('15/11/2019','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Steven' AND last_name ='Slater' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8225 0079 4041','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('28/02/2020','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Sean' AND last_name ='Smith' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8232 0405 7039','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('15/12/2019','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Scott' AND last_name ='Smith' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8248 0550 1043','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('20/12/2019','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Garry' AND last_name ='Smith' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8250 0999 7025','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('31/12/2019','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Sam' AND last_name ='Springbett' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8200 0994 9083','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('31/12/2019','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Marius' AND last_name ='Stavru' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8253 0402 6044','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('30/09/2019','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Stephen' AND last_name ='Stuart' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8234 0694 4082','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('30/04/2020','dd/MM/yyyy'));
- --insert into key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) values (seq_key_code_id.nextval,101390,(select person_id from person where vo_person_category_id = 104954 and vehicle_owner_id = 101390 and first_name = 'Richard' AND last_name ='Swainston' and trunc(lm_date) = trunc(sysdate) and lm_comment = 'Siemens load 2020' and lm_name='PSI'),null,'PSI',sysdate,'Siemens load 2020',13,null);
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'James' AND last_name ='Swanson' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8213 0716 1026','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('30/11/2019','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Dariusz' AND last_name ='Szafulski' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8125 0804 3094','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('22/08/2020','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Andrew' AND last_name ='Tait' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8225 0094 0026','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('01/04/2020','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Denis' AND last_name ='Tevenan' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8155 0840 7033','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('31/12/2019','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'David' AND last_name ='Thomas' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8180 0130 4026','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('31/12/2019','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'John' AND last_name ='Thompson' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8244 0137 3047','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('21/12/2019','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Stanislaw' AND last_name ='Tomczyk' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8121 0580 4076','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('31/12/2019','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Benny' AND last_name ='Toth' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8113 0282 9055','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('31/03/2020','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Andrew' AND last_name ='Ulley' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8221 0266 4040','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('28/11/2019','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Ian' AND last_name ='Underhill' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8246 0969 5000','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('14/12/2019','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Jorrit' AND last_name ='Van Rhijn' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8274 0473 8069','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('31/12/2019','dd/MM/yyyy'));
- --insert into key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) values (seq_key_code_id.nextval,101390,(select person_id from person where vo_person_category_id = 104954 and vehicle_owner_id = 101390 and first_name = 'Mathias' AND last_name ='Vandenbulcke' and trunc(lm_date) = trunc(sysdate) and lm_comment = 'Siemens load 2020' and lm_name='PSI'),null,'PSI',sysdate,'Siemens load 2020',13,null);
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Steven' AND last_name ='Virk' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8228 0867 0004','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('18/12/2019','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Daniel' AND last_name ='Walker' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8167 0076 6050','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('31/07/2020','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Jamie' AND last_name ='Weatherill' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8194 0583 1046','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('08/05/2020','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Mirjam' AND last_name ='Weltevreden' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8036 0091 3043','PSI',SYSDATE,'Siemens load 2020',13,NULL);
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Paul' AND last_name ='Wilkinson' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8080 0599 3055','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('19/06/2020','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Neil' AND last_name ='Williams' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8204 0693 5066','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('20/12/2019','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Mark' AND last_name ='Williamson' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8229 0049 8061','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('18/03/2020','dd/MM/yyyy'));
- --insert into key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) values (seq_key_code_id.nextval,101390,(select person_id from person where vo_person_category_id = 104954 and vehicle_owner_id = 101390 and first_name = 'John' AND last_name ='Williamson' and trunc(lm_date) = trunc(sysdate) and lm_comment = 'Siemens load 2020' and lm_name='PSI'),null,'PSI',sysdate,'Siemens load 2020',13,null);
- --insert into key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) values (seq_key_code_id.nextval,101390,(select person_id from person where vo_person_category_id = 104954 and vehicle_owner_id = 101390 and first_name = 'Paul' AND last_name ='Hipperson' and trunc(lm_date) = trunc(sysdate) and lm_comment = 'Siemens load 2020' and lm_name='PSI'),null,'PSI',sysdate,'Siemens load 2020',13,to_date('13/12/2019','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Matthew' AND last_name ='Wilson' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8114 0544 4094','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('18/12/2019','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Mel' AND last_name ='Wisby' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8117 0826 4029','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('31/08/2020','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'John' AND last_name ='Wright' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8228 0877 8062','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('18/12/2019','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Wayne' AND last_name ='Wright' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8114 0532 6045','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('18/12/2019','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Martin' AND last_name ='Wykman' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8268 0602 8073','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('13/12/2019','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Keith' AND last_name ='Wynne' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8067 0693 4038','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('31/10/2019','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Gokce' AND last_name ='Yontucu' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8110 0252 5009','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('05/08/2020','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Chris' AND last_name ='Young' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8278 0917 2003','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('29/11/2019','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Fairuz' AND last_name ='Yusof' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8150 0783 5041','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('30/07/2020','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Max' AND last_name ='Zarusinski' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8037 0018 6044','PSI',SYSDATE,'Siemens load 2020',13,TO_DATE('30/03/2020','dd/MM/yyyy'));
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Toma' AND last_name ='CHAVDAROV' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'RSZ-69010169552','PSI',SYSDATE,'Siemens load 2020',13,NULL);
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Mihaly' AND last_name ='MUDRA' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'RSZ-76111348720','PSI',SYSDATE,'Siemens load 2020',13,NULL);
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Lajos' AND last_name ='GERE' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8298 0452 0009','PSI',SYSDATE,'Siemens load 2020',13,NULL);
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Janos' AND last_name ='HAJDU' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8298 0447 6068','PSI',SYSDATE,'Siemens load 2020',13,NULL);
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Gergo' AND last_name ='KULCSAR' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8298 0451 7002','PSI',SYSDATE,'Siemens load 2020',13,NULL);
- INSERT INTO key_code (key_code_id, vehicle_owner_id, person_id, key_string, lm_name, lm_date, lm_comment, key_code_usage_id, active_until) VALUES (seq_key_code_id.NEXTVAL,101390,(SELECT person_id FROM person WHERE vo_person_category_id = 104954 AND vehicle_owner_id = 101390 AND first_name = 'Peter' AND last_name ='ZENTAI' AND TRUNC(lm_date) = TRUNC(SYSDATE) AND lm_comment = 'Siemens load 2020' AND lm_name='PSI'),'24911 8298 0451 4092','PSI',SYSDATE,'Siemens load 2020',13,NULL);
- ROLLBACK;
- UPDATE oc_poi
- SET lm_comment = NULL, lm_name = NULL, lm_date = NULL
- WHERE TRUNC(lm_date) = TRUNC(TO_DATE('18/02/2020','dd/MM/yyyy'))
- AND lm_name = 'PSI'
- AND lm_comment = 'Siemens load 2020';
- UPDATE person
- SET lm_comment = NULL, lm_name = NULL, lm_date = NULL
- WHERE TRUNC(lm_date) = TRUNC(TO_DATE('18/02/2020','dd/MM/yyyy'))
- AND lm_name = 'PSI'
- AND lm_comment = 'Siemens load 2020';
- UPDATE key_code
- SET lm_comment = NULL, lm_name = NULL, lm_date = NULL
- WHERE TRUNC(lm_date) = TRUNC(TO_DATE('18/02/2020','dd/MM/yyyy'))
- AND lm_name = 'PSI'
- AND lm_comment = 'Siemens load 2020';
- --commit;
- -- kato sa provereni dannite shte run-nem poslednite 3 updates
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement