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/