SELECT fu.USER_NAME, fu.START_DATE, fu.END_DATE,
fr.RESPONSIBILITY_KEY, fr.START_DATE, fr.END_DATE
FROM FND_USER_RESP_GROUPS_ALL fur,
fnd_user fu,
fnd_responsibility fr
WHERE fur.USER_ID = fu.USER_ID
AND fur.RESPONSIBILITY_APPLICATION_ID = fr.APPLICATION_ID
AND fur.RESPONSIBILITY_ID = fr.RESPONSIBILITY_ID
ORDER BY 1
Hiç yorum yok:
Yorum Gönder