psi_mmobile

Untitled

Mar 17th, 2026
90
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 5.29 KB | None | 0 0
  1. SELECT VFmxVdPoiDay.VD_POI_DAY_ID,
  2. VFmxVdPoiDay.VEHICLE_ID,
  3. VFmxVdPoiDay.POI_ID,
  4. VFmxVdPoiDay.DATE_DAY,
  5. VFmxVdPoiDay.SNAPPING_STATUS,
  6. VFmxVdPoiDay.DAY_FIRST_START_KM,
  7. VFmxVdPoiDay.POI_FIRST_EVENT_KM,
  8. VFmxVdPoiDay.POI_LAST_EVENT_KM,
  9. VFmxVdPoiDay.DAY_LAST_STOP_KM,
  10. VFmxVdPoiDay.VEHICLE_NAME,
  11. VFmxVdPoiDay.OPERATION_CENTER_ID,
  12. VFmxVdPoiDay.OPC_NAME,
  13. VFmxVdPoiDay.OPC_GRAPHICAL_SYMBOL,
  14. VFmxVdPoiDay.POI_NAME,
  15. VFmxVdPoiDay.POI_GRAPHICAL_SYMBOL,
  16. VFmxVdPoiDay.LOCATION,
  17. VFmxVdPoiDay.COUNTRY,
  18. VFmxVdPoiDay.POST_CODE,
  19. VFmxVdPoiDay.STREET,
  20. VFmxVdPoiDay.STREET_NR,
  21. VFmxVdPoiDay.OC_AGGREG_ADMIN_STATUS_ID,
  22. VFmxVdPoiDay.OC_POI_CATEGORY_ID,
  23. VFmxVdPoiDay.SNAPPING_COMMENT,
  24. VFmxVdPoiDay.IS_MODIFIED_BY_USER,
  25. VFmxVdPoiDay.LM_DATE,
  26. VFmxVdPoiDay.DAY_NBR_VISIT,
  27. VFmxVdPoiDay.POI_NBR_VISIT,
  28. VFmxVdPoiDay.POI_KM,
  29. VFmxVdPoiDay.DAY_DURATION,
  30. VFmxVdPoiDay.POI_DURATION,
  31. VFmxVdPoiDay.POI_SPENT_DURATION,
  32. VFmxVdPoiDay.DAY_KM,
  33. VFmxVdPoiDay.DAY_FIRST_START_HR,
  34. VFmxVdPoiDay.DAY_LAST_STOP_HR,
  35. VFmxVdPoiDay.POI_FIRST_EVENT_HR,
  36. VFmxVdPoiDay.POI_LAST_EVENT_HR,
  37. VFmxVdPoiDay.POI_HR,
  38. VFmxVdPoiDay.POI_HR_EXTRA,
  39. VFmxVdPoiDay.DAY_HR,
  40. VFmxVdPoiDay.DAY_SPEED,
  41. VFmxVdPoiDay.VEHICLE_OWNER_ID,
  42. VFmxVdPoiDay.VO_VEHICLE_CATEGORY_ID,
  43. VFmxVdPoiDay.STATUS_NAME,
  44. VFmxVdPoiDay.FLAG_COLOUR,
  45. VFmxVdPoiDay.CAL_COLOUR,
  46. VFmxVdPoiDay.POI_KM_EXTRA,
  47. VFmxVdPoiDay.NBR_DAY,
  48. VFmxVdPoiDay.VEHICLE_CATEGORY_NAME,
  49. VFmxVdPoiDay.OC_DAY_AGGREG_ID,
  50. to_number(DAY_SPEED) AS DAY_SPEED_NUM,
  51. upper(VFmxVdPoiDay.VEHICLE_NAME||' '||VFmxVdPoiDay.DRIVER_PERSON_NAME||' '||VFmxVdPoiDay.STATUS_NAME||' '||VFmxVdPoiDay.POI_NAME||' '||VFmxVdPoiDay.WBS_NAME||' '||VFmxVdPoiDay.DATE_DAY||' '||OperationMode.SHORT_NAME||' '||OperationMode.NAME|| ' '||VFmxVdPoiDay.ALERT_DESCRIPTION||' '||VFmxVdPoiDay.ALERT_NAME||' '||VFmxVdPoiDay.BRAND||' '||VFmxVdPoiDay.CATEGORY_NAME||' '||VFmxVdPoiDay.FILE_PATH||' '||VFmxVdPoiDay.INVOICED_LINE||' '||VFmxVdPoiDay.LAST_DAY_KEY_PERSON_NAME||' '||VFmxVdPoiDay.MODEL||' '||VFmxVdPoiDay.OPC_NAME||' '||VFmxVdPoiDay.REF_NUMBER||' '||VFmxVdPoiDay.SNAPPING_COMMENT||' '||VFmxVdPoiDay.STATUS_NAME||' '||VFmxVdPoiDay.VEHICLE_CATEGORY_NAME) AS IDSTRING,
  52. VFmxVdPoiDay.LAST_DAY_KEY_PERSON_NAME,
  53. VFmxVdPoiDay.WBS_ID,
  54. VFmxVdPoiDay.WBS_NAME,
  55. OcDayAggreg.OC_CALENDAR_ID,
  56. OcDayAggreg.OC_DAY_AGGREG_ID AS OC_DAY_AGGREG_ID1,
  57. VFmxVdPoiDay.IS_LOCKED,
  58. VFmxVdPoiDay.INVOICED_LINE,
  59. VFmxVdPoiDay.DRIVER_ID,
  60. VFmxVdPoiDay.IS_WORKING_DAY,
  61. VFmxVdPoiDay.REF_NUMBER,
  62. decode(OperationMode.short_name,'NW','#223c4a','CO','#f75414','') AS OM_COLOR,
  63. OperationMode.NAME AS OM_NAME,
  64. OperationMode.SHORT_NAME AS OM_SHORT_NAME,
  65. OperationMode.OPERATION_MODE_ID,
  66. (VFmxVdPoiDay.DRIVER_PERSON_NAME) AS VIEW_ATTR,
  67. VFmxVdPoiDay.DAY_NBR_KEY,
  68. VFmxVdPoiDay.MAX_NBR_PERSONS,
  69. VFmxVdPoiDay.DAY_FIRST_START_TIME AS DAY_FIRST_START_TIME1,
  70. VFmxVdPoiDay.DAY_LAST_STOP_TIME AS DAY_LAST_STOP_TIME1,
  71. VFmxVdPoiDay.POI_FIRST_EVENT_TIME AS POI_FIRST_EVENT_TIME1,
  72. VFmxVdPoiDay.POI_LAST_EVENT_TIME AS POI_LAST_EVENT_TIME1,
  73. VFmxVdPoiDay.MD_FUEL,
  74. VFmxVdPoiDay.MD_IDLE_HR,
  75. VFmxVdPoiDay.MD_IDLE_RATE,
  76. VFmxVdPoiDay.MD_TOTAL_HR,
  77. VFmxVdPoiDay.MD_WORKING_HR,
  78. VFmxVdPoiDay.FILE_PATH,
  79. VFmxVdPoiDay.MD_FLAG_COLOUR,
  80. VFmxVdPoiDay.ALERT_DESCRIPTION,
  81. VFmxVdPoiDay.ALERT_NAME,
  82. VFmxVdPoiDay.BRAND,
  83. VFmxVdPoiDay.CATEGORY_NAME,
  84. VFmxVdPoiDay.MODEL,
  85. NVL(NameStr.STR_VALUE,VFmxVdPoiDay.ru_technical_status_name) AS VIEW_ATTR,
  86. NVL(DescStr.STR_VALUE,VFmxVdPoiDay.ru_technical_status_desc) AS VIEW_ATTR
  87. FROM V_FMX_VD_POI_DAY VFmxVdPoiDay, OC_DAY_AGGREG OcDayAggreg, GU_VEHICLE GuVehicle, GUI_USERS GuiUsers, OPERATION_MODE OperationMode, OF_OWNER.STR NameStr, OF_OWNER.STR DescStr
  88. WHERE VFmxVdPoiDay.OC_DAY_AGGREG_ID = OcDayAggreg.OC_DAY_AGGREG_ID
  89. and GuVehicle.GUI_USER_ID = GuiUsers.GUI_USER_ID
  90. and GuiUsers.GUI_USER_ID = ?
  91. and GuVehicle.VEHICLE_ID = VFmxVdPoiDay.VEHICLE_ID
  92. and VFmxVdPoiDay.ru_technical_name_str_id = NameStr.STR_ID(+)
  93. and VFmxVdPoiDay.ru_technical_desc_str_id = DescStr.STR_ID(+)
  94. and GuiUsers.LANGUAGE = NameStr.LANGUAGE(+)
  95. and GuiUsers.LANGUAGE = DescStr.LANGUAGE(+)
  96. and (? = 0 or VFmxVdPoiDay.VEHICLE_ID = ?)
  97. and (0 = ? or VFmxVdPoiDay.VO_VEHICLE_CATEGORY_ID = ?)
  98. and (0 = ? or VFmxVdPoiDay.oc_poi_category_id = ?)
  99. and date_day between ? and ?
  100. and ((?='false' and DAY_KM !=0 and day_km is not null) OR ?='true')
  101. and (?='false' OR nvl(invoiced_line, 'Y') != 'N')
  102. and (? = 'false' OR status_name != 'Normal')
  103. and VFmxVdPoiDay.VEHICLE_OWNER_ID = ?
  104. and (VFmxVdPoiDay.VEHICLE_OWNER_ID != 100573 or rownum<1000)
  105. and OcDayAggreg.OPERATION_CENTER_ID = GuiUsers.OPERATION_CENTER_ID
  106. AND VFmxVdPoiDay.OPERATION_MODE_ID = OperationMode.OPERATION_MODE_ID(+)
  107. and (0 = ? or VFmxVdPoiDay.POI_ID = ?)
  108. ORDER BY vehicle_name , date_day, poi_first_event_time
Advertisement
Add Comment
Please, Sign In to add comment