List of Users Having A Particular Responsibility

SELECT FU.USER_NAME,
papf.full_name,
frt.responsibility_name,
TO_CHAR(furg.start_date,’DD-MON-YYYY’) start_date,
furg.end_date
FROM fnd_user fu ,
fnd_user_resp_groups_direct furg ,
FND_RESPONSIBILITY_VL FRT,
per_all_people_f papf
WHERE fu.user_id = furg.user_id
AND frt.responsibility_id = furg.responsibility_id
AND frt.application_id = furg.responsibility_application_id
AND NVL(furg.end_date,sysdate+1) > sysdate
AND NVL(frt.end_date,sysdate +1) > sysdate
and NVL(FU.END_DATE,sysdate +1) > sysdate
AND papf.person_id =fu.user_id
AND FRT.RESPONSIBILITY_NAME =’Application Developer’ ;

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s