Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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);
- 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');
- 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');
- INSERT INTO vo_group_person (lm_comment,person_id,vo_group_id) VALUES ('PSI person group assignment for BM',seq_person_id.CURRVAL,2742);
- 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);
- 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');
- 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');
- INSERT INTO vo_group_person (lm_comment,person_id,vo_group_id) VALUES ('PSI person group assignment for BM',seq_person_id.CURRVAL,2743);
- 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);
- 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');
- 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');
- INSERT INTO vo_group_person (lm_comment,person_id,vo_group_id) VALUES ('PSI person group assignment for BM',seq_person_id.CURRVAL,2742);
- 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);
- 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');
- 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');
- INSERT INTO vo_group_person (lm_comment,person_id,vo_group_id) VALUES ('PSI person group assignment for BM',seq_person_id.CURRVAL,2744);
- 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);
- 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');
- 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');
- INSERT INTO vo_group_person (lm_comment,person_id,vo_group_id) VALUES ('PSI person group assignment for BM',seq_person_id.CURRVAL,2742);
- 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);
- 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');
- 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');
- INSERT INTO vo_group_person (lm_comment,person_id,vo_group_id) VALUES ('PSI person group assignment for BM',seq_person_id.CURRVAL,2742);
- 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);
- 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');
- 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');
- INSERT INTO vo_group_person (lm_comment,person_id,vo_group_id) VALUES ('PSI person group assignment for BM',seq_person_id.CURRVAL,2743);
- 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);
- 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');
- 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');
- INSERT INTO vo_group_person (lm_comment,person_id,vo_group_id) VALUES ('PSI person group assignment for BM',seq_person_id.CURRVAL,2761);
- 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);
- 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');
- 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');
- INSERT INTO vo_group_person (lm_comment,person_id,vo_group_id) VALUES ('PSI person group assignment for BM',seq_person_id.CURRVAL,2743);
- 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);
- 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');
- 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');
- INSERT INTO vo_group_person (lm_comment,person_id,vo_group_id) VALUES ('PSI person group assignment for BM',seq_person_id.CURRVAL,2767);
- 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);
- 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');
- 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');
- INSERT INTO vo_group_person (lm_comment,person_id,vo_group_id) VALUES ('PSI person group assignment for BM',seq_person_id.CURRVAL,2742);
- 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);
- 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');
- 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');
- INSERT INTO vo_group_person (lm_comment,person_id,vo_group_id) VALUES ('PSI person group assignment for BM',seq_person_id.CURRVAL,2769);
- 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);
- 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');
- 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');
- INSERT INTO vo_group_person (lm_comment,person_id,vo_group_id) VALUES ('PSI person group assignment for BM',seq_person_id.CURRVAL,2760);
- 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);
- 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');
- 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');
- INSERT INTO vo_group_person (lm_comment,person_id,vo_group_id) VALUES ('PSI person group assignment for BM',seq_person_id.CURRVAL,2743);
- 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);
- 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');
- 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');
- INSERT INTO vo_group_person (lm_comment,person_id,vo_group_id) VALUES ('PSI person group assignment for BM',seq_person_id.CURRVAL,2744);
- 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);
- 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');
- 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');
- INSERT INTO vo_group_person (lm_comment,person_id,vo_group_id) VALUES ('PSI person group assignment for BM',seq_person_id.CURRVAL,2742);
- 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);
- 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');
- 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');
- INSERT INTO vo_group_person (lm_comment,person_id,vo_group_id) VALUES ('PSI person group assignment for BM',seq_person_id.CURRVAL,2761);
- 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);
- 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');
- 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');
- INSERT INTO vo_group_person (lm_comment,person_id,vo_group_id) VALUES ('PSI person group assignment for BM',seq_person_id.CURRVAL,2743);
- 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);
- 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');
- 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');
- INSERT INTO vo_group_person (lm_comment,person_id,vo_group_id) VALUES ('PSI person group assignment for BM',seq_person_id.CURRVAL,2742);
- 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);
- 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');
- 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');
- INSERT INTO vo_group_person (lm_comment,person_id,vo_group_id) VALUES ('PSI person group assignment for BM',seq_person_id.CURRVAL,2770);
- 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);
- 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');
- 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');
- INSERT INTO vo_group_person (lm_comment,person_id,vo_group_id) VALUES ('PSI person group assignment for BM',seq_person_id.CURRVAL,2767);
- 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);
- 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');
- 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');
- INSERT INTO vo_group_person (lm_comment,person_id,vo_group_id) VALUES ('PSI person group assignment for BM',seq_person_id.CURRVAL,2767);
- 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);
- 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');
- 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');
- INSERT INTO vo_group_person (lm_comment,person_id,vo_group_id) VALUES ('PSI person group assignment for BM',seq_person_id.CURRVAL,2762);
- 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);
- 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');
- 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');
- INSERT INTO vo_group_person (lm_comment,person_id,vo_group_id) VALUES ('PSI person group assignment for BM',seq_person_id.CURRVAL,2744);
- 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);
- 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');
- 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');
- INSERT INTO vo_group_person (lm_comment,person_id,vo_group_id) VALUES ('PSI person group assignment for BM',seq_person_id.CURRVAL,2742);
- 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);
- 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');
- 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');
- INSERT INTO vo_group_person (lm_comment,person_id,vo_group_id) VALUES ('PSI person group assignment for BM',seq_person_id.CURRVAL,2767);
- 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);
- 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');
- 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');
- INSERT INTO vo_group_person (lm_comment,person_id,vo_group_id) VALUES ('PSI person group assignment for BM',seq_person_id.CURRVAL,2763);
- 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);
- 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');
- 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');
- INSERT INTO vo_group_person (lm_comment,person_id,vo_group_id) VALUES ('PSI person group assignment for BM',seq_person_id.CURRVAL,2743);
- 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);
- 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');
- 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');
- INSERT INTO vo_group_person (lm_comment,person_id,vo_group_id) VALUES ('PSI person group assignment for BM',seq_person_id.CURRVAL,2742);
- 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);
- 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');
- 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');
- INSERT INTO vo_group_person (lm_comment,person_id,vo_group_id) VALUES ('PSI person group assignment for BM',seq_person_id.CURRVAL,2773);
- 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);
- 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');
- 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');
- INSERT INTO vo_group_person (lm_comment,person_id,vo_group_id) VALUES ('PSI person group assignment for BM',seq_person_id.CURRVAL,2763);
- 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);
- 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');
- 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');
- INSERT INTO vo_group_person (lm_comment,person_id,vo_group_id) VALUES ('PSI person group assignment for BM',seq_person_id.CURRVAL,2764);
- 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);
- 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');
- 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');
- INSERT INTO vo_group_person (lm_comment,person_id,vo_group_id) VALUES ('PSI person group assignment for BM',seq_person_id.CURRVAL,2765);
- 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);
- 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');
- 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');
- INSERT INTO vo_group_person (lm_comment,person_id,vo_group_id) VALUES ('PSI person group assignment for BM',seq_person_id.CURRVAL,2744);
- 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);
- 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');
- 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');
- INSERT INTO vo_group_person (lm_comment,person_id,vo_group_id) VALUES ('PSI person group assignment for BM',seq_person_id.CURRVAL,2768);
- 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);
- 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');
- 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');
- INSERT INTO vo_group_person (lm_comment,person_id,vo_group_id) VALUES ('PSI person group assignment for BM',seq_person_id.CURRVAL,2766);
- 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);
- 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');
- 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');
- INSERT INTO vo_group_person (lm_comment,person_id,vo_group_id) VALUES ('PSI person group assignment for BM',seq_person_id.CURRVAL,2771);
- 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);
- 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');
- 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');
- INSERT INTO vo_group_person (lm_comment,person_id,vo_group_id) VALUES ('PSI person group assignment for BM',seq_person_id.CURRVAL,2772);
- 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);
- 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');
- 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');
- INSERT INTO vo_group_person (lm_comment,person_id,vo_group_id) VALUES ('PSI person group assignment for BM',seq_person_id.CURRVAL,2766);
- 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);
- 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');
- 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');
- INSERT INTO vo_group_person (lm_comment,person_id,vo_group_id) VALUES ('PSI person group assignment for BM',seq_person_id.CURRVAL,2761);
- 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);
- 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');
- 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');
- INSERT INTO vo_group_person (lm_comment,person_id,vo_group_id) VALUES ('PSI person group assignment for BM',seq_person_id.CURRVAL,2771);
- SELECT * FROM oc_poi
- ORDER BY 1 DESC;
- SELECT * FROM person
- ORDER BY 1 DESC;
- SELECT * FROM oc_poi
- WHERE poi_id = 999236;
- SELECT * FROM vo_group_person
- ORDER BY 2 DESC;
- SELECT * FROM vo_group
- WHERE vo_group_id = 2771;
- SELECT * FROM key_code
- ORDER BY 1 DESC;
- --begin
- -- p_poi.updateNoGeocodePoiCat(102002);
- --end;
- COMMIT;
- --ungeocoded POIs
- --ids -> 999227,999214,999205,999202,999201
- -- statement to see
- SELECT * FROM oc_poi
- WHERE WGS84_LATITUDE IS NULL
- AND WGS84_LONGITUDE IS NULL
- AND oc_poi_category_id = 102002
- AND lm_comment = 'PERSON LOAD PROCEDURE'
- ORDER BY 1 DESC;
Add Comment
Please, Sign In to add comment