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

最后

以上就是专一纸鹤最近收集整理的关于EBS常用sql的全部内容，更多相关EBS常用sql内容请搜索靠谱客的其他文章。