查用ERP用户与职责

查用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')

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/133041/viewspace-438528/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/133041/viewspace-438528/