API tools faq
paste
Advertisement
psi_mmobile

Untitled

psi_mmobile
Sep 14th, 2022
1,798
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 41.05 KB | None | 0 0
raw download clone embed print report
  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
Public Pastes
Advertisement
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!