Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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
- 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)
- 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
- JOIN GENERIC_EVENT geg ON (a.generic_event_id=geg.generic_event_id)
- JOIN FILE_CONTENT_TYPE fct ON (a.CONTENT_TYPE_ID=fct.FILE_CONTENT_TYPE_ID)
- WHERE ge.gui_user_id=101694;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement