查询用户对应的职责

SELECT Fu.User_Name
      ,Frt.Responsibility_Name
  FROM Apps.Fnd_User                    Fu
      ,Apps.Fnd_User_Resp_Groups_Direct Fr
      ,Apps.Fnd_Responsibility_Tl       Frt
 WHERE Fr.User_Id = Fu.User_Id
   AND Fr.Responsibility_Id = Frt.Responsibility_Id
   AND SYSDATE BETWEEN Fr.Start_Date AND Nvl(Fr.End_Date, SYSDATE + 1)
   AND Frt.Language = 'ZHS'
   AND Fu.User_Name IN ('ABC.DEV')
--AND Fr.Creation_Date > SYSDATE - 15
--AND Frt.Responsibility_Name LIKE ‘%Gl%Sy%%’
 ORDER BY 1
         ,2;