List Reponsibilities for an user

来源:互联网 发布:颜宁 施一公 知乎 编辑:程序博客网 时间:2024/06/05 02:41
SELECT fu.user_name,frt.RESPONSIBILITY_NAME, fu.user_id,furg.responsibility_idFROMfnd_user_resp_groups furg,FND_RESPONSIBILITY fr,fnd_responsibility_tl frt,fnd_user fuWHERE fu.user_name =upper('ptian')AND   fu.user_id = furg.user_idAND   furg.responsibility_id = fr.RESPONSIBILITY_IDAND   frt.responsibility_id = fr.RESPONSIBILITY_IDORDER BY 1


原创粉丝点击