Experience: is what you get soon after you need it.

Experience: is what you get soon after you need it.

Rasul Allah (sal Allahu alaihi wa sallam) said: "Restore the trusts of those who trust you, and deal not falsely with him who deals falsely with you." [Abu Dawud, Tirmidhi]

Search This Blog

Friday, August 5, 2011

Find users with particular resposiblity in R12 oracle apps

from DB

SELECT fu.user_name,fu.description,fu.creation_date,fu.start_date,fu.end_date,fu.last_logon_date,fu.email_address
FROM apps.fnd_user_resp_groups_direct furgd, apps.fnd_responsibility_vl frvl, apps.fnd_user fu
WHERE furgd.responsibility_id = frvl.responsibility_id
AND fu.user_id = furgd.user_id
AND(to_char(furgd.end_date) is null
OR furgd.end_date > sysdate)
AND frvl.end_date is null
AND frvl.responsibility_name in ( 'System Administrator', 'System Administration');
/

No comments: