Thursday 29 October 2015

Wednesday 7 October 2015

Query to findout list of users who is having AR Manager Responsibiities

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 'AR Manager%'
and fr.LANGUAGE=USERENV('LANG')
order by 1