查用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')
本文作者:网友 来源:网络
CIO之家 www.ciozj.com 微信公众号:imciow