Query to list of Responsibilities attached to a particular Oracle Application User


Hi Friends,

Kindly run below sql query as apps user for listing all the responsibilities attached to a particular user (prompted by query).

set pages 300 lines 300
col USER_NAME for a40
col RESPONSIBILITY_NAME for a50

select fu.user_name, fr.responsibility_name, furg.START_DATE, furg.END_DATE
from fnd_user_resp_groups_direct furg, fnd_user fu, fnd_responsibility_tl fr
where fu.user_name = ‘&user_name’
and furg.user_id = fu.user_id
and furg.responsibility_id = fr.responsibility_id
and fr.language = userenv(‘LANG’);

Happy Reading !!

Farhan Shaikh

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