---------用户职责查询
SELECT 1
FROM Fnd_User_Resp_Groups a1
--,Fnd_User b
,Fnd_Responsibility c1
,Fnd_Application_Tl d1
,Fnd_Menus e1
,Fnd_Responsibility_Tl f1
WHERE a1.User_Id = Fu.User_Id
AND a1.Responsibility_Id = c1.Responsibility_Id
AND c1.Application_Id = a1.Responsibility_Application_Id
AND c1.Application_Id = d1.Application_Id
AND c1.Menu_Id = e1.Menu_Id
AND d1.Language = 'ZHS'
AND a1.Responsibility_Id = f1.Responsibility_Id
AND f1.Application_Id = a1.Responsibility_Application_Id
AND f1.Language = 'ZHS'
AND Nvl(a1.End_Date, SYSDATE + 1) > SYSDATE
AND f1.Responsibility_Name LIKE 'BOM%'