Skip to content

EBS list of username with responsibility

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

No comments yet

Leave a Reply

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

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

Google photo

You are commenting using your Google 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 )

Connecting to %s

%d bloggers like this: