User&Responsibility

User&Responsibility

SELECT
FU.USER_NAME,
FU.DESCRIPTION ,
FR.RESPONSIBILITY_KEY,
t.responsibility_name,
FR.*,
FURG.*
FROM FND_USER_RESP_GROUPS FURG,
fnd_responsibility_tl t,
FND_RESPONSIBILITY FR,
FND_USER FU
WHERE 1=1
AND FU.USER_ID=FURG.USER_ID
AND FURG.RESPONSIBILITY_ID=FR.RESPONSIBILITY_ID
and fr.responsibility_id = t.responsibility_id
AND fr.application_id = t.application_id
AND t.LANGUAGE = USERENV ('LANG')
AND FU.END_DATE IS NULL
AND FURG.END_DATE IS NULL
order by FU.USER_NAME

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/41594/viewspace-50522/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/41594/viewspace-50522/