Find List of Responsibilities attached to User

SELECT b.user_name,
c.responsibility_name,
a.START_DATE,
a.END_DATE
FROM apps.fnd_user_resp_groups_direct a, apps.fnd_user b, apps.fnd_responsibility_tl c
WHERE a.user_id = b.user_id
AND a.responsibility_id = c.responsibility_id
AND c.language = 'US'
AND b.user_name = :username

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