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 ORDER BY aa.creation_date) qq) WHERE rn=1) "First Added Document", fct.name "File Content Type"
FROM generic_event ge
LEFT OUTER JOIN wbs w ON (ge.wbs_id=w.wbs_id)
LEFT OUTER JOIN person pe ON (ge.person_id=pe.person_id)
LEFT OUTER JOIN vehicle vev ON (ge.VEHICLE_ID=vev.VEHICLE_ID)
LEFT OUTER JOIN vehicle veo ON (ge.object_id=veo.VEHICLE_ID)
LEFT OUTER JOIN gui_users g ON (ge.gui_user_id=g.gui_user_id)
LEFT OUTER JOIN oc_poi p ON (ge.poi_id=p.poi_id)
LEFT OUTER JOIN ge_type gt ON (ge.ge_type_id=gt.ge_type_id)
LEFT OUTER JOIN ge_type_status gts ON (ge.ge_type_status_id=gts.ge_type_status_id), vo_vehicle_category vvc
LEFT OUTER JOIN vehicle vel ON (vvc.vo_vehicle_category_id=vel.vehicle_category_id), vo_vehicle_category vvc2
LEFT OUTER JOIN vehicle ves ON (vvc2.vo_vehicle_category_id=ves.vehicle_category_id), attach_doc a
LEFT OUTER JOIN GENERIC_EVENT geg ON (a.generic_event_id=geg.generic_event_id)
LEFT OUTER JOIN FILE_CONTENT_TYPE fct ON (a.CONTENT_TYPE_ID=fct.FILE_CONTENT_TYPE_ID)
WHERE ge.gui_user_id=101694;