API tools faq
paste
Advertisement
psi_mmobile

Untitled

psi_mmobile
Jan 8th, 2021
281
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 16.72 KB | None | 0 0
raw download clone embed print report
  1. 2021-01-08 10:26:17,744{Europe/Brussels} userId: 121747 ERROR [com.traxxeo.buildixx.model.views.DebuggableView] (http-thread-pool-8081(7)) JBO-27122: Erreur SQL lors de la préparation d'une instruction. Instruction : SELECT /*+ NOPARALLEL(PERSON) */ * FROM (select GUI_USER_ID, DISPLAY_NAME, COMPANY_NAME, PERSON_ID, VEHICLE_ID, POI_ID, FIXED_UNIT_ID, COMPANY_NR, SHORT_NAME, FIRST_NAME, LAST_NAME, VO_PERSON_CATEGORY_ID, CATEGORY_NAME, NUMBERPLATE, VO_VEHICLE_CATEGORY_ID, NAME, VEHICLE_NAME, OC_POI_CATEGORY_ID, OC_POI_STATUS_ID, SNAPPING_CIRCLE, CATEGORY_SNAPPING_CIRCLE, LINE_COLOR, FILL_COLOR, FILL_ALPHA, FLAG_COLOR, LINE_COLOR_DEF, FILL_COLOR_DEF, FILL_ALPHA_DEF, FLAG_COLOR_DEF, GEOM, IS_OBJECT, GRAPHICAL_SYMBOL, WGS84_LATITUDE, WGS84_LONGITUDE, HOME_WGS84_LATITUDE, HOME_WGS84_LONGITUDE, VEHICLE_DATA_RG_ADRESS, EVENT_ID, GPS_FULL_DATE, EVENT_DATE_STR, IGNITION, VEHICLE_DATA_SPEED, EVENT_TYPE, TOTAL_KM, TOTAL_HR, IS_CONTAINER, ID_STRING from (
  2. select
  3. gui.GUI_USER_ID as GUI_USER_ID,
  4. p.COMPANY_NR||' '||p.LAST_NAME||' '||p.FIRST_NAME as DISPLAY_NAME,
  5. vo.COMPANY_NAME,
  6. p.PERSON_ID as PERSON_ID,
  7. null as VEHICLE_ID,
  8. null as POI_ID,
  9. null as FIXED_UNIT_ID,
  10. p.COMPANY_NR as COMPANY_NR,
  11. null as SHORT_NAME,
  12. p.FIRST_NAME as FIRST_NAME,
  13. p.LAST_NAME as LAST_NAME,
  14. p.VO_PERSON_CATEGORY_ID as VO_PERSON_CATEGORY_ID,
  15. pc.name as CATEGORY_NAME,
  16. null as NUMBERPLATE,
  17. null as VO_VEHICLE_CATEGORY_ID,
  18. null as NAME,
  19. ltrim(rtrim(DECODE(v.company_nr, NULL, '', v.company_nr || ' - ') || v.numberplate)) VEHICLE_NAME,
  20. null as OC_POI_CATEGORY_ID,
  21. null as OC_POI_STATUS_ID,
  22. null as SNAPPING_CIRCLE,
  23. null as CATEGORY_SNAPPING_CIRCLE,
  24. null as LINE_COLOR,
  25. null as FILL_COLOR,
  26. null as FILL_ALPHA,
  27. null as FLAG_COLOR,
  28. null as LINE_COLOR_DEF,
  29. null as FILL_COLOR_DEF,
  30. null as FILL_ALPHA_DEF,
  31. null as FLAG_COLOR_DEF,
  32. null as GEOM,
  33. null as IS_OBJECT,
  34. pc.GRAPHICAL_SYMBOL as GRAPHICAL_SYMBOL,
  35. vd1.WGS84_LATITUDE as WGS84_LATITUDE,
  36. vd1.WGS84_LONGITUDE as WGS84_LONGITUDE,
  37. poi.WGS84_LATITUDE as HOME_WGS84_LATITUDE,
  38. poi.WGS84_LONGITUDE as HOME_WGS84_LONGITUDE,
  39. vd1.rg_street_nr || decode(vd1.rg_street_nr,null,'',', ') || vd1.rg_street || decode(vd1.rg_street,null,'',' - ') || vd1.rg_post_code || ' ' || vd1.rg_location || ' ' || vd1.rg_country VEHICLE_DATA_RG_ADRESS,
  40. vd1.VEHICLE_DATA_ID as EVENT_ID,
  41. vd1.GPS_FULL_DATE,
  42. to_char(touserdate(vd1.gps_full_date,oc.timezone),'dd/mm/yyyy HH24:MI') event_date_str,
  43. null as IGNITION,
  44. vd1.speed_over_ground VEHICLE_DATA_SPEED,
  45. str.str_value event_type,
  46. vd1.total_distance + nvl(v.ru_install_km,0) total_km,
  47. ROUND((p_util.to_num(vd1.hour_counter)+(NVL(v.ru_install_hr, 0)*3600))/36)/100 total_hr,
  48. null as IS_CONTAINER,
  49. upper(pc.NAME || ' ' || P_PERSON.list_person_group_name(p.PERSON_ID) || ' ' || p.COMPANY_NR || ' ' || p.LAST_NAME || ' ' || p.FIRST_NAME || ' ' || p.PHONE || ' ' || ps.NAME || ' ' || p.BIRTH_DATE || ' ' || p.EMAIL || ' ' || p.END_WORK_DATE || ' ' || p.GENDER || ' ' || p.MSISDN || ' ' || vd1.rg_street_nr || decode(vd1.rg_street_nr,null,'',', ') || vd1.rg_street || decode(vd1.rg_street,null,'',' - ') || vd1.rg_post_code || ' ' || vd1.rg_location || ' ' || vd1.rg_country || ' ' || P_PERSON.list_person_key_strings(p.PERSON_ID)) AS ID_STRING
  50. from PERSON p, PERSON_STATUS ps, VO_PERSON_CATEGORY pc, GUI_USERS gui, GU_PERSON gu, PERSON_DATA pd, event_type et, oc_event_type ocet, STR, OPERATION_CENTER oc, OC_POI poi, VEHICLE_OWNER vo, VEHICLE_DATA vd1, Vehicle v
  51. where gui.GUI_USER_ID = gu.GUI_USER_ID
  52. and p.PERSON_ID = gu.PERSON_id
  53. and p.PERSON_STATUS_ID = ps.PERSON_STATUS_ID
  54. and pc.VEHICLE_OWNER_ID = vo.VEHICLE_OWNER_ID
  55. and p.VO_PERSON_CATEGORY_ID = pc.VO_PERSON_CATEGORY_ID
  56. and p.HOME_POI_ID = poi.POI_ID
  57. and pd.PERSON_DATA_ID(+) = p.LAST_PERSON_DATA_ID
  58. and pd.VEHICLE_DATA_ID = vd1.VEHICLE_DATA_ID(+)
  59. and vd1.VEHICLE_ID = v.VEHICLE_ID(+)
  60. and vd1.event_type_id = et.event_type_id(+)
  61. and et.event_type_id = ocet.event_type_id(+)
  62. and ocet.operation_center_id = oc.operation_center_id(+)
  63. and ocet.str_id = str.str_id(+)
  64. and (gui.language = str.language or str.language is null)
  65. AND (p.PERSON_STATUS_ID = 0)
  66. and gui.operation_center_id = oc.operation_center_id
  67. and gui.GUI_USER_ID = ?
  68.  
  69. UNION ALL
  70.  
  71. select
  72. gu.GUI_USER_ID as GUI_USER_ID,
  73. v.COMPANY_NR||' '||v.NUMBERPLATE as DISPLAY_NAME,
  74. vo.COMPANY_NAME,
  75. null as PERSON_ID,
  76. v.VEHICLE_ID as VEHICLE_ID,
  77. null as POI_ID,
  78. null as FIXED_UNIT_ID,
  79. v.COMPANY_NR as COMPANY_NR,
  80. null as SHORT_NAME,
  81. p.FIRST_NAME as FIRST_NAME,
  82. p.LAST_NAME as LAST_NAME,
  83. null as VO_PERSON_CATEGORY_ID,
  84. vc.name as CATEGORY_NAME,
  85. v.NUMBERPLATE as NUMBERPLATE,
  86. v.VO_VEHICLE_CATEGORY_ID as VO_VEHICLE_CATEGORY_ID,
  87. null as NAME,
  88. vv.VEHICLE_NAME as VEHICLE_NAME,
  89. null as OC_POI_CATEGORY_ID,
  90. null as OC_POI_STATUS_ID,
  91. null as SNAPPING_CIRCLE,
  92. null as CATEGORY_SNAPPING_CIRCLE,
  93. null as LINE_COLOR,
  94. null as FILL_COLOR,
  95. null as FILL_ALPHA,
  96. null as FLAG_COLOR,
  97. null as LINE_COLOR_DEF,
  98. null as FILL_COLOR_DEF,
  99. null as FILL_ALPHA_DEF,
  100. null as FLAG_COLOR_DEF,
  101. null as GEOM,
  102. vc.IS_OBJECT,
  103. vc.GRAPHICAL_SYMBOL as GRAPHICAL_SYMBOL,
  104. vv.WGS84_LATITUDE as WGS84_LATITUDE,
  105. vv.WGS84_LONGITUDE as WGS84_LONGITUDE,
  106. null as HOME_WGS84_LATITUDE,
  107. null as HOME_WGS84_LONGITUDE,
  108. vv.VEHICLE_DATA_RG_ADRESS,
  109. vv.VEHICLE_DATA_ID as EVENT_ID,
  110. touserdate(vv.gps_full_date,oc.timezone) GPS_FULL_DATE,
  111. to_char(touserdate(vv.gps_full_date,oc.timezone),'dd/mm/yyyy HH24:MI') event_date_str,
  112. vv.IGNITION,
  113. vv.VEHICLE_DATA_SPEED,
  114. vv.EVENT_TYPE AS EVENT_TYPE,
  115. vv.VEHICLE_DATA_TOTAL_KM TOTAL_KM,
  116. vv.VEHICLE_DATA_TOTAL_HR TOTAL_HR,
  117. ru.IS_CONTAINER,
  118. upper(vc.NAME || ' ' || P_VEHICLE.list_vehicle_group_name(v.VEHICLE_ID)||' '||v.COMPANY_NR||' '||v.NUMBERPLATE||' '||v.BRAND||' '||v.MODEL||' '||v.COLOR || ' ' || vv.VEHICLE_DATA_RG_ADRESS||' '||v.LAST_USERS_CAT||' '||p.LAST_NAME||' '||p.FIRST_NAME||' '||v.LM_COMMENT||' '||v.LAST_USERS) as ID_STRING
  119. from VEHICLE v, VO_VEHICLE_CATEGORY vc, OPERATION_CENTER oc, GUI_USERS gui, GU_VEHICLE gu, V_FLEET_TRACKING vv, VEHICLE_OWNER vo, PERSON p, remote_unit ru
  120. where gui.GUI_USER_ID = gu.GUI_USER_ID and v.VEHICLE_ID = gu.VEHICLE_id and vc.VEHICLE_OWNER_ID = vo.VEHICLE_OWNER_ID and v.VO_VEHICLE_CATEGORY_ID = vc.VO_VEHICLE_CATEGORY_ID
  121.  
  122. and gui.OPERATION_CENTER_ID = oc.OPERATION_CENTER_ID
  123. and v.VEHICLE_ID = vv.VEHICLE_ID
  124. and v.person_id = p.person_id(+)
  125. and v.remote_unit_id = ru.remote_unit_id
  126. AND gui.GUI_USER_ID = vv.gui_user_id
  127. and gui.GUI_USER_ID = ?
  128.  
  129. UNION ALL
  130.  
  131. select
  132. p.GUI_USER_ID as GUI_USER_ID,
  133. p.NAME as DISPLAY_NAME,
  134. null as COMPANY_NAME,
  135. null as PERSON_ID,
  136. null as VEHICLE_ID,
  137. p.POI_ID as POI_ID,
  138. null as FIXED_UNIT_ID,
  139. null as COMPANY_NR,
  140. p.SHORT_NAME as SHORT_NAME,
  141. null as FIRST_NAME,
  142. null as LAST_NAME,
  143. null as VO_PERSON_CATEGORY_ID,
  144. pCat.name as CATEGORY_NAME,
  145. null as NUMBERPLATE,
  146. null as VO_VEHICLE_CATEGORY_ID,
  147. p.NAME as NAME,
  148. null as VEHICLE_NAME,
  149. p.OC_POI_CATEGORY_ID as OC_POI_CATEGORY_ID,
  150. p.OC_POI_STATUS_ID as OC_POI_STATUS_ID,
  151. p.SNAPPING_CIRCLE as SNAPPING_CIRCLE,
  152. p.SNAPPING_CIRCLE as CATEGORY_SNAPPING_CIRCLE,
  153. p.LINE_COLOR as LINE_COLOR,
  154. p.FILL_COLOR as FILL_COLOR,
  155. p.FILL_ALPHA as FILL_ALPHA,
  156. p.FLAG_COLOR as FLAG_COLOR,
  157. pCat.LINE_COLOR as LINE_COLOR_DEF,
  158. pCat.FILL_COLOR as FILL_COLOR_DEF,
  159. pCat.FILL_ALPHA as FILL_ALPHA_DEF,
  160. pCat.FLAG_COLOR as FLAG_COLOR_DEF,
  161. p.GEOM as GEOM,
  162. null as IS_OBJECT,
  163. pCat.GRAPHICAL_SYMBOL as GRAPHICAL_SYMBOL,
  164. p.WGS84_LATITUDE as WGS84_LATITUDE,
  165. p.WGS84_LONGITUDE as WGS84_LONGITUDE,
  166. null as HOME_WGS84_LATITUDE,
  167. null as HOME_WGS84_LONGITUDE,
  168. p.street_nr || decode(p.street_nr,null,'',', ') || p.street || decode(p.street,null,'',' - ') || p.post_code || ' ' || p.location || ' ' || p.country as VEHICLE_DATA_RG_ADRESS,
  169. null as EVENT_ID,
  170. null as GPS_FULL_DATE,
  171. null as EVENT_DATE_STR,
  172. null as IGNITION,
  173. null as VEHICLE_DATA_SPEED,
  174. null as EVENT_TYPE,
  175. null as TOTAL_KM,
  176. null as TOTAL_HR,
  177. null as IS_CONTAINER,
  178. p.NAME || p.LOCATION || p.POST_CODE || p.STREET || p.COUNTRY || p.STREET_NR || p.SHORT_NAME || p.CONTACT_FIRST_NAME || p.CONTACT_LAST_NAME || p.CONTACT_PHONE as ID_STRING
  179. from OC_POI_CATEGORY pCat, V_GUI_USER_OC_POI p
  180. where p.OC_POI_CATEGORY_ID = pCat.OC_POI_CATEGORY_ID
  181. AND (p.OC_POI_STATUS_ID in (0,3))
  182. and p.GUI_USER_ID = ?)) QRSLT WHERE (ID_STRING like '%DE NICOLO%') ORDER BY vo_person_category_id,last_name, first_name,vo_vehicle_category_id,oc_poi_category_id,name DebuggableView.executeQueryForCollection name= BuildixxMapsSearchView1
  183. 2021-01-08 10:26:17,744{Europe/Brussels} userId: 121747 ERROR [com.traxxeo.buildixx.model.views.DebuggableView] (http-thread-pool-8081(7)) QUERY:SELECT /*+ NOPARALLEL(PERSON) */ * FROM (select GUI_USER_ID, DISPLAY_NAME, COMPANY_NAME, PERSON_ID, VEHICLE_ID, POI_ID, FIXED_UNIT_ID, COMPANY_NR, SHORT_NAME, FIRST_NAME, LAST_NAME, VO_PERSON_CATEGORY_ID, CATEGORY_NAME, NUMBERPLATE, VO_VEHICLE_CATEGORY_ID, NAME, VEHICLE_NAME, OC_POI_CATEGORY_ID, OC_POI_STATUS_ID, SNAPPING_CIRCLE, CATEGORY_SNAPPING_CIRCLE, LINE_COLOR, FILL_COLOR, FILL_ALPHA, FLAG_COLOR, LINE_COLOR_DEF, FILL_COLOR_DEF, FILL_ALPHA_DEF, FLAG_COLOR_DEF, GEOM, IS_OBJECT, GRAPHICAL_SYMBOL, WGS84_LATITUDE, WGS84_LONGITUDE, HOME_WGS84_LATITUDE, HOME_WGS84_LONGITUDE, VEHICLE_DATA_RG_ADRESS, EVENT_ID, GPS_FULL_DATE, EVENT_DATE_STR, IGNITION, VEHICLE_DATA_SPEED, EVENT_TYPE, TOTAL_KM, TOTAL_HR, IS_CONTAINER, ID_STRING from (
  184. select
  185. gui.GUI_USER_ID as GUI_USER_ID,
  186. p.COMPANY_NR||' '||p.LAST_NAME||' '||p.FIRST_NAME as DISPLAY_NAME,
  187. vo.COMPANY_NAME,
  188. p.PERSON_ID as PERSON_ID,
  189. null as VEHICLE_ID,
  190. null as POI_ID,
  191. null as FIXED_UNIT_ID,
  192. p.COMPANY_NR as COMPANY_NR,
  193. null as SHORT_NAME,
  194. p.FIRST_NAME as FIRST_NAME,
  195. p.LAST_NAME as LAST_NAME,
  196. p.VO_PERSON_CATEGORY_ID as VO_PERSON_CATEGORY_ID,
  197. pc.name as CATEGORY_NAME,
  198. null as NUMBERPLATE,
  199. null as VO_VEHICLE_CATEGORY_ID,
  200. null as NAME,
  201. ltrim(rtrim(DECODE(v.company_nr, NULL, '', v.company_nr || ' - ') || v.numberplate)) VEHICLE_NAME,
  202. null as OC_POI_CATEGORY_ID,
  203. null as OC_POI_STATUS_ID,
  204. null as SNAPPING_CIRCLE,
  205. null as CATEGORY_SNAPPING_CIRCLE,
  206. null as LINE_COLOR,
  207. null as FILL_COLOR,
  208. null as FILL_ALPHA,
  209. null as FLAG_COLOR,
  210. null as LINE_COLOR_DEF,
  211. null as FILL_COLOR_DEF,
  212. null as FILL_ALPHA_DEF,
  213. null as FLAG_COLOR_DEF,
  214. null as GEOM,
  215. null as IS_OBJECT,
  216. pc.GRAPHICAL_SYMBOL as GRAPHICAL_SYMBOL,
  217. vd1.WGS84_LATITUDE as WGS84_LATITUDE,
  218. vd1.WGS84_LONGITUDE as WGS84_LONGITUDE,
  219. poi.WGS84_LATITUDE as HOME_WGS84_LATITUDE,
  220. poi.WGS84_LONGITUDE as HOME_WGS84_LONGITUDE,
  221. vd1.rg_street_nr || decode(vd1.rg_street_nr,null,'',', ') || vd1.rg_street || decode(vd1.rg_street,null,'',' - ') || vd1.rg_post_code || ' ' || vd1.rg_location || ' ' || vd1.rg_country VEHICLE_DATA_RG_ADRESS,
  222. vd1.VEHICLE_DATA_ID as EVENT_ID,
  223. vd1.GPS_FULL_DATE,
  224. to_char(touserdate(vd1.gps_full_date,oc.timezone),'dd/mm/yyyy HH24:MI') event_date_str,
  225. null as IGNITION,
  226. vd1.speed_over_ground VEHICLE_DATA_SPEED,
  227. str.str_value event_type,
  228. vd1.total_distance + nvl(v.ru_install_km,0) total_km,
  229. ROUND((p_util.to_num(vd1.hour_counter)+(NVL(v.ru_install_hr, 0)*3600))/36)/100 total_hr,
  230. null as IS_CONTAINER,
  231. upper(pc.NAME || ' ' || P_PERSON.list_person_group_name(p.PERSON_ID) || ' ' || p.COMPANY_NR || ' ' || p.LAST_NAME || ' ' || p.FIRST_NAME || ' ' || p.PHONE || ' ' || ps.NAME || ' ' || p.BIRTH_DATE || ' ' || p.EMAIL || ' ' || p.END_WORK_DATE || ' ' || p.GENDER || ' ' || p.MSISDN || ' ' || vd1.rg_street_nr || decode(vd1.rg_street_nr,null,'',', ') || vd1.rg_street || decode(vd1.rg_street,null,'',' - ') || vd1.rg_post_code || ' ' || vd1.rg_location || ' ' || vd1.rg_country || ' ' || P_PERSON.list_person_key_strings(p.PERSON_ID)) AS ID_STRING
  232. from PERSON p, PERSON_STATUS ps, VO_PERSON_CATEGORY pc, GUI_USERS gui, GU_PERSON gu, PERSON_DATA pd, event_type et, oc_event_type ocet, STR, OPERATION_CENTER oc, OC_POI poi, VEHICLE_OWNER vo, VEHICLE_DATA vd1, Vehicle v
  233. where gui.GUI_USER_ID = gu.GUI_USER_ID
  234. and p.PERSON_ID = gu.PERSON_id
  235. and p.PERSON_STATUS_ID = ps.PERSON_STATUS_ID
  236. and pc.VEHICLE_OWNER_ID = vo.VEHICLE_OWNER_ID
  237. and p.VO_PERSON_CATEGORY_ID = pc.VO_PERSON_CATEGORY_ID
  238. and p.HOME_POI_ID = poi.POI_ID
  239. and pd.PERSON_DATA_ID(+) = p.LAST_PERSON_DATA_ID
  240. and pd.VEHICLE_DATA_ID = vd1.VEHICLE_DATA_ID(+)
  241. and vd1.VEHICLE_ID = v.VEHICLE_ID(+)
  242. and vd1.event_type_id = et.event_type_id(+)
  243. and et.event_type_id = ocet.event_type_id(+)
  244. and ocet.operation_center_id = oc.operation_center_id(+)
  245. and ocet.str_id = str.str_id(+)
  246. and (gui.language = str.language or str.language is null)
  247. AND (p.PERSON_STATUS_ID = 0)
  248. and gui.operation_center_id = oc.operation_center_id
  249. and gui.GUI_USER_ID = ?
  250.  
  251. UNION ALL
  252.  
  253. select
  254. gu.GUI_USER_ID as GUI_USER_ID,
  255. v.COMPANY_NR||' '||v.NUMBERPLATE as DISPLAY_NAME,
  256. vo.COMPANY_NAME,
  257. null as PERSON_ID,
  258. v.VEHICLE_ID as VEHICLE_ID,
  259. null as POI_ID,
  260. null as FIXED_UNIT_ID,
  261. v.COMPANY_NR as COMPANY_NR,
  262. null as SHORT_NAME,
  263. p.FIRST_NAME as FIRST_NAME,
  264. p.LAST_NAME as LAST_NAME,
  265. null as VO_PERSON_CATEGORY_ID,
  266. vc.name as CATEGORY_NAME,
  267. v.NUMBERPLATE as NUMBERPLATE,
  268. v.VO_VEHICLE_CATEGORY_ID as VO_VEHICLE_CATEGORY_ID,
  269. null as NAME,
  270. vv.VEHICLE_NAME as VEHICLE_NAME,
  271. null as OC_POI_CATEGORY_ID,
  272. null as OC_POI_STATUS_ID,
  273. null as SNAPPING_CIRCLE,
  274. null as CATEGORY_SNAPPING_CIRCLE,
  275. null as LINE_COLOR,
  276. null as FILL_COLOR,
  277. null as FILL_ALPHA,
  278. null as FLAG_COLOR,
  279. null as LINE_COLOR_DEF,
  280. null as FILL_COLOR_DEF,
  281. null as FILL_ALPHA_DEF,
  282. null as FLAG_COLOR_DEF,
  283. null as GEOM,
  284. vc.IS_OBJECT,
  285. vc.GRAPHICAL_SYMBOL as GRAPHICAL_SYMBOL,
  286. vv.WGS84_LATITUDE as WGS84_LATITUDE,
  287. vv.WGS84_LONGITUDE as WGS84_LONGITUDE,
  288. null as HOME_WGS84_LATITUDE,
  289. null as HOME_WGS84_LONGITUDE,
  290. vv.VEHICLE_DATA_RG_ADRESS,
  291. vv.VEHICLE_DATA_ID as EVENT_ID,
  292. touserdate(vv.gps_full_date,oc.timezone) GPS_FULL_DATE,
  293. to_char(touserdate(vv.gps_full_date,oc.timezone),'dd/mm/yyyy HH24:MI') event_date_str,
  294. vv.IGNITION,
  295. vv.VEHICLE_DATA_SPEED,
  296. vv.EVENT_TYPE AS EVENT_TYPE,
  297. vv.VEHICLE_DATA_TOTAL_KM TOTAL_KM,
  298. vv.VEHICLE_DATA_TOTAL_HR TOTAL_HR,
  299. ru.IS_CONTAINER,
  300. upper(vc.NAME || ' ' || P_VEHICLE.list_vehicle_group_name(v.VEHICLE_ID)||' '||v.COMPANY_NR||' '||v.NUMBERPLATE||' '||v.BRAND||' '||v.MODEL||' '||v.COLOR || ' ' || vv.VEHICLE_DATA_RG_ADRESS||' '||v.LAST_USERS_CAT||' '||p.LAST_NAME||' '||p.FIRST_NAME||' '||v.LM_COMMENT||' '||v.LAST_USERS) as ID_STRING
  301. from VEHICLE v, VO_VEHICLE_CATEGORY vc, OPERATION_CENTER oc, GUI_USERS gui, GU_VEHICLE gu, V_FLEET_TRACKING vv, VEHICLE_OWNER vo, PERSON p, remote_unit ru
  302. where gui.GUI_USER_ID = gu.GUI_USER_ID and v.VEHICLE_ID = gu.VEHICLE_id and vc.VEHICLE_OWNER_ID = vo.VEHICLE_OWNER_ID and v.VO_VEHICLE_CATEGORY_ID = vc.VO_VEHICLE_CATEGORY_ID
  303.  
  304. and gui.OPERATION_CENTER_ID = oc.OPERATION_CENTER_ID
  305. and v.VEHICLE_ID = vv.VEHICLE_ID
  306. and v.person_id = p.person_id(+)
  307. and v.remote_unit_id = ru.remote_unit_id
  308. AND gui.GUI_USER_ID = vv.gui_user_id
  309. and gui.GUI_USER_ID = ?
  310.  
  311. UNION ALL
  312.  
  313. select
  314. p.GUI_USER_ID as GUI_USER_ID,
  315. p.NAME as DISPLAY_NAME,
  316. null as COMPANY_NAME,
  317. null as PERSON_ID,
  318. null as VEHICLE_ID,
  319. p.POI_ID as POI_ID,
  320. null as FIXED_UNIT_ID,
  321. null as COMPANY_NR,
  322. p.SHORT_NAME as SHORT_NAME,
  323. null as FIRST_NAME,
  324. null as LAST_NAME,
  325. null as VO_PERSON_CATEGORY_ID,
  326. pCat.name as CATEGORY_NAME,
  327. null as NUMBERPLATE,
  328. null as VO_VEHICLE_CATEGORY_ID,
  329. p.NAME as NAME,
  330. null as VEHICLE_NAME,
  331. p.OC_POI_CATEGORY_ID as OC_POI_CATEGORY_ID,
  332. p.OC_POI_STATUS_ID as OC_POI_STATUS_ID,
  333. p.SNAPPING_CIRCLE as SNAPPING_CIRCLE,
  334. p.SNAPPING_CIRCLE as CATEGORY_SNAPPING_CIRCLE,
  335. p.LINE_COLOR as LINE_COLOR,
  336. p.FILL_COLOR as FILL_COLOR,
  337. p.FILL_ALPHA as FILL_ALPHA,
  338. p.FLAG_COLOR as FLAG_COLOR,
  339. pCat.LINE_COLOR as LINE_COLOR_DEF,
  340. pCat.FILL_COLOR as FILL_COLOR_DEF,
  341. pCat.FILL_ALPHA as FILL_ALPHA_DEF,
  342. pCat.FLAG_COLOR as FLAG_COLOR_DEF,
  343. p.GEOM as GEOM,
  344. null as IS_OBJECT,
  345. pCat.GRAPHICAL_SYMBOL as GRAPHICAL_SYMBOL,
  346. p.WGS84_LATITUDE as WGS84_LATITUDE,
  347. p.WGS84_LONGITUDE as WGS84_LONGITUDE,
  348. null as HOME_WGS84_LATITUDE,
  349. null as HOME_WGS84_LONGITUDE,
  350. p.street_nr || decode(p.street_nr,null,'',', ') || p.street || decode(p.street,null,'',' - ') || p.post_code || ' ' || p.location || ' ' || p.country as VEHICLE_DATA_RG_ADRESS,
  351. null as EVENT_ID,
  352. null as GPS_FULL_DATE,
  353. null as EVENT_DATE_STR,
  354. null as IGNITION,
  355. null as VEHICLE_DATA_SPEED,
  356. null as EVENT_TYPE,
  357. null as TOTAL_KM,
  358. null as TOTAL_HR,
  359. null as IS_CONTAINER,
  360. p.NAME || p.LOCATION || p.POST_CODE || p.STREET || p.COUNTRY || p.STREET_NR || p.SHORT_NAME || p.CONTACT_FIRST_NAME || p.CONTACT_LAST_NAME || p.CONTACT_PHONE as ID_STRING
  361. from OC_POI_CATEGORY pCat, V_GUI_USER_OC_POI p
  362. where p.OC_POI_CATEGORY_ID = pCat.OC_POI_CATEGORY_ID
  363. AND (p.OC_POI_STATUS_ID in (0,3))
  364. and p.GUI_USER_ID = ?)) QRSLT WHERE (ID_STRING like '%DE NICOLO%') ORDER BY vo_person_category_id,last_name, first_name,vo_vehicle_category_id,oc_poi_category_id,name
  365. 2021-01-08 10:26:18,396{Europe/Brussels} userId: 121747 DEBUG [com.traxxeo.buildixx.view.backing.location.search.GoogleSearch] (http-thread-pool-8081(7)) Request status :
  366. 43.4087385
  367. -86.3480888
  368. South Mears Avenue
  369. 124
  370. 49461
  371. Whitehall
  372. US
  373.  
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!