Usefull sql scripts

1. Number of Responsibilities assigned to users. Order by count desc.
============================================
select b.user_name,count(a.responsibility_id)
from fnd_user_resp_groups_direct a,
    fnd_user b
    where a.end_date is null and
    a.user_id=b.user_id and
    b.end_date is null
    group by b.USER_name
    order by 2 desc    ;
============================================

2. Profile options changed in the last 3 days with user name, who changed that.

select
a.profile_option_id "ID",
a.profile_option_name "short_name",
c.user_profile_option_name "Full Name",
b.last_update_date "updated on",
b.last_updated_by "updated_by_ID",
d.user_name "Login_name"
from
fnd_profile_options a,
fnd_profile_option_values b,
fnd_profile_options_tl c,
fnd_user d
where
a.profile_option_id=b.profile_option_id
and
a.profile_option_name=c.profile_option_name
and
b.last_updated_by=d.user_id
and
b.last_update_date > (sysdate -3 )
order by 4 desc;