Link between FND_USER and FND_RESPONSIBILITY_TL tables

FND_USER_RESP_GROUPS_DIRECT

select fu.USER_NAME,

papf.FULL_NAME,

fr.RESPONSIBILITY_NAME ,

fu1.USER_NAME CREATED_BY,

papf1.FULL_NAME CREATED_BY_NAME,

fur.CREATION_DATE

--fur.*

from FND_USER fu,

FND_USER_RESP_GROUPS_DIRECT fur,

fnd_responsibility_tl fr,

per_all_people_f papf,

FND_USER fu1,

per_all_people_f papf1

where fu.user_id =fur.user_id

and fur.RESPONSIBILITY_ID = fr.RESPONSIBILITY_ID

and fu.USER_NAME =papf.EMPLOYEE_NUMBER

and fur.created_by = fu1.user_id

and fu1.USER_NAME =papf1.EMPLOYEE_NUMBER

--and fu.USER_NAME='502135771'

AND NVL (fu.END_DATE, SYSDATE) >= SYSDATE

AND NVL (fur.END_DATE, SYSDATE) >= SYSDATE

and fr.RESPONSIBILITY_NAME like 'ES AR Manager%'

and fr.LANGUAGE=USERENV('LANG')

order by 1