API tools faq
paste
psi_mmobile

Untitled

psi_mmobile
Oct 22nd, 2019
214
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 42.71 KB | None | 0 0
raw download clone embed print report
  1. INSERT INTO oc_poi (country, poi_id, name, oc_poi_category_id, snapping_circle, location, post_code, street , street_nr, lm_date, lm_name, lm_comment, oc_poi_status_id,oc_poi_hr_reg_id) VALUES ('BE',seq_oc_poi_id.NEXTVAL,'Boterberg Johan',102002,200,'LIMELETTE',1342,'rue Alfred Haulotte','33A',SYSDATE,'PSI','PERSON LOAD PROCEDURE',0,0);
  2. INSERT INTO person (lm_name,lm_comment,lm_date,person_status_id,person_id,vo_person_category_id, first_name, last_name, phone, niss, company_nr, home_poi_id, real_employer_name) VALUES ('PSI','PERSON CREATION PROCEDURE',SYSDATE, 0, seq_person_id.NEXTVAL,104376,'Johan','Boterberg','0479/33 47 92','95100936374','102',seq_oc_poi_id.CURRVAL,'BATIS MOI PLUS');
  3. INSERT INTO key_code (lm_name,lm_date,lm_comment,key_code_usage_id,key_code_id,vehicle_owner_id,person_id,key_string) VALUES ('PSI',SYSDATE,NULL,13,seq_key_code_id.NEXTVAL,101385,seq_person_id.CURRVAL,'04B7895AE35D84');
  4. INSERT INTO vo_group_person (lm_comment,person_id,vo_group_id) VALUES ('PSI person group assignment for BM',seq_person_id.CURRVAL,2742);
  5. INSERT INTO oc_poi (country, poi_id, name, oc_poi_category_id, snapping_circle, location, post_code, street , street_nr, lm_date, lm_name, lm_comment, oc_poi_status_id,oc_poi_hr_reg_id) VALUES ('BE',seq_oc_poi_id.NEXTVAL,'Bougelet Maxime',102002,200,'BONNEVILLE',5300,'Rue de la Bruyère','72 bte 2',SYSDATE,'PSI','PERSON LOAD PROCEDURE',0,0);
  6. INSERT INTO person (lm_name,lm_comment,lm_date,person_status_id,person_id,vo_person_category_id, first_name, last_name, phone, niss, company_nr, home_poi_id, real_employer_name) VALUES ('PSI','PERSON CREATION PROCEDURE',SYSDATE, 0, seq_person_id.NEXTVAL,104288,'Maxime','Bougelet','0476/45 93 63','83102620750','103',seq_oc_poi_id.CURRVAL,'BATIS MOI');
  7. INSERT INTO key_code (lm_name,lm_date,lm_comment,key_code_usage_id,key_code_id,vehicle_owner_id,person_id,key_string) VALUES ('PSI',SYSDATE,NULL,13,seq_key_code_id.NEXTVAL,101385,seq_person_id.CURRVAL,'04B83B5AE35D84');
  8. INSERT INTO vo_group_person (lm_comment,person_id,vo_group_id) VALUES ('PSI person group assignment for BM',seq_person_id.CURRVAL,2743);
  9. INSERT INTO oc_poi (country, poi_id, name, oc_poi_category_id, snapping_circle, location, post_code, street , street_nr, lm_date, lm_name, lm_comment, oc_poi_status_id,oc_poi_hr_reg_id) VALUES ('BE',seq_oc_poi_id.NEXTVAL,'Collet Simon',102002,200,'THUIN',6530,'ruelle Jacques','11',SYSDATE,'PSI','PERSON LOAD PROCEDURE',0,0);
  10. INSERT INTO person (lm_name,lm_comment,lm_date,person_status_id,person_id,vo_person_category_id, first_name, last_name, phone, niss, company_nr, home_poi_id, real_employer_name) VALUES ('PSI','PERSON CREATION PROCEDURE',SYSDATE, 0, seq_person_id.NEXTVAL,104376,'Simon','Collet','0472/78 54 79','97061851752','104',seq_oc_poi_id.CURRVAL,'BATIS MOI PLUS');
  11. INSERT INTO key_code (lm_name,lm_date,lm_comment,key_code_usage_id,key_code_id,vehicle_owner_id,person_id,key_string) VALUES ('PSI',SYSDATE,NULL,13,seq_key_code_id.NEXTVAL,101385,seq_person_id.CURRVAL,'04C1485AE35D80');
  12. INSERT INTO vo_group_person (lm_comment,person_id,vo_group_id) VALUES ('PSI person group assignment for BM',seq_person_id.CURRVAL,2742);
  13. INSERT INTO oc_poi (country, poi_id, name, oc_poi_category_id, snapping_circle, location, post_code, street , street_nr, lm_date, lm_name, lm_comment, oc_poi_status_id,oc_poi_hr_reg_id) VALUES ('BE',seq_oc_poi_id.NEXTVAL,'De Blecker Ludovic',102002,200,'COURCELLES',6180,'rue du Nord','30',SYSDATE,'PSI','PERSON LOAD PROCEDURE',0,0);
  14. INSERT INTO person (lm_name,lm_comment,lm_date,person_status_id,person_id,vo_person_category_id, first_name, last_name, phone, niss, company_nr, home_poi_id, real_employer_name) VALUES ('PSI','PERSON CREATION PROCEDURE',SYSDATE, 0, seq_person_id.NEXTVAL,104376,'Ludovic','De Blecker','0471/87 80 23','87081721789','106',seq_oc_poi_id.CURRVAL,'BATIS MOI PLUS');
  15. INSERT INTO key_code (lm_name,lm_date,lm_comment,key_code_usage_id,key_code_id,vehicle_owner_id,person_id,key_string) VALUES ('PSI',SYSDATE,NULL,13,seq_key_code_id.NEXTVAL,101385,seq_person_id.CURRVAL,'04B8B95AE35D80');
  16. INSERT INTO vo_group_person (lm_comment,person_id,vo_group_id) VALUES ('PSI person group assignment for BM',seq_person_id.CURRVAL,2744);
  17. INSERT INTO oc_poi (country, poi_id, name, oc_poi_category_id, snapping_circle, location, post_code, street , street_nr, lm_date, lm_name, lm_comment, oc_poi_status_id,oc_poi_hr_reg_id) VALUES ('BE',seq_oc_poi_id.NEXTVAL,'De Smedt Yannick',102002,200,'FELUY',7181,'rue de la Coulette','3',SYSDATE,'PSI','PERSON LOAD PROCEDURE',0,0);
  18. INSERT INTO person (lm_name,lm_comment,lm_date,person_status_id,person_id,vo_person_category_id, first_name, last_name, phone, niss, company_nr, home_poi_id, real_employer_name) VALUES ('PSI','PERSON CREATION PROCEDURE',SYSDATE, 0, seq_person_id.NEXTVAL,104288,'Yannick','De Smedt','0479/03 83 18','84012608137','107',seq_oc_poi_id.CURRVAL,'BATIS MOI');
  19. INSERT INTO key_code (lm_name,lm_date,lm_comment,key_code_usage_id,key_code_id,vehicle_owner_id,person_id,key_string) VALUES ('PSI',SYSDATE,NULL,13,seq_key_code_id.NEXTVAL,101385,seq_person_id.CURRVAL,'04B8AC5AE35D80');
  20. INSERT INTO vo_group_person (lm_comment,person_id,vo_group_id) VALUES ('PSI person group assignment for BM',seq_person_id.CURRVAL,2742);
  21. INSERT INTO oc_poi (country, poi_id, name, oc_poi_category_id, snapping_circle, location, post_code, street , street_nr, lm_date, lm_name, lm_comment, oc_poi_status_id,oc_poi_hr_reg_id) VALUES ('BE',seq_oc_poi_id.NEXTVAL,'Debienne Guillaume',102002,200,'NIVELLES',1400,'rue 2 soc nationales','18',SYSDATE,'PSI','PERSON LOAD PROCEDURE',0,0);
  22. INSERT INTO person (lm_name,lm_comment,lm_date,person_status_id,person_id,vo_person_category_id, first_name, last_name, phone, niss, company_nr, home_poi_id, real_employer_name) VALUES ('PSI','PERSON CREATION PROCEDURE',SYSDATE, 0, seq_person_id.NEXTVAL,104376,'Guillaume','Debienne','0484/93 44 89','89102710356','108',seq_oc_poi_id.CURRVAL,'BATIS MOI PLUS');
  23. INSERT INTO key_code (lm_name,lm_date,lm_comment,key_code_usage_id,key_code_id,vehicle_owner_id,person_id,key_string) VALUES ('PSI',SYSDATE,NULL,13,seq_key_code_id.NEXTVAL,101385,seq_person_id.CURRVAL,'04B7345AE35D84');
  24. INSERT INTO vo_group_person (lm_comment,person_id,vo_group_id) VALUES ('PSI person group assignment for BM',seq_person_id.CURRVAL,2742);
  25. INSERT INTO oc_poi (country, poi_id, name, oc_poi_category_id, snapping_circle, location, post_code, street , street_nr, lm_date, lm_name, lm_comment, oc_poi_status_id,oc_poi_hr_reg_id) VALUES ('BE',seq_oc_poi_id.NEXTVAL,'Deminne Frederic',102002,200,'BAISY-THY',1470,'rue Longchamps','56 bte 4',SYSDATE,'PSI','PERSON LOAD PROCEDURE',0,0);
  26. INSERT INTO person (lm_name,lm_comment,lm_date,person_status_id,person_id,vo_person_category_id, first_name, last_name, phone, niss, company_nr, home_poi_id, real_employer_name) VALUES ('PSI','PERSON CREATION PROCEDURE',SYSDATE, 0, seq_person_id.NEXTVAL,104288,'Frederic','Deminne','0496/35 63 30','85100837378','109',seq_oc_poi_id.CURRVAL,'BATIS MOI');
  27. INSERT INTO key_code (lm_name,lm_date,lm_comment,key_code_usage_id,key_code_id,vehicle_owner_id,person_id,key_string) VALUES ('PSI',SYSDATE,NULL,13,seq_key_code_id.NEXTVAL,101385,seq_person_id.CURRVAL,'04B8A25AE35D80');
  28. INSERT INTO vo_group_person (lm_comment,person_id,vo_group_id) VALUES ('PSI person group assignment for BM',seq_person_id.CURRVAL,2743);
  29. INSERT INTO oc_poi (country, poi_id, name, oc_poi_category_id, snapping_circle, location, post_code, street , street_nr, lm_date, lm_name, lm_comment, oc_poi_status_id,oc_poi_hr_reg_id) VALUES ('BE',seq_oc_poi_id.NEXTVAL,'Dhondt Samuel',102002,200,'BRAINE L''ALLEUD',1420,'Grand Route','309',SYSDATE,'PSI','PERSON LOAD PROCEDURE',0,0);
  30. INSERT INTO person (lm_name,lm_comment,lm_date,person_status_id,person_id,vo_person_category_id, first_name, last_name, phone, niss, company_nr, home_poi_id, real_employer_name) VALUES ('PSI','PERSON CREATION PROCEDURE',SYSDATE, 0, seq_person_id.NEXTVAL,104288,'Samuel','Dhondt','0470/52 49 34','96122637770','110',seq_oc_poi_id.CURRVAL,'BATIS MOI');
  31. INSERT INTO key_code (lm_name,lm_date,lm_comment,key_code_usage_id,key_code_id,vehicle_owner_id,person_id,key_string) VALUES ('PSI',SYSDATE,NULL,13,seq_key_code_id.NEXTVAL,101385,seq_person_id.CURRVAL,'04B8865AE35D84');
  32. INSERT INTO vo_group_person (lm_comment,person_id,vo_group_id) VALUES ('PSI person group assignment for BM',seq_person_id.CURRVAL,2761);
  33. INSERT INTO oc_poi (country, poi_id, name, oc_poi_category_id, snapping_circle, location, post_code, street , street_nr, lm_date, lm_name, lm_comment, oc_poi_status_id,oc_poi_hr_reg_id) VALUES ('BE',seq_oc_poi_id.NEXTVAL,'Dubois Henri',102002,200,'VILLERS-LA-VILLE',1495,'rue de Mellery','36',SYSDATE,'PSI','PERSON LOAD PROCEDURE',0,0);
  34. INSERT INTO person (lm_name,lm_comment,lm_date,person_status_id,person_id,vo_person_category_id, first_name, last_name, phone, niss, company_nr, home_poi_id, real_employer_name) VALUES ('PSI','PERSON CREATION PROCEDURE',SYSDATE, 0, seq_person_id.NEXTVAL,104376,'Henri','Dubois','0473/86 50 64','79020835907','112',seq_oc_poi_id.CURRVAL,'BATIS MOI PLUS');
  35. INSERT INTO key_code (lm_name,lm_date,lm_comment,key_code_usage_id,key_code_id,vehicle_owner_id,person_id,key_string) VALUES ('PSI',SYSDATE,NULL,13,seq_key_code_id.NEXTVAL,101385,seq_person_id.CURRVAL,'04B8755AE35D84');
  36. INSERT INTO vo_group_person (lm_comment,person_id,vo_group_id) VALUES ('PSI person group assignment for BM',seq_person_id.CURRVAL,2743);
  37. INSERT INTO oc_poi (country, poi_id, name, oc_poi_category_id, snapping_circle, location, post_code, street , street_nr, lm_date, lm_name, lm_comment, oc_poi_status_id,oc_poi_hr_reg_id) VALUES ('BE',seq_oc_poi_id.NEXTVAL,'Duran Quentin',102002,200,'GENAPPE',1470,'rue de la Roche','3',SYSDATE,'PSI','PERSON LOAD PROCEDURE',0,0);
  38. INSERT INTO person (lm_name,lm_comment,lm_date,person_status_id,person_id,vo_person_category_id, first_name, last_name, phone, niss, company_nr, home_poi_id, real_employer_name) VALUES ('PSI','PERSON CREATION PROCEDURE',SYSDATE, 0, seq_person_id.NEXTVAL,104377,'Quentin','Duran','0475/55 29 69','91061312778','114',seq_oc_poi_id.CURRVAL,'RECYMAT');
  39. INSERT INTO key_code (lm_name,lm_date,lm_comment,key_code_usage_id,key_code_id,vehicle_owner_id,person_id,key_string) VALUES ('PSI',SYSDATE,NULL,13,seq_key_code_id.NEXTVAL,101385,seq_person_id.CURRVAL,'04B8035AE35D84');
  40. INSERT INTO vo_group_person (lm_comment,person_id,vo_group_id) VALUES ('PSI person group assignment for BM',seq_person_id.CURRVAL,2767);
  41. INSERT INTO oc_poi (country, poi_id, name, oc_poi_category_id, snapping_circle, location, post_code, street , street_nr, lm_date, lm_name, lm_comment, oc_poi_status_id,oc_poi_hr_reg_id) VALUES ('BE',seq_oc_poi_id.NEXTVAL,'Ems Adrien',102002,200,'GEMBLOUX',5030,'rue de Babilaire','44256',SYSDATE,'PSI','PERSON LOAD PROCEDURE',0,0);
  42. INSERT INTO person (lm_name,lm_comment,lm_date,person_status_id,person_id,vo_person_category_id, first_name, last_name, phone, niss, company_nr, home_poi_id, real_employer_name) VALUES ('PSI','PERSON CREATION PROCEDURE',SYSDATE, 0, seq_person_id.NEXTVAL,104376,'Adrien','Ems','0494/85 06 38','97100128150','116',seq_oc_poi_id.CURRVAL,'BATIS MOI PLUS');
  43. INSERT INTO key_code (lm_name,lm_date,lm_comment,key_code_usage_id,key_code_id,vehicle_owner_id,person_id,key_string) VALUES ('PSI',SYSDATE,NULL,13,seq_key_code_id.NEXTVAL,101385,seq_person_id.CURRVAL,'04C711DA3A6084');
  44. INSERT INTO vo_group_person (lm_comment,person_id,vo_group_id) VALUES ('PSI person group assignment for BM',seq_person_id.CURRVAL,2742);
  45. INSERT INTO oc_poi (country, poi_id, name, oc_poi_category_id, snapping_circle, location, post_code, street , street_nr, lm_date, lm_name, lm_comment, oc_poi_status_id,oc_poi_hr_reg_id) VALUES ('BE',seq_oc_poi_id.NEXTVAL,'Ivanov Sergei',102002,200,'ROUX',6044,'Avenue de Wallonie','22',SYSDATE,'PSI','PERSON LOAD PROCEDURE',0,0);
  46. INSERT INTO person (lm_name,lm_comment,lm_date,person_status_id,person_id,vo_person_category_id, first_name, last_name, phone, niss, company_nr, home_poi_id, real_employer_name) VALUES ('PSI','PERSON CREATION PROCEDURE',SYSDATE, 0, seq_person_id.NEXTVAL,104377,'Sergei','Ivanov','0496/95 40 11','72092551123','121',seq_oc_poi_id.CURRVAL,'TC MAT');
  47. INSERT INTO key_code (lm_name,lm_date,lm_comment,key_code_usage_id,key_code_id,vehicle_owner_id,person_id,key_string) VALUES ('PSI',SYSDATE,NULL,13,seq_key_code_id.NEXTVAL,101385,seq_person_id.CURRVAL,'04D6CBDA3A6080');
  48. INSERT INTO vo_group_person (lm_comment,person_id,vo_group_id) VALUES ('PSI person group assignment for BM',seq_person_id.CURRVAL,2769);
  49. INSERT INTO oc_poi (country, poi_id, name, oc_poi_category_id, snapping_circle, location, post_code, street , street_nr, lm_date, lm_name, lm_comment, oc_poi_status_id,oc_poi_hr_reg_id) VALUES ('BE',seq_oc_poi_id.NEXTVAL,'Lebrun Killian',102002,200,'CHASTRE',6450,'rue Alphonse Minique','33',SYSDATE,'PSI','PERSON LOAD PROCEDURE',0,0);
  50. INSERT INTO person (lm_name,lm_comment,lm_date,person_status_id,person_id,vo_person_category_id, first_name, last_name, phone, niss, company_nr, home_poi_id, real_employer_name) VALUES ('PSI','PERSON CREATION PROCEDURE',SYSDATE, 0, seq_person_id.NEXTVAL,104288,'Killian','Lebrun','0492/57 56 83','00051623360','123',seq_oc_poi_id.CURRVAL,'BATIS MOI');
  51. INSERT INTO key_code (lm_name,lm_date,lm_comment,key_code_usage_id,key_code_id,vehicle_owner_id,person_id,key_string) VALUES ('PSI',SYSDATE,NULL,13,seq_key_code_id.NEXTVAL,101385,seq_person_id.CURRVAL,'0488CBDA3A6080');
  52. INSERT INTO vo_group_person (lm_comment,person_id,vo_group_id) VALUES ('PSI person group assignment for BM',seq_person_id.CURRVAL,2760);
  53. INSERT INTO oc_poi (country, poi_id, name, oc_poi_category_id, snapping_circle, location, post_code, street , street_nr, lm_date, lm_name, lm_comment, oc_poi_status_id,oc_poi_hr_reg_id) VALUES ('BE',seq_oc_poi_id.NEXTVAL,'Mostenne Rémy',102002,200,'FOSSE-LA-VILLE',5070,'Route de St Gérard','45',SYSDATE,'PSI','PERSON LOAD PROCEDURE',0,0);
  54. INSERT INTO person (lm_name,lm_comment,lm_date,person_status_id,person_id,vo_person_category_id, first_name, last_name, phone, niss, company_nr, home_poi_id, real_employer_name) VALUES ('PSI','PERSON CREATION PROCEDURE',SYSDATE, 0, seq_person_id.NEXTVAL,104288,'Rémy','Mostenne','0472/75 62 05','90011417343','127',seq_oc_poi_id.CURRVAL,'BATIS MOI');
  55. INSERT INTO key_code (lm_name,lm_date,lm_comment,key_code_usage_id,key_code_id,vehicle_owner_id,person_id,key_string) VALUES ('PSI',SYSDATE,NULL,13,seq_key_code_id.NEXTVAL,101385,seq_person_id.CURRVAL,'0466D3DA3A6080');
  56. INSERT INTO vo_group_person (lm_comment,person_id,vo_group_id) VALUES ('PSI person group assignment for BM',seq_person_id.CURRVAL,2743);
  57. INSERT INTO oc_poi (country, poi_id, name, oc_poi_category_id, snapping_circle, location, post_code, street , street_nr, lm_date, lm_name, lm_comment, oc_poi_status_id,oc_poi_hr_reg_id) VALUES ('BE',seq_oc_poi_id.NEXTVAL,'Thibaut Pascal',102002,200,'WALHAIN',1457,'rue Gally','36',SYSDATE,'PSI','PERSON LOAD PROCEDURE',0,0);
  58. INSERT INTO person (lm_name,lm_comment,lm_date,person_status_id,person_id,vo_person_category_id, first_name, last_name, phone, niss, company_nr, home_poi_id, real_employer_name) VALUES ('PSI','PERSON CREATION PROCEDURE',SYSDATE, 0, seq_person_id.NEXTVAL,104288,'Pascal','Thibaut','0499/75 14 40','74010235381','130',seq_oc_poi_id.CURRVAL,'BATIS MOI');
  59. INSERT INTO key_code (lm_name,lm_date,lm_comment,key_code_usage_id,key_code_id,vehicle_owner_id,person_id,key_string) VALUES ('PSI',SYSDATE,NULL,13,seq_key_code_id.NEXTVAL,101385,seq_person_id.CURRVAL,'04EFC9DA3A6080');
  60. INSERT INTO vo_group_person (lm_comment,person_id,vo_group_id) VALUES ('PSI person group assignment for BM',seq_person_id.CURRVAL,2744);
  61. INSERT INTO oc_poi (country, poi_id, name, oc_poi_category_id, snapping_circle, location, post_code, street , street_nr, lm_date, lm_name, lm_comment, oc_poi_status_id,oc_poi_hr_reg_id) VALUES ('BE',seq_oc_poi_id.NEXTVAL,'Vanthielen Cédric',102002,200,'RANSART',6043,'Rue de la Bassée','75',SYSDATE,'PSI','PERSON LOAD PROCEDURE',0,0);
  62. INSERT INTO person (lm_name,lm_comment,lm_date,person_status_id,person_id,vo_person_category_id, first_name, last_name, phone, niss, company_nr, home_poi_id, real_employer_name) VALUES ('PSI','PERSON CREATION PROCEDURE',SYSDATE, 0, seq_person_id.NEXTVAL,104288,'Cédric','Vanthielen','0479/91 01 59','74122129138','131',seq_oc_poi_id.CURRVAL,'BATIS MOI');
  63. INSERT INTO key_code (lm_name,lm_date,lm_comment,key_code_usage_id,key_code_id,vehicle_owner_id,person_id,key_string) VALUES ('PSI',SYSDATE,NULL,13,seq_key_code_id.NEXTVAL,101385,seq_person_id.CURRVAL,'041FCBDA3A6080');
  64. INSERT INTO vo_group_person (lm_comment,person_id,vo_group_id) VALUES ('PSI person group assignment for BM',seq_person_id.CURRVAL,2742);
  65. INSERT INTO oc_poi (country, poi_id, name, oc_poi_category_id, snapping_circle, location, post_code, street , street_nr, lm_date, lm_name, lm_comment, oc_poi_status_id,oc_poi_hr_reg_id) VALUES ('BE',seq_oc_poi_id.NEXTVAL,'Vandenberg Thomas',102002,200,'MARBAIS',1495,'rue de la Jouerie','49',SYSDATE,'PSI','PERSON LOAD PROCEDURE',0,0);
  66. INSERT INTO person (lm_name,lm_comment,lm_date,person_status_id,person_id,vo_person_category_id, first_name, last_name, phone, niss, company_nr, home_poi_id, real_employer_name) VALUES ('PSI','PERSON CREATION PROCEDURE',SYSDATE, 0, seq_person_id.NEXTVAL,104288,'Thomas','Vandenberg','0479/88 29 10','86122129592','132',seq_oc_poi_id.CURRVAL,'BATIS MOI');
  67. INSERT INTO key_code (lm_name,lm_date,lm_comment,key_code_usage_id,key_code_id,vehicle_owner_id,person_id,key_string) VALUES ('PSI',SYSDATE,NULL,13,seq_key_code_id.NEXTVAL,101385,seq_person_id.CURRVAL,'04D2D4DA3A6080');
  68. INSERT INTO vo_group_person (lm_comment,person_id,vo_group_id) VALUES ('PSI person group assignment for BM',seq_person_id.CURRVAL,2761);
  69. INSERT INTO oc_poi (country, poi_id, name, oc_poi_category_id, snapping_circle, location, post_code, street , street_nr, lm_date, lm_name, lm_comment, oc_poi_status_id,oc_poi_hr_reg_id) VALUES ('BE',seq_oc_poi_id.NEXTVAL,'Vanespen Laurent',102002,200,'MONT-ST-GUIBERT',1435,'rue de Corbais','7',SYSDATE,'PSI','PERSON LOAD PROCEDURE',0,0);
  70. INSERT INTO person (lm_name,lm_comment,lm_date,person_status_id,person_id,vo_person_category_id, first_name, last_name, phone, niss, company_nr, home_poi_id, real_employer_name) VALUES ('PSI','PERSON CREATION PROCEDURE',SYSDATE, 0, seq_person_id.NEXTVAL,104288,'Laurent','Vanespen','0476/64 11 42','75050540387','133',seq_oc_poi_id.CURRVAL,'BATIS MOI');
  71. INSERT INTO key_code (lm_name,lm_date,lm_comment,key_code_usage_id,key_code_id,vehicle_owner_id,person_id,key_string) VALUES ('PSI',SYSDATE,NULL,13,seq_key_code_id.NEXTVAL,101385,seq_person_id.CURRVAL,'04CFC1DA3A6080');
  72. INSERT INTO vo_group_person (lm_comment,person_id,vo_group_id) VALUES ('PSI person group assignment for BM',seq_person_id.CURRVAL,2743);
  73. INSERT INTO oc_poi (country, poi_id, name, oc_poi_category_id, snapping_circle, location, post_code, street , street_nr, lm_date, lm_name, lm_comment, oc_poi_status_id,oc_poi_hr_reg_id) VALUES ('BE',seq_oc_poi_id.NEXTVAL,'Ventre de la Touloubre Mathieu',102002,200,'VILLERS-LA-VILLE',1495,'rue Froide Bise','50',SYSDATE,'PSI','PERSON LOAD PROCEDURE',0,0);
  74. INSERT INTO person (lm_name,lm_comment,lm_date,person_status_id,person_id,vo_person_category_id, first_name, last_name, phone, niss, company_nr, home_poi_id, real_employer_name) VALUES ('PSI','PERSON CREATION PROCEDURE',SYSDATE, 0, seq_person_id.NEXTVAL,104288,'Mathieu','Ventre de la Touloubre','0476/56 60 86','83041112555','134',seq_oc_poi_id.CURRVAL,'BATIS MOI');
  75. INSERT INTO key_code (lm_name,lm_date,lm_comment,key_code_usage_id,key_code_id,vehicle_owner_id,person_id,key_string) VALUES ('PSI',SYSDATE,NULL,13,seq_key_code_id.NEXTVAL,101385,seq_person_id.CURRVAL,'049DC4DA3A6080');
  76. INSERT INTO vo_group_person (lm_comment,person_id,vo_group_id) VALUES ('PSI person group assignment for BM',seq_person_id.CURRVAL,2742);
  77. INSERT INTO oc_poi (country, poi_id, name, oc_poi_category_id, snapping_circle, location, post_code, street , street_nr, lm_date, lm_name, lm_comment, oc_poi_status_id,oc_poi_hr_reg_id) VALUES ('BE',seq_oc_poi_id.NEXTVAL,'Vindevogel Frédéric',102002,200,'SART-DAMES-AVELINE',1495,'chaussée de Numur','18',SYSDATE,'PSI','PERSON LOAD PROCEDURE',0,0);
  78. INSERT INTO person (lm_name,lm_comment,lm_date,person_status_id,person_id,vo_person_category_id, first_name, last_name, phone, niss, company_nr, home_poi_id, real_employer_name) VALUES ('PSI','PERSON CREATION PROCEDURE',SYSDATE, 0, seq_person_id.NEXTVAL,104288,'Frédéric','Vindevogel','0476/60 49 79','75050631746','136',seq_oc_poi_id.CURRVAL,'BATIS MOI');
  79. INSERT INTO key_code (lm_name,lm_date,lm_comment,key_code_usage_id,key_code_id,vehicle_owner_id,person_id,key_string) VALUES ('PSI',SYSDATE,NULL,13,seq_key_code_id.NEXTVAL,101385,seq_person_id.CURRVAL,'045ECADA3A6080');
  80. INSERT INTO vo_group_person (lm_comment,person_id,vo_group_id) VALUES ('PSI person group assignment for BM',seq_person_id.CURRVAL,2770);
  81. INSERT INTO oc_poi (country, poi_id, name, oc_poi_category_id, snapping_circle, location, post_code, street , street_nr, lm_date, lm_name, lm_comment, oc_poi_status_id,oc_poi_hr_reg_id) VALUES ('BE',seq_oc_poi_id.NEXTVAL,'Vroman Antoine',102002,200,'VILLERS-LA-VILLE',1495,'rue Tienne','27',SYSDATE,'PSI','PERSON LOAD PROCEDURE',0,0);
  82. INSERT INTO person (lm_name,lm_comment,lm_date,person_status_id,person_id,vo_person_category_id, first_name, last_name, phone, niss, company_nr, home_poi_id, real_employer_name) VALUES ('PSI','PERSON CREATION PROCEDURE',SYSDATE, 0, seq_person_id.NEXTVAL,104377,'Antoine','Vroman','0472/37 42 60','98081150320','137',seq_oc_poi_id.CURRVAL,'RECYMAT');
  83. INSERT INTO key_code (lm_name,lm_date,lm_comment,key_code_usage_id,key_code_id,vehicle_owner_id,person_id,key_string) VALUES ('PSI',SYSDATE,NULL,13,seq_key_code_id.NEXTVAL,101385,seq_person_id.CURRVAL,'04CEF55AE35D80');
  84. INSERT INTO vo_group_person (lm_comment,person_id,vo_group_id) VALUES ('PSI person group assignment for BM',seq_person_id.CURRVAL,2767);
  85. INSERT INTO oc_poi (country, poi_id, name, oc_poi_category_id, snapping_circle, location, post_code, street , street_nr, lm_date, lm_name, lm_comment, oc_poi_status_id,oc_poi_hr_reg_id) VALUES ('BE',seq_oc_poi_id.NEXTVAL,'Vroman Maxime',102002,200,'VILLERS-LA-VILLE',1495,'rue Tienne','27',SYSDATE,'PSI','PERSON LOAD PROCEDURE',0,0);
  86. INSERT INTO person (lm_name,lm_comment,lm_date,person_status_id,person_id,vo_person_category_id, first_name, last_name, phone, niss, company_nr, home_poi_id, real_employer_name) VALUES ('PSI','PERSON CREATION PROCEDURE',SYSDATE, 0, seq_person_id.NEXTVAL,104377,'Maxime','Vroman','0477/20 27 79','92051326353','138',seq_oc_poi_id.CURRVAL,'RECYMAT');
  87. INSERT INTO key_code (lm_name,lm_date,lm_comment,key_code_usage_id,key_code_id,vehicle_owner_id,person_id,key_string) VALUES ('PSI',SYSDATE,NULL,13,seq_key_code_id.NEXTVAL,101385,seq_person_id.CURRVAL,'04C6AC5AE35D80');
  88. INSERT INTO vo_group_person (lm_comment,person_id,vo_group_id) VALUES ('PSI person group assignment for BM',seq_person_id.CURRVAL,2767);
  89. INSERT INTO oc_poi (country, poi_id, name, oc_poi_category_id, snapping_circle, location, post_code, street , street_nr, lm_date, lm_name, lm_comment, oc_poi_status_id,oc_poi_hr_reg_id) VALUES ('BE',seq_oc_poi_id.NEXTVAL,'Wellin Martine',102002,200,'SUARLEE',5020,'Clair Val','34',SYSDATE,'PSI','PERSON LOAD PROCEDURE',0,0);
  90. INSERT INTO person (lm_name,lm_comment,lm_date,person_status_id,person_id,vo_person_category_id, first_name, last_name, phone, niss, company_nr, home_poi_id, real_employer_name) VALUES ('PSI','PERSON CREATION PROCEDURE',SYSDATE, 0, seq_person_id.NEXTVAL,104510,'Martine','Wellin','0494/76 07 20','65122708866','139',seq_oc_poi_id.CURRVAL,'BATIS MOI');
  91. INSERT INTO key_code (lm_name,lm_date,lm_comment,key_code_usage_id,key_code_id,vehicle_owner_id,person_id,key_string) VALUES ('PSI',SYSDATE,NULL,13,seq_key_code_id.NEXTVAL,101385,seq_person_id.CURRVAL,'04DA735AE35D84');
  92. INSERT INTO vo_group_person (lm_comment,person_id,vo_group_id) VALUES ('PSI person group assignment for BM',seq_person_id.CURRVAL,2762);
  93. INSERT INTO oc_poi (country, poi_id, name, oc_poi_category_id, snapping_circle, location, post_code, street , street_nr, lm_date, lm_name, lm_comment, oc_poi_status_id,oc_poi_hr_reg_id) VALUES ('BE',seq_oc_poi_id.NEXTVAL,'Thiry Romaric',102002,200,'VIEUX GENAPPE',1472,'Chaussée de Nivelles','65',SYSDATE,'PSI','PERSON LOAD PROCEDURE',0,0);
  94. INSERT INTO person (lm_name,lm_comment,lm_date,person_status_id,person_id,vo_person_category_id, first_name, last_name, phone, niss, company_nr, home_poi_id, real_employer_name) VALUES ('PSI','PERSON CREATION PROCEDURE',SYSDATE, 0, seq_person_id.NEXTVAL,104288,'Romaric','Thiry','0493/43 10 67','91041816174','140',seq_oc_poi_id.CURRVAL,'BATIS MOI');
  95. INSERT INTO key_code (lm_name,lm_date,lm_comment,key_code_usage_id,key_code_id,vehicle_owner_id,person_id,key_string) VALUES ('PSI',SYSDATE,NULL,13,seq_key_code_id.NEXTVAL,101385,seq_person_id.CURRVAL,'04C72F5AE35D84');
  96. INSERT INTO vo_group_person (lm_comment,person_id,vo_group_id) VALUES ('PSI person group assignment for BM',seq_person_id.CURRVAL,2744);
  97. INSERT INTO oc_poi (country, poi_id, name, oc_poi_category_id, snapping_circle, location, post_code, street , street_nr, lm_date, lm_name, lm_comment, oc_poi_status_id,oc_poi_hr_reg_id) VALUES ('BE',seq_oc_poi_id.NEXTVAL,'Duval Damien',102002,200,'FRASNE-LEZ-GOSSELIES',6210,'Chaussée de Bruxelles','690',SYSDATE,'PSI','PERSON LOAD PROCEDURE',0,0);
  98. INSERT INTO person (lm_name,lm_comment,lm_date,person_status_id,person_id,vo_person_category_id, first_name, last_name, phone, niss, company_nr, home_poi_id, real_employer_name) VALUES ('PSI','PERSON CREATION PROCEDURE',SYSDATE, 0, seq_person_id.NEXTVAL,104376,'Damien','Duval','0470/37 01 28','88031522728','143',seq_oc_poi_id.CURRVAL,'BATIS MOI PLUS');
  99. INSERT INTO key_code (lm_name,lm_date,lm_comment,key_code_usage_id,key_code_id,vehicle_owner_id,person_id,key_string) VALUES ('PSI',SYSDATE,NULL,13,seq_key_code_id.NEXTVAL,101385,seq_person_id.CURRVAL,'04D5735AE35D80');
  100. INSERT INTO vo_group_person (lm_comment,person_id,vo_group_id) VALUES ('PSI person group assignment for BM',seq_person_id.CURRVAL,2742);
  101. INSERT INTO oc_poi (country, poi_id, name, oc_poi_category_id, snapping_circle, location, post_code, street , street_nr, lm_date, lm_name, lm_comment, oc_poi_status_id,oc_poi_hr_reg_id) VALUES ('BE',seq_oc_poi_id.NEXTVAL,'Pierrot Félix',102002,200,'BUZET',6230,'Chaussée de Nivelles','697',SYSDATE,'PSI','PERSON LOAD PROCEDURE',0,0);
  102. INSERT INTO person (lm_name,lm_comment,lm_date,person_status_id,person_id,vo_person_category_id, first_name, last_name, phone, niss, company_nr, home_poi_id, real_employer_name) VALUES ('PSI','PERSON CREATION PROCEDURE',SYSDATE, 0, seq_person_id.NEXTVAL,104377,'Félix','Pierrot','0472/ 04 01 77','98080133701','145',seq_oc_poi_id.CURRVAL,'RECYMAT');
  103. INSERT INTO key_code (lm_name,lm_date,lm_comment,key_code_usage_id,key_code_id,vehicle_owner_id,person_id,key_string) VALUES ('PSI',SYSDATE,NULL,13,seq_key_code_id.NEXTVAL,101385,seq_person_id.CURRVAL,'04DAC65AE35D80');
  104. INSERT INTO vo_group_person (lm_comment,person_id,vo_group_id) VALUES ('PSI person group assignment for BM',seq_person_id.CURRVAL,2767);
  105. INSERT INTO oc_poi (country, poi_id, name, oc_poi_category_id, snapping_circle, location, post_code, street , street_nr, lm_date, lm_name, lm_comment, oc_poi_status_id,oc_poi_hr_reg_id) VALUES ('BE',seq_oc_poi_id.NEXTVAL,'Rabelo Batista Igor',102002,200,'JEMEPPE SUR SAMBRE',5190,'Rue Neuve','5',SYSDATE,'PSI','PERSON LOAD PROCEDURE',0,0);
  106. INSERT INTO person (lm_name,lm_comment,lm_date,person_status_id,person_id,vo_person_category_id, first_name, last_name, phone, niss, company_nr, home_poi_id, real_employer_name) VALUES ('PSI','PERSON CREATION PROCEDURE',SYSDATE, 0, seq_person_id.NEXTVAL,104377,'Igor','Rabelo Batista','0475/82 50 97','93040163357','159',seq_oc_poi_id.CURRVAL,'TC MAT');
  107. INSERT INTO key_code (lm_name,lm_date,lm_comment,key_code_usage_id,key_code_id,vehicle_owner_id,person_id,key_string) VALUES ('PSI',SYSDATE,NULL,13,seq_key_code_id.NEXTVAL,101385,seq_person_id.CURRVAL,'04545462E35D85');
  108. INSERT INTO vo_group_person (lm_comment,person_id,vo_group_id) VALUES ('PSI person group assignment for BM',seq_person_id.CURRVAL,2763);
  109. INSERT INTO oc_poi (country, poi_id, name, oc_poi_category_id, snapping_circle, location, post_code, street , street_nr, lm_date, lm_name, lm_comment, oc_poi_status_id,oc_poi_hr_reg_id) VALUES ('BE',seq_oc_poi_id.NEXTVAL,'Rody Anthony',102002,200,'SPY',5190,'rue du Megonot','30',SYSDATE,'PSI','PERSON LOAD PROCEDURE',0,0);
  110. INSERT INTO person (lm_name,lm_comment,lm_date,person_status_id,person_id,vo_person_category_id, first_name, last_name, phone, niss, company_nr, home_poi_id, real_employer_name) VALUES ('PSI','PERSON CREATION PROCEDURE',SYSDATE, 0, seq_person_id.NEXTVAL,104377,'Anthony','Rody','0493/17 20 85','74040910147','148',seq_oc_poi_id.CURRVAL,'BATIS MOI PLUS');
  111. INSERT INTO key_code (lm_name,lm_date,lm_comment,key_code_usage_id,key_code_id,vehicle_owner_id,person_id,key_string) VALUES ('PSI',SYSDATE,NULL,13,seq_key_code_id.NEXTVAL,101385,seq_person_id.CURRVAL,'04B90A5AE35D80');
  112. INSERT INTO vo_group_person (lm_comment,person_id,vo_group_id) VALUES ('PSI person group assignment for BM',seq_person_id.CURRVAL,2743);
  113. INSERT INTO oc_poi (country, poi_id, name, oc_poi_category_id, snapping_circle, location, post_code, street , street_nr, lm_date, lm_name, lm_comment, oc_poi_status_id,oc_poi_hr_reg_id) VALUES ('BE',seq_oc_poi_id.NEXTVAL,'De Grom Jérémie',102002,200,'TONGRINNE',5140,'rue Pichelin','93 A1',SYSDATE,'PSI','PERSON LOAD PROCEDURE',0,0);
  114. INSERT INTO person (lm_name,lm_comment,lm_date,person_status_id,person_id,vo_person_category_id, first_name, last_name, phone, niss, company_nr, home_poi_id, real_employer_name) VALUES ('PSI','PERSON CREATION PROCEDURE',SYSDATE, 0, seq_person_id.NEXTVAL,104377,'Jérémie','De Grom','0472/37 58 56','90021011336','149',seq_oc_poi_id.CURRVAL,'BATIS MOI PLUS');
  115. INSERT INTO key_code (lm_name,lm_date,lm_comment,key_code_usage_id,key_code_id,vehicle_owner_id,person_id,key_string) VALUES ('PSI',SYSDATE,NULL,13,seq_key_code_id.NEXTVAL,101385,seq_person_id.CURRVAL,'04C09A5AE35D84');
  116. INSERT INTO vo_group_person (lm_comment,person_id,vo_group_id) VALUES ('PSI person group assignment for BM',seq_person_id.CURRVAL,2742);
  117. INSERT INTO oc_poi (country, poi_id, name, oc_poi_category_id, snapping_circle, location, post_code, street , street_nr, lm_date, lm_name, lm_comment, oc_poi_status_id,oc_poi_hr_reg_id) VALUES ('BE',seq_oc_poi_id.NEXTVAL,'Martin Sébastien',102002,200,'MOGNELEE',5060,'Rue Trieu malonne','3',SYSDATE,'PSI','PERSON LOAD PROCEDURE',0,0);
  118. INSERT INTO person (lm_name,lm_comment,lm_date,person_status_id,person_id,vo_person_category_id, first_name, last_name, phone, niss, company_nr, home_poi_id, real_employer_name) VALUES ('PSI','PERSON CREATION PROCEDURE',SYSDATE, 0, seq_person_id.NEXTVAL,104377,'Sébastien','Martin','0492/70 52 23','87072525397','153',seq_oc_poi_id.CURRVAL,'TC MAT');
  119. INSERT INTO key_code (lm_name,lm_date,lm_comment,key_code_usage_id,key_code_id,vehicle_owner_id,person_id,key_string) VALUES ('PSI',SYSDATE,NULL,13,seq_key_code_id.NEXTVAL,101385,seq_person_id.CURRVAL,'04507462E35D85');
  120. INSERT INTO vo_group_person (lm_comment,person_id,vo_group_id) VALUES ('PSI person group assignment for BM',seq_person_id.CURRVAL,2773);
  121. INSERT INTO oc_poi (country, poi_id, name, oc_poi_category_id, snapping_circle, location, post_code, street , street_nr, lm_date, lm_name, lm_comment, oc_poi_status_id,oc_poi_hr_reg_id) VALUES ('BE',seq_oc_poi_id.NEXTVAL,'Fragapane Salvatore',102002,200,'GILLY',6060,'rue du Coquelet','98/001',SYSDATE,'PSI','PERSON LOAD PROCEDURE',0,0);
  122. INSERT INTO person (lm_name,lm_comment,lm_date,person_status_id,person_id,vo_person_category_id, first_name, last_name, phone, niss, company_nr, home_poi_id, real_employer_name) VALUES ('PSI','PERSON CREATION PROCEDURE',SYSDATE, 0, seq_person_id.NEXTVAL,104288,'Salvatore','Fragapane','0476/48 51 51','86112649328','154',seq_oc_poi_id.CURRVAL,'BATIS MOI');
  123. INSERT INTO key_code (lm_name,lm_date,lm_comment,key_code_usage_id,key_code_id,vehicle_owner_id,person_id,key_string) VALUES ('PSI',SYSDATE,NULL,13,seq_key_code_id.NEXTVAL,101385,seq_person_id.CURRVAL,'0477F4AAB65E80');
  124. INSERT INTO vo_group_person (lm_comment,person_id,vo_group_id) VALUES ('PSI person group assignment for BM',seq_person_id.CURRVAL,2763);
  125. INSERT INTO oc_poi (country, poi_id, name, oc_poi_category_id, snapping_circle, location, post_code, street , street_nr, lm_date, lm_name, lm_comment, oc_poi_status_id,oc_poi_hr_reg_id) VALUES ('BE',seq_oc_poi_id.NEXTVAL,'Neimry Victor',102002,200,'LIGNY',5140,'rue Gaie','12',SYSDATE,'PSI','PERSON LOAD PROCEDURE',0,0);
  126. INSERT INTO person (lm_name,lm_comment,lm_date,person_status_id,person_id,vo_person_category_id, first_name, last_name, phone, niss, company_nr, home_poi_id, real_employer_name) VALUES ('PSI','PERSON CREATION PROCEDURE',SYSDATE, 0, seq_person_id.NEXTVAL,104376,'Victor','Neimry','0475/56 54 04','95053025797','155',seq_oc_poi_id.CURRVAL,'BATIS MOI PLUS');
  127. INSERT INTO key_code (lm_name,lm_date,lm_comment,key_code_usage_id,key_code_id,vehicle_owner_id,person_id,key_string) VALUES ('PSI',SYSDATE,NULL,13,seq_key_code_id.NEXTVAL,101385,seq_person_id.CURRVAL,'0487C7AAB65E80');
  128. INSERT INTO vo_group_person (lm_comment,person_id,vo_group_id) VALUES ('PSI person group assignment for BM',seq_person_id.CURRVAL,2764);
  129. INSERT INTO oc_poi (country, poi_id, name, oc_poi_category_id, snapping_circle, location, post_code, street , street_nr, lm_date, lm_name, lm_comment, oc_poi_status_id,oc_poi_hr_reg_id) VALUES ('BE',seq_oc_poi_id.NEXTVAL,'Pelsmaekers Sonia',102002,200,'HUPPAYE',1367,'rue des Fripiers','18',SYSDATE,'PSI','PERSON LOAD PROCEDURE',0,0);
  130. INSERT INTO person (lm_name,lm_comment,lm_date,person_status_id,person_id,vo_person_category_id, first_name, last_name, phone, niss, company_nr, home_poi_id, real_employer_name) VALUES ('PSI','PERSON CREATION PROCEDURE',SYSDATE, 0, seq_person_id.NEXTVAL,104510,'Sonia','Pelsmaekers','0494/38 16 57','64032527450','156',seq_oc_poi_id.CURRVAL,'BATIS MOI');
  131. INSERT INTO key_code (lm_name,lm_date,lm_comment,key_code_usage_id,key_code_id,vehicle_owner_id,person_id,key_string) VALUES ('PSI',SYSDATE,NULL,13,seq_key_code_id.NEXTVAL,101385,seq_person_id.CURRVAL,'0485DCDA3A6080');
  132. INSERT INTO vo_group_person (lm_comment,person_id,vo_group_id) VALUES ('PSI person group assignment for BM',seq_person_id.CURRVAL,2765);
  133. INSERT INTO oc_poi (country, poi_id, name, oc_poi_category_id, snapping_circle, location, post_code, street , street_nr, lm_date, lm_name, lm_comment, oc_poi_status_id,oc_poi_hr_reg_id) VALUES ('BE',seq_oc_poi_id.NEXTVAL,'Brichard Renaud',102002,200,'SART-EUSTACHE',5070,'rue du Sartia','28',SYSDATE,'PSI','PERSON LOAD PROCEDURE',0,0);
  134. INSERT INTO person (lm_name,lm_comment,lm_date,person_status_id,person_id,vo_person_category_id, first_name, last_name, phone, niss, company_nr, home_poi_id, real_employer_name) VALUES ('PSI','PERSON CREATION PROCEDURE',SYSDATE, 0, seq_person_id.NEXTVAL,104376,'Renaud','Brichard','0486/07 58 41','76022634795','157',seq_oc_poi_id.CURRVAL,'BATIS MOI PLUS');
  135. INSERT INTO key_code (lm_name,lm_date,lm_comment,key_code_usage_id,key_code_id,vehicle_owner_id,person_id,key_string) VALUES ('PSI',SYSDATE,NULL,13,seq_key_code_id.NEXTVAL,101385,seq_person_id.CURRVAL,'04BFDDDA3A6080');
  136. INSERT INTO vo_group_person (lm_comment,person_id,vo_group_id) VALUES ('PSI person group assignment for BM',seq_person_id.CURRVAL,2744);
  137. INSERT INTO oc_poi (country, poi_id, name, oc_poi_category_id, snapping_circle, location, post_code, street , street_nr, lm_date, lm_name, lm_comment, oc_poi_status_id,oc_poi_hr_reg_id) VALUES ('BE',seq_oc_poi_id.NEXTVAL,'Lambert Cédric',102002,200,'FERNELMONT',5380,'rue de la Tour','2',SYSDATE,'PSI','PERSON LOAD PROCEDURE',0,0);
  138. INSERT INTO person (lm_name,lm_comment,lm_date,person_status_id,person_id,vo_person_category_id, first_name, last_name, phone, niss, company_nr, home_poi_id, real_employer_name) VALUES ('PSI','PERSON CREATION PROCEDURE',SYSDATE, 0, seq_person_id.NEXTVAL,104376,'Cédric','Lambert','0475/25 27 86','78080832364','158',seq_oc_poi_id.CURRVAL,'BATIS MOI PLUS');
  139. INSERT INTO key_code (lm_name,lm_date,lm_comment,key_code_usage_id,key_code_id,vehicle_owner_id,person_id,key_string) VALUES ('PSI',SYSDATE,NULL,13,seq_key_code_id.NEXTVAL,101385,seq_person_id.CURRVAL,'048941AAB65E80');
  140. INSERT INTO vo_group_person (lm_comment,person_id,vo_group_id) VALUES ('PSI person group assignment for BM',seq_person_id.CURRVAL,2768);
  141. INSERT INTO oc_poi (country, poi_id, name, oc_poi_category_id, snapping_circle, location, post_code, street , street_nr, lm_date, lm_name, lm_comment, oc_poi_status_id,oc_poi_hr_reg_id) VALUES ('BE',seq_oc_poi_id.NEXTVAL,'Lopez Filipe',102002,200,'BRAINE LE CHÂTEAU',1440,'rue de Nivelles','50',SYSDATE,'PSI','PERSON LOAD PROCEDURE',0,0);
  142. INSERT INTO person (lm_name,lm_comment,lm_date,person_status_id,person_id,vo_person_category_id, first_name, last_name, phone, niss, company_nr, home_poi_id, real_employer_name) VALUES ('PSI','PERSON CREATION PROCEDURE',SYSDATE, 0, seq_person_id.NEXTVAL,104510,'Filipe','Lopez','0471/39 29 29','95091624374','125',seq_oc_poi_id.CURRVAL,'BATIS MOI PLUS');
  143. INSERT INTO key_code (lm_name,lm_date,lm_comment,key_code_usage_id,key_code_id,vehicle_owner_id,person_id,key_string) VALUES ('PSI',SYSDATE,NULL,13,seq_key_code_id.NEXTVAL,101385,seq_person_id.CURRVAL,'048865AAB65E80');
  144. INSERT INTO vo_group_person (lm_comment,person_id,vo_group_id) VALUES ('PSI person group assignment for BM',seq_person_id.CURRVAL,2766);
  145. INSERT INTO oc_poi (country, poi_id, name, oc_poi_category_id, snapping_circle, location, post_code, street , street_nr, lm_date, lm_name, lm_comment, oc_poi_status_id,oc_poi_hr_reg_id) VALUES ('BE',seq_oc_poi_id.NEXTVAL,'Meynaerts Vincent',102002,200,'SART-DAMES-AVELINES',1495,'rue St Jean','14',SYSDATE,'PSI','PERSON LOAD PROCEDURE',0,0);
  146. INSERT INTO person (lm_name,lm_comment,lm_date,person_status_id,person_id,vo_person_category_id, first_name, last_name, phone, niss, company_nr, home_poi_id, real_employer_name) VALUES ('PSI','PERSON CREATION PROCEDURE',SYSDATE, 0, seq_person_id.NEXTVAL,104288,'Vincent','Meynaerts','0474/44 20 88','89052250956','126',seq_oc_poi_id.CURRVAL,'BATIS MOI');
  147. INSERT INTO key_code (lm_name,lm_date,lm_comment,key_code_usage_id,key_code_id,vehicle_owner_id,person_id,key_string) VALUES ('PSI',SYSDATE,NULL,13,seq_key_code_id.NEXTVAL,101385,seq_person_id.CURRVAL,'04BADDDA3A6080');
  148. INSERT INTO vo_group_person (lm_comment,person_id,vo_group_id) VALUES ('PSI person group assignment for BM',seq_person_id.CURRVAL,2771);
  149. INSERT INTO oc_poi (country, poi_id, name, oc_poi_category_id, snapping_circle, location, post_code, street , street_nr, lm_date, lm_name, lm_comment, oc_poi_status_id,oc_poi_hr_reg_id) VALUES ('BE',seq_oc_poi_id.NEXTVAL,'Oubouaziz Anas',102002,200,'JUMET',6040,'rue de l''Abbaye','40',SYSDATE,'PSI','PERSON LOAD PROCEDURE',0,0);
  150. INSERT INTO person (lm_name,lm_comment,lm_date,person_status_id,person_id,vo_person_category_id, first_name, last_name, phone, niss, company_nr, home_poi_id, real_employer_name) VALUES ('PSI','PERSON CREATION PROCEDURE',SYSDATE, 0, seq_person_id.NEXTVAL,104288,'Anas','Oubouaziz','0472/29 42 82','88040336563','128',seq_oc_poi_id.CURRVAL,'BATIS MOI');
  151. INSERT INTO key_code (lm_name,lm_date,lm_comment,key_code_usage_id,key_code_id,vehicle_owner_id,person_id,key_string) VALUES ('PSI',SYSDATE,NULL,13,seq_key_code_id.NEXTVAL,101385,seq_person_id.CURRVAL,'0487B5AAB65E80');
  152. INSERT INTO vo_group_person (lm_comment,person_id,vo_group_id) VALUES ('PSI person group assignment for BM',seq_person_id.CURRVAL,2772);
  153. INSERT INTO oc_poi (country, poi_id, name, oc_poi_category_id, snapping_circle, location, post_code, street , street_nr, lm_date, lm_name, lm_comment, oc_poi_status_id,oc_poi_hr_reg_id) VALUES ('BE',seq_oc_poi_id.NEXTVAL,'Veraghaenne Didier',102002,200,'VILLERS-LA-VILLE',1495,'rue de l''Epine','4',SYSDATE,'PSI','PERSON LOAD PROCEDURE',0,0);
  154. INSERT INTO person (lm_name,lm_comment,lm_date,person_status_id,person_id,vo_person_category_id, first_name, last_name, phone, niss, company_nr, home_poi_id, real_employer_name) VALUES ('PSI','PERSON CREATION PROCEDURE',SYSDATE, 0, seq_person_id.NEXTVAL,104510,'Didier','Veraghaenne','0496/52 95 60','71031322128','135',seq_oc_poi_id.CURRVAL,'BATIS MOI');
  155. INSERT INTO key_code (lm_name,lm_date,lm_comment,key_code_usage_id,key_code_id,vehicle_owner_id,person_id,key_string) VALUES ('PSI',SYSDATE,NULL,13,seq_key_code_id.NEXTVAL,101385,seq_person_id.CURRVAL,'04D510DA3A6084');
  156. INSERT INTO vo_group_person (lm_comment,person_id,vo_group_id) VALUES ('PSI person group assignment for BM',seq_person_id.CURRVAL,2766);
  157. INSERT INTO oc_poi (country, poi_id, name, oc_poi_category_id, snapping_circle, location, post_code, street , street_nr, lm_date, lm_name, lm_comment, oc_poi_status_id,oc_poi_hr_reg_id) VALUES ('BE',seq_oc_poi_id.NEXTVAL,'Verset Quentin',102002,200,'VILLERS-PERWIN',6210,'chaussée de Bruxelles','337',SYSDATE,'PSI','PERSON LOAD PROCEDURE',0,0);
  158. INSERT INTO person (lm_name,lm_comment,lm_date,person_status_id,person_id,vo_person_category_id, first_name, last_name, phone, niss, company_nr, home_poi_id, real_employer_name) VALUES ('PSI','PERSON CREATION PROCEDURE',SYSDATE, 0, seq_person_id.NEXTVAL,104376,'Quentin','Verset','0479/42 47 37','97072130782','142',seq_oc_poi_id.CURRVAL,'BATIS MOI PLUS');
  159. INSERT INTO key_code (lm_name,lm_date,lm_comment,key_code_usage_id,key_code_id,vehicle_owner_id,person_id,key_string) VALUES ('PSI',SYSDATE,NULL,13,seq_key_code_id.NEXTVAL,101385,seq_person_id.CURRVAL,'0477B8AAB65E80');
  160. INSERT INTO vo_group_person (lm_comment,person_id,vo_group_id) VALUES ('PSI person group assignment for BM',seq_person_id.CURRVAL,2761);
  161. INSERT INTO oc_poi (country, poi_id, name, oc_poi_category_id, snapping_circle, location, post_code, street , street_nr, lm_date, lm_name, lm_comment, oc_poi_status_id,oc_poi_hr_reg_id) VALUES ('BE',seq_oc_poi_id.NEXTVAL,'Damman Marc',102002,200,'DAUSSOIS',5630,'rue de Villers','2',SYSDATE,'PSI','PERSON LOAD PROCEDURE',0,0);
  162. INSERT INTO person (lm_name,lm_comment,lm_date,person_status_id,person_id,vo_person_category_id, first_name, last_name, phone, niss, company_nr, home_poi_id, real_employer_name) VALUES ('PSI','PERSON CREATION PROCEDURE',SYSDATE, 0, seq_person_id.NEXTVAL,104510,'Marc','Damman','0498/93 64 77','84031908355','160',seq_oc_poi_id.CURRVAL,'BATIS MOI');
  163. INSERT INTO key_code (lm_name,lm_date,lm_comment,key_code_usage_id,key_code_id,vehicle_owner_id,person_id,key_string) VALUES ('PSI',SYSDATE,NULL,13,seq_key_code_id.NEXTVAL,101385,seq_person_id.CURRVAL,'0407CAE2BB5B81');
  164. INSERT INTO vo_group_person (lm_comment,person_id,vo_group_id) VALUES ('PSI person group assignment for BM',seq_person_id.CURRVAL,2771);
  165.  
  166. SELECT * FROM oc_poi
  167. ORDER BY 1 DESC;
  168.  
  169. SELECT * FROM person
  170. ORDER BY 1 DESC;
  171.  
  172. SELECT * FROM oc_poi
  173. WHERE poi_id = 999236;
  174.  
  175. SELECT * FROM vo_group_person
  176. ORDER BY 2 DESC;
  177.  
  178. SELECT * FROM vo_group
  179. WHERE vo_group_id = 2771;
  180.  
  181. SELECT * FROM key_code
  182. ORDER BY 1 DESC;
  183. --begin
  184. --  p_poi.updateNoGeocodePoiCat(102002);
  185. --end;
  186. COMMIT;
  187. --ungeocoded POIs
  188. --ids -> 999227,999214,999205,999202,999201
  189. -- statement to see
  190. SELECT * FROM oc_poi
  191. WHERE WGS84_LATITUDE IS  NULL
  192. AND WGS84_LONGITUDE IS  NULL
  193. AND oc_poi_category_id = 102002
  194. AND lm_comment = 'PERSON LOAD PROCEDURE'
  195. ORDER BY 1 DESC;
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!