查用ERP用户与职责
SELECT UH.USER_ID
,UH.USER_NAME
,HL.RESPONSIBILITY_ID
,TL.RESPONSIBILITY_NAME
,HL.RESPONSIBILITY_APPLICATION_ID
,HL.START_DATE
,HL.END_DATE
,HL.DESCRIPTION
FROM FND_USER UH
,FND_USER_RESP_GROUPS HL
,FND_RESPONSIBILITY_TL TL
WHERE UH.USER_ID=HL.USER_ID
--AND UH.USER_NAME='*'
AND HL.RESPONSIBILITY_ID=TL.RESPONSIBILITY_ID
AND TL.LANGUAGE=USERENV('LANG')
SELECT UH.USER_ID
,UH.USER_NAME
,HL.RESPONSIBILITY_ID
,TL.RESPONSIBILITY_NAME
,HL.RESPONSIBILITY_APPLICATION_ID
,HL.START_DATE
,HL.END_DATE
,HL.DESCRIPTION
FROM FND_USER UH
,FND_USER_RESP_GROUPS HL
,FND_RESPONSIBILITY_TL TL
WHERE UH.USER_ID=HL.USER_ID
--AND UH.USER_NAME='*'
AND HL.RESPONSIBILITY_ID=TL.RESPONSIBILITY_ID
AND TL.LANGUAGE=USERENV('LANG')
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/133041/viewspace-438528/ ，如需转载，请注明出处，否则将追究法律责任。
下一篇：
PL/SQL程序包锁查询
请登录后发表评论
登录
全部评论
