Advertisement
psi_mmobile

Untitled

Sep 14th, 2022
1,847
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 41.05 KB | None | 0 0
  1. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='903' WHERE company_nr='903' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='ANCORA MARIO';
  2. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='904' WHERE company_nr='904' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='CALET JEROME';
  3. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='905' WHERE company_nr='905' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='WERKMULLER RALPH';
  4. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='906' WHERE company_nr='906' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='HENRY MORGANE';
  5. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='908' WHERE company_nr='908' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='MORCRETTE STEPHANE';
  6. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='909' WHERE company_nr='909' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='NEIRYNCK ANDY';
  7. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='910' WHERE company_nr='910' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='DURENNE ERIC';
  8. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='911' WHERE company_nr='911' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='SAIL BERTRAND';
  9. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='912' WHERE company_nr='912' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='BLANCHARD POL';
  10. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='915' WHERE company_nr='915' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='VAN DEN STEEN TOM';
  11. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='917' WHERE company_nr='917' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='DE NEVE FRANK';
  12. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='918' WHERE company_nr='918' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='VANESSE DIMITRI';
  13. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='919' WHERE company_nr='919' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='INGRAO MAGDALENA';
  14. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='922' WHERE company_nr='922' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='DE SAEDELEER WESLEY';
  15. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='924' WHERE company_nr='924' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='LAURENT XAVIER';
  16. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='929' WHERE company_nr='929' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='AGELOF CHRISTOPHE';
  17. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='931' WHERE company_nr='931' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='DRUART XAVIER';
  18. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='935' WHERE company_nr='935' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='BEN BRAHIM KARIM';
  19. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='936' WHERE company_nr='936' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='GONZALEZ-VARGAS MICHEL';
  20. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='941' WHERE company_nr='941' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='DEWASMES XAVIER';
  21. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='945' WHERE company_nr='945' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='HENROTTE FRANCOIS';
  22. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='950' WHERE company_nr='950' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='CURTO SILVIO';
  23. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='955' WHERE company_nr='955' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='MOREAU WINDY';
  24. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='960' WHERE company_nr='960' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='RINI EMILY';
  25. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='962' WHERE company_nr='962' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='SEGGIO GIOVANNI';
  26. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='966' WHERE company_nr='966' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='VAN LANDSCHOOT MARIE';
  27. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='967' WHERE company_nr='967' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='DURANT SEBASTIEN';
  28. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='968' WHERE company_nr='968' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='VAN DORLAND ARJAN';
  29. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='969' WHERE company_nr='969' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='FRANCK EMMANUEL';
  30. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='971' WHERE company_nr='971' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='THIRIFAY DAMIEN';
  31. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='973' WHERE company_nr='973' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='SAUSSEZ DEBORAH';
  32. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='974' WHERE company_nr='974' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='CLEMENTE ROCCO';
  33. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='976' WHERE company_nr='976' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='JOLY PATRICK';
  34. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='977' WHERE company_nr='977' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='DE BAKKER TOM';
  35. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='978' WHERE company_nr='978' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='VANSNICK PAUL';
  36. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='980' WHERE company_nr='980' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='CROMPOT PASCAL';
  37. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='981' WHERE company_nr='981' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='CHABOUX DAVID';
  38. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='982' WHERE company_nr='982' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='HERREGODS LISIANE';
  39. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='986' WHERE company_nr='986' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='DRUART BRUNO';
  40. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='987' WHERE company_nr='987' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='LASSOIE JONATHAN';
  41. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='988' WHERE company_nr='988' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='ZAMBELLI GRÉGORY';
  42. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='989' WHERE company_nr='989' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='SERBRUYNS BRUNO';
  43. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='990' WHERE company_nr='990' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='GERARD MATHIEU';
  44. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='993' WHERE company_nr='993' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='VERMEIR DAVY';
  45. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='994' WHERE company_nr='994' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='MAJ JEAN-CHRISTOPHE';
  46. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='E00' WHERE company_nr='1000' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='LEURQUIN GEOFFREY';
  47. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='E01' WHERE company_nr='1001' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='LELEU CEDRIC';
  48. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='E05' WHERE company_nr='1005' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='ROSSEL KOBE';
  49. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='E07' WHERE company_nr='1007' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='MELIS STEFAAN';
  50. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='E08' WHERE company_nr='1008' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='BULTOT LUC';
  51. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='E09' WHERE company_nr='1009' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='BODSON SEBASTIEN';
  52. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='E10' WHERE company_nr='1010' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='PARIDAENS CHRISTOPHE';
  53. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='E11' WHERE company_nr='1011' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='DE MONCEAU NICOLAS';
  54. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='E16' WHERE company_nr='1016' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='VAN DORLAND STEFAN';
  55. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='E24' WHERE company_nr='1024' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='BEERENS JONATHAN';
  56. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='E25' WHERE company_nr='1025' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='PERSYN ELODIE';
  57. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='E27' WHERE company_nr='1027' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='CONTI VINCENT';
  58. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='E28' WHERE company_nr='1028' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='CLOSE JORDAN';
  59. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='E30' WHERE company_nr='1030' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='VANDERSTRAETEN PETER';
  60. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='E31' WHERE company_nr='1031' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='NELLES PATRICK';
  61. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='E32' WHERE company_nr='1032' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='WOUTERS JO';
  62. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='E33' WHERE company_nr='1033' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='DEFERNEZ ARNAUD';
  63. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='E35' WHERE company_nr='1035' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='HASSELLE ZAKARIA';
  64. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='E36' WHERE company_nr='1036' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='VAN CAUTER TIM';
  65. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='E37' WHERE company_nr='1037' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='GOVAERT STIJN';
  66. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='E39' WHERE company_nr='1039' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='OGNIBENE FRANCA';
  67. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='E43' WHERE company_nr='1043' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='DE VOS BRUNO';
  68. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='E44' WHERE company_nr='1044' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='JULIEN MARTIN';
  69. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='E45' WHERE company_nr='1045' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='VOLON ARNAUD';
  70. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='E51' WHERE company_nr='1051' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='DE MUNCK THOMAS';
  71. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='E53' WHERE company_nr='1053' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='DE BACKER SOFIE';
  72. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='E55' WHERE company_nr='1055' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='CAMMARATA KENNETH';
  73. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='E57' WHERE company_nr='1057' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='COREMANS LUC';
  74. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='E59' WHERE company_nr='1059' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='SOBRY JEAN-DENIS';
  75. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='E61' WHERE company_nr='1061' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='DE FEYTER MARLEEN';
  76. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='E62' WHERE company_nr='1062' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='JANSSENS OLIVIER';
  77. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='E64' WHERE company_nr='1064' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='PARSER MARC-EMMANUEL';
  78. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='E66' WHERE company_nr='1066' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='MATTIVI LAURENCE';
  79. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='E67' WHERE company_nr='1067' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='BEAUFAYS LAURENT';
  80. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='E68' WHERE company_nr='1068' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='MOUTON JEROME';
  81. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='E69' WHERE company_nr='1069' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='CATOIR SULLYVAN';
  82. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='E70' WHERE company_nr='1070' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='DE ROECK PIETER';
  83. --update person set lm_name='TRAXXEO Admin',lm_date=sysdate,erp_company_code='E73' where company_nr='1073' and person_status_id=0 and vo_person_category_id in (select vo_person_category_id from vo_person_category where vehicle_owner_id=100603) and upper(trim(last_name) || ' ' || trim(first_name))='PETILLON GWENAELE';
  84. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='E74' WHERE company_nr='1074' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='LEQUARRE BERTRAND';
  85. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='E76' WHERE company_nr='1076' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='MARIEN PETER';
  86. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='E78' WHERE company_nr='1078' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='LEVEAU QUENTIN';
  87. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='E79' WHERE company_nr='1079' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='DE WANNEMAEKER HANS';
  88. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='E80' WHERE company_nr='1080' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='CAUDRON YVES';
  89. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='E81' WHERE company_nr='1081' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='DELIEGE CORALIE';
  90. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='E83' WHERE company_nr='1083' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='COOREVITS TIM';
  91. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='E85' WHERE company_nr='1085' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='DAEM JOLIEN';
  92. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='E86' WHERE company_nr='1086' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='BOZDAG ABDURRAHMAN';
  93. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='E87' WHERE company_nr='1087' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='DE BISSCHOP SAM';
  94. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='E89' WHERE company_nr='1089' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='MICHOT PACAL';
  95. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='E90' WHERE company_nr='1090' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='LESAGE PATRICK';
  96. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='1091' WHERE company_nr='1091' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='CAUSHAJ DARIO';
  97. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='E92' WHERE company_nr='1092' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='FILIPOZZI ALESSIO';
  98. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='1093' WHERE company_nr='1093' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='DE BOECK SAARTJE';
  99. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='1094' WHERE company_nr='1094' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='LOISEAU LAURENT';
  100. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='1096' WHERE company_nr='1096' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='CORNEZ QUENTIN';
  101. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='1097' WHERE company_nr='1097' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='VANDERSMISSEN NATACHA';
  102. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='1098' WHERE company_nr='1098' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='MIHAI IONUT';
  103. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='1099' WHERE company_nr='1099' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='BODEUX AMAURY';
  104. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='1100' WHERE company_nr='1100' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='MICHIELS GAËTAN';
  105. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='1101' WHERE company_nr='1101' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='CRELOT NICOLAS';
  106. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='1103' WHERE company_nr='1103' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='MANNARINO GINO';
  107. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='1104' WHERE company_nr='1104' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='GERARD BENOIT';
  108. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='1105' WHERE company_nr='1105' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='HERBINIAUX FLORENT';
  109. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='1106' WHERE company_nr='1106' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='HARMOUCH AHMAD';
  110. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='1107' WHERE company_nr='1107' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='PATERNOSTRE STANISLAS';
  111. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='1108' WHERE company_nr='1108' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='MEGANCK MARIO';
  112. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='1109' WHERE company_nr='1109' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='SOUBATI OMAR';
  113. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='1110' WHERE company_nr='1110' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='LORETTE MATHILDE';
  114. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='1111' WHERE company_nr='1111' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='BORREY ANTOINE';
  115. --update person set lm_name='TRAXXEO Admin',lm_date=sysdate,erp_company_code='1112' where company_nr='1112' and person_status_id=0 and vo_person_category_id in (select vo_person_category_id from vo_person_category where vehicle_owner_id=100603) and upper(trim(last_name) || ' ' || trim(first_name))='PEETERS WARD';
  116. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='1113' WHERE company_nr='1113' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='DUPUIS SÉBASTIEN';
  117. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='1114' WHERE company_nr='1114' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='THIRY OLIVIER';
  118. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='1115' WHERE company_nr='1115' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='DE VIDTS FILIP';
  119. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='1118' WHERE company_nr='1118' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='BAIDOURI HAKIM';
  120. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='1119' WHERE company_nr='1119' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='BAGIU RALUCA';
  121. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='1120' WHERE company_nr='1120' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='VANDEN BROUCKE NATHAN';
  122. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='P1911' WHERE company_nr='P1911' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='GRANDJEAN PATRICK';
  123. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='P1936' WHERE company_nr='P1936' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='VANBREUSEGEM MATTHIEU';
  124. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='P1954' WHERE company_nr='P1954' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='GOBERT ISABELLE';
  125. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='P1943' WHERE company_nr='P1943' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='HOUDE CHRISTOPHE';
  126. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='P1944' WHERE company_nr='P1944' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='RULLENS CORENTIN';
  127. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='P1946' WHERE company_nr='P1946' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='PINON MARK PHILIPP';
  128. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='P1948' WHERE company_nr='P1948' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND TRIM(UPPER(TRIM(last_name) || ' ' || TRIM(first_name)))='KOTTGEN';
  129. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='P1949' WHERE company_nr='P1949' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='LEFEBVRE MAXIME';
  130. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='P1951' WHERE company_nr='P1951' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='FAVEAUX FREDERIC';
  131. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='P1952' WHERE company_nr='P1952' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='LOURHMATI ABDEL';
  132. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='P1953' WHERE company_nr='P1953' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='POIRRIER JEAN-CLAUDE';
  133. UPDATE person SET lm_name='TRAXXEO Admin',lm_date=SYSDATE,erp_company_code='P1955' WHERE company_nr='P1955' AND person_status_id=0 AND vo_person_category_id IN (SELECT vo_person_category_id FROM vo_person_category WHERE vehicle_owner_id=100603) AND UPPER(TRIM(last_name) || ' ' || TRIM(first_name))='VAN DE POELE THOMAS';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement