This is to list the Apps User who are assigned a particular responsibility

on Thursday, 3 May 2012

This is to list the  Apps User who are assigned a particular responsibility


select a.user_name,b.responsibility_name 
from
fnd_user a,fnd_responsibility_vl b ,FND_USER_RESP_GROUPS c
where
a.user_id = c.user_id
and
c.RESPONSIBILITY_ID = b.RESPONSIBILITY_ID
and lower(b.responsibility_name) like lower('&Responsibility_name%')
and a.END_DATE is null
and
(c.END_DATE is null
or
c.end_date > sysdate)
group by a.USER_NAME,b.RESPONSIBILITY_NAME

0 comments:

Post a Comment