psi_mmobile

Untitled

Jul 7th, 2026
79
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 4.06 KB | None | 0 0
  1. SELECT
  2.         GenericEvent.COST,
  3.         GenericEvent.CREATION_DATE,
  4.         GenericEvent.GE_COMMENT,
  5.         GenericEvent.GE_DATE,
  6.         GenericEvent.GE_HR,
  7.         GenericEvent.GE_KM,
  8.         GenericEvent.GE_TYPE_ID,
  9.         GenericEvent.GENERIC_EVENT_ID,
  10.         GenericEvent.GUI_USER_ID,
  11.         GenericEvent.LM_COMMENT,
  12.         GenericEvent.LM_DATE,
  13.         GenericEvent.LM_NAME,
  14.         GenericEvent.NAME,
  15.         GenericEvent.POI_ID,
  16.         GenericEvent.SHORT_NAME,
  17.         GenericEvent.VEHICLE_ID,
  18.         GenericEvent.WBS_ID,
  19.         Person.PERSON_ID,
  20.         (Person.LAST_NAME  || ' ' ||  Person.FIRST_NAME) person_name,
  21.         P_WBS.getWbsName(GenericEvent.wbs_id, GenericEvent.POI_ID) wbs_name,
  22.         (GuiUsers.LAST_NAME || ' ' || GuiUsers.FIRST_NAME) user_name,
  23.         GenericEvent.REF_NUMBER,
  24.         GenericEvent.GE_TYPE_STATUS_ID,
  25.         (Vehicle.COMPANY_NR || ' ' || Vehicle.NUMBERPLATE) vehicle_name,
  26.         vAdfFirstAttachDocEO.file_path first_attach_doc,
  27.         GenericEvent.OBJECT_ID,
  28.         NVL2(Object.vehicle_id, '['|| Object.COMPANY_NR || '].[' || Object.NUMBERPLATE || ']', NULL) object_name,
  29.         GeTypeStatus.ICON_NAME status_icon,
  30.         GeTypeStatus.GE_TYPE_STATUS_ID,
  31.         vAdfFirstAttachDocEO.content_Type_id first_attach_doc_content_type,
  32.         vehicle.numberplate vehicle_numberplate,
  33.         vehicle.company_nr vehicle_company_nr,
  34.         GenericEvent.IS_PAID,
  35. --        GenericEvent.EQUIPMENT_STORE_PLACE_ID,
  36. --        EquipmentStorePlace.NAME storeplace_name,
  37.         VoTin.VEHICLE_OWNER_ID,
  38.         VoTin.Tin vo_tin_tin,
  39.         VoTin.Real_Employer_Name vo_tin_real_employer_name
  40. FROM
  41.         GENERIC_EVENT GenericEvent,
  42.         PERSON Person,
  43.         GUI_USERS GuiUsers,
  44.         VEHICLE Vehicle,
  45.         VEHICLE Object,
  46.         VO_VEHICLE_CATEGORY VoVehicleCategory,
  47.         GE_TYPE_STATUS GeTypeStatus,
  48.         EQUIPMENT_STORE_PLACE EquipmentStorePlace,
  49.         VO_TIN VoTin,
  50.         VO_PERSON_CATEGORY VoPersonCategory,
  51.         V_ADF_FIRST_ATTACH_DOC vAdfFirstAttachDocEO
  52. WHERE
  53.         GenericEvent.person_id = Person.person_id (+)
  54.         AND person.vo_person_category_id =VoPersonCategory.Vo_person_category_id(+)
  55.         AND GenericEvent.ge_type_status_id = GeTypeStatus.ge_type_status_id (+)
  56.         AND GenericEvent.GUI_USER_ID = GuiUsers.GUI_USER_ID
  57.         AND GenericEvent.vehicle_id = Vehicle.vehicle_id (+)
  58.         AND GenericEvent.OBJECT_ID = Object.vehicle_id (+)
  59.         AND Object.VO_VEHICLE_CATEGORY_ID = VoVehicleCategory.VO_VEHICLE_CATEGORY_ID (+)
  60.         AND GenericEvent.EQUIPMENT_STORE_PLACE_ID = EquipmentStorePlace.EQUIPMENT_STORE_PLACE_ID(+)
  61.         AND Person.REAL_EMPLOYER_TIN = VoTin.TIN (+)
  62.         AND VoPersonCategory.vehicle_owner_id = VoTin.vehicle_owner_id (+)
  63.         AND GenericEvent.generic_event_id = vAdfFirstAttachDocEO.generic_event_id(+)
  64.         AND (vAdfFirstAttachDocEO.row_num = 1 OR vAdfFirstAttachDocEO.row_num IS NULL)
  65.         AND (GenericEvent.PERSON_ID IN
  66.           (SELECT PERSON_ID FROM GU_PERSON WHERE GUI_USER_ID = :gui_user_id)
  67.         OR GenericEvent.VEHICLE_ID IN
  68.           (SELECT VEHICLE_ID FROM GU_VEHICLE WHERE GUI_USER_ID = :gui_user_id)
  69.         OR GenericEvent.object_id IN
  70.           (SELECT VEHICLE_ID FROM GU_VEHICLE WHERE GUI_USER_ID = :gui_user_id)
  71.         OR GenericEvent.poi_id IN
  72.           (SELECT poi_id FROM v_gui_user_oc_poi WHERE gui_user_id = :gui_user_id)
  73.         OR GenericEvent.gui_user_id = :gui_user_id)
  74.         AND (NULL IS NULL OR GenericEvent.PERSON_ID = NULL) -- person filter
  75.         AND (NULL IS NULL OR GenericEvent.VEHICLE_ID = NULL) -- vehicle filter
  76.         AND (NULL IS NULL OR GenericEvent.POI_ID = NULL) -- poi filter
  77.         AND (NULL IS NULL OR GenericEvent.OBJECT_ID = NULL) -- object filter
  78.         AND (NULL IS NULL OR GenericEvent.WBS_ID = NULL) -- wbs filter
  79.         AND GenericEvent.GE_DATE >= toutcdate(:fromDate, 'Europe/Brussels')
  80.         AND GenericEvent.GE_DATE <= toutcdate(:toDate, 'Europe/Brussels')
  81.         AND NVL (GenericEvent.IS_WORK_ORDER,'N') <> 'Y'
  82.         ORDER BY GenericEvent.CREATION_DATE DESC;
Advertisement
Add Comment
Please, Sign In to add comment