DIS Users

select
eeu.eu_id,
xxen_util.dis_user_type(eeu.eu_username) type,
xxen_util.dis_user_name(eeu.eu_username) name,
eqs.access_count,
eqs.last_accessed,
xxen_util.dis_user_name(eeu.eu_created_by) created_by,
eeu.eu_created_date creation_date,
xxen_util.dis_user_name(eeu.eu_updated_by) last_updated_by,
eeu.eu_updated_date last_update_date
from
&eul.eul5_eul_users eeu,
(
select
eqs.qs_created_by,
count(*) access_count,
max(eqs.qs_created_date) last_accessed
from
&eul.eul5_qpp_stats eqs
where
2=2
group by
eqs.qs_created_by
) eqs
where
1=1 and
eeu.eu_username=eqs.qs_created_by(+)
order by
eeu.eu_updated_date desc

select eeu.eu_id, xxen_util.dis_user_type(eeu.eu_username) type, xxen_util.dis_user_name(eeu.eu_username) name, eqs.access_count, eqs.last_accessed, xxen_util.dis_user_name(eeu.eu_created_by) created_by, eeu.eu_created_date creation_date, xxen_util.dis_user_name(eeu.eu_updated_by) last_updated_by, eeu.eu_updated_date last_update_date from &eul.eul5_eul_users eeu, ( select eqs.qs_created_by, count(*) access_count, max(eqs.qs_created_date) last_accessed from &eul.eul5_qpp_stats eqs where 2=2 group by eqs.qs_created_by ) eqs where 1=1 and eeu.eu_username=eqs.qs_created_by(+) order by eeu.eu_updated_date desc