ITPub博客

首页 > Linux操作系统 > Linux操作系统 > User&Responsibility

User&Responsibility

原创 Linux操作系统 作者:jarli 时间:2019-05-08 14:27:05 0 删除 编辑
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/,如需转载,请注明出处,否则将追究法律责任。

上一篇: Responsibility
请登录后发表评论 登录
全部评论

注册时间:2003-03-27

  • 博文量
    227
  • 访问量
    160623