select u.USERS_IDENT, cafe.customerorg_name,u.USERS_LOGIN,u.users_fname, u.users_lname,p.progress_start,
 p.progress_complete, p.progress_status
 from ---------table names ,
(select
	cafe.customerorg_name,dist.customerorg_name district,area.customerorg_name area
	from   --table names
	where
	cafe.customerorg_parent = dist.customerorg_ident
	and dist.customerorg_parent = area.customerorg_ident
	and cafe.customerorg_name like '600607'
	)cafe
where p.progress_user_ident(+) = u.users_ident
and u.users_active='1'
and p.progress_crsware_ident = 'C00123'

and u.users_customerorg_ident = c.customerorg_ident
and cafe.customerorg_name = c.customerorg_name
order by cafe.customerorg_name;