EBS常用sql

---------用户职责查询

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%'