SELECT ge.*, P_WBS.getWbsName(ge.wbs_id, ge.poi_id) "WBS Name", pe.first_name||' '||pe.last_name "Person names", g.first_name||' '||g.last_name "GUI names", vvc.name "Vehicle Category", vev.numberplate "Vehicle Numberplate",
vvc2.name "Object Category", veo.numberplate "Object Numberplate", gts.status_name, gts.icon_name, (SELECT name FROM (SELECT qq.*, rownum rn FROM (SELECT aa.name FROM attach_doc aa, generic_event gene WHERE aa.generic_event_id=gene.generic_event_id ORDER BY aa.creation_date) qq) WHERE rn=1) "First Added Document", fct.name "File Content Type"
FROM generic_event ge, wbs w, person pe, vehicle vev, vehicle veo, gui_users g, oc_poi p, ge_type gt, ge_type_status gts, vo_vehicle_category vvc, vehicle vel, vo_vehicle_category vvc2, vehicle ves, attach_doc a, FILE_CONTENT_TYPE fct, GENERIC_EVENT geg
WHERE ge.wbs_id=w.wbs_id(+)
AND ge.person_id=pe.person_id(+)
AND ge.VEHICLE_ID=vev.VEHICLE_ID(+)
AND ge.object_id=veo.VEHICLE_ID(+)
AND ge.gui_user_id=g.gui_user_id
AND ge.poi_id=p.poi_id(+)
AND ge.ge_type_id=gt.ge_type_id(+)
AND ge.ge_type_status_id=gts.ge_type_status_id(+)
AND vvc.vo_vehicle_category_id=vel.vehicle_category_id(+)
AND vvc2.vo_vehicle_category_id=ves.vehicle_category_id(+)
AND vvc2.vo_vehicle_category_id=ves.vehicle_category_id(+)
AND a.generic_event_id=geg.generic_event_id(+)
AND a.CONTENT_TYPE_ID=fct.FILE_CONTENT_TYPE_ID(+)
AND ge.gui_user_id=101694
AND (ge.person_id IN (SELECT person_id FROM gu_person WHERE gui_user_id=101694)
OR ge.vehicle_id IN (SELECT vehicle_id FROM gu_vehicle WHERE gui_user_id=101694)
OR ge.object_id IN (SELECT vehicle_id FROM gu_vehicle WHERE gui_user_id=101694)
OR ge.poi_id IN (SELECT poi_id FROM v_gui_user_oc_poi WHERE gui_user_id=101694))
ORDER BY ge.creation_date DESC;