SELECT DISTINCT gu.loginname, gu.first_name||' '||gu.last_name "Names"
FROM gui_users gu, gu_vehicle_owner gvo,operation_center oc, vehicle_owner vo, vo_group vg
WHERE gu.operation_center_id=oc.operation_center_id
AND vo.admin_center_id=oc.admin_center_id
AND vg.vehicle_owner_id=vo.vehicle_owner_id
AND vo.vehicle_owner_id=gvo.vehicle_owner_id
AND gvo.gui_user_id=gu.gui_user_id
AND vg.vehicle_owner_id = (SELECT vehicle_owner_id FROM vehicle_owner WHERE company_name LIKE '%FABRICOM%')
ORDER BY 1;