`
sjk2013
  • 浏览: 2191829 次
文章分类
社区版块
存档分类
最新评论

EBS 超找用户所具有的职责

 
阅读更多
SELECT fu.user_name 用户名,
frt.RESPONSIBILITY_NAME 职责名,
fu.user_id 用户号,
furg.responsibility_id 职责号
FROM fnd_user_resp_groups furg,
FND_RESPONSIBILITY fr,
fnd_responsibility_tl frt,
fnd_user fu
WHERE fu.user_id = furg.user_id
and furg.RESPONSIBILITY_ID=fr.responsibility_id
and fr.responsibility_id= frt.responsibility_id
and fu.user_name like 'ZMSUP013' ;
分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics