Skip to content

EBS list of username with responsibility

select d.full_name,a.USER_NAME USER_ID, a.EMPLOYEE_ID, c.RESPONSIBILITY_NAME
from apps.FND_USER a, apps.FND_USER_RESP_GROUPS b, apps.FND_RESPONSIBILITY_VL c, apps. per_all_people_f d
where a.USER_ID=b.USER_ID and b.RESPONSIBILITY_ID=c.RESPONSIBILITY_ID and a.employee_id=d.person_id and sysdate between d.effective_start_date and d.effective_end_Date group by a.USER_NAME,a.EMPLOYEE_ID,c.RESPONSIBILITY_NAME,d.full_name order by a.USER_NAME

About these ads
No comments yet

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

Follow

Get every new post delivered to your Inbox.

Join 122 other followers

%d bloggers like this: