EBS: 职责

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
-- FND-Respon职责清单
SELECT FR.RESPONSIBILITY_ID,
       --FR.APPLICATION_ID,
       FR.RESPONSIBILITY_NAME AS "责任名",
       FA.APPLICATION_SHORT_NAME,
       FA.APPLICATION_NAME,
       FR.RESPONSIBILITY_KEY AS "责任关键字",
       FR.DESCRIPTION AS "说明", -- RESPONSIBILITY_DESCRIPTION,
       FR.START_DATE,
       FR.END_DATE,
       DECODE(FR.VERSION,'4','Oracle 应用产品','W','Oracle 自用Web应用产品','M','Oracle Mobile应用产品') AS "可采用",
       --FR.DATA_GROUP_ID,
       DECODE(FR.DATA_GROUP_ID,0,'标准',FR.DATA_GROUP_ID) AS "数据组-名称",
       --FR.DATA_GROUP_APPLICATION_ID,      
       (SELECT FA3.APPLICATION_NAME FROM FND_APPLICATION_VL FA3
        WHERE FA3.APPLICATION_ID = FR.DATA_GROUP_APPLICATION_ID
         AND ROWNUM = 1) AS "数据组-应用产品",
      -- FR.MENU_ID,
       FM.MENU_NAME,
       FM.USER_MENU_NAME,
      -- FR.REQUEST_GROUP_ID,
       (SELECT REQUEST_GROUP_NAME FROM FND_REQUEST_GROUPS FRG
        WHERE FRG.REQUEST_GROUP_ID = FR.REQUEST_GROUP_ID
         AND ROWNUM=1 ) AS "请求组-名称",
       -- FR.GROUP_APPLICATION_ID,
       (SELECT FA3.APPLICATION_NAME FROM FND_APPLICATION_VL FA3
        WHERE FA3.APPLICATION_ID = FR.GROUP_APPLICATION_ID
         AND ROWNUM = 1) AS "请求组-应用产品",
       FR.CREATION_DATE
      -- ,FR.*
  FROM FND_RESPONSIBILITY_VL FR,  -- 职责
       FND_APPLICATION_VL FA,
       FND_MENUS_VL FM
 WHERE FA.APPLICATION_ID = FR.APPLICATION_ID
  and FR.MENU_ID = FM.MENU_ID
 -- AND FR.RESPONSIBILITY_ID =53174  
  AND  FR.RESPONSIBILITY_NAME LIKE  '%超级用户'   --AS "责任名",
  AND FR.CREATION_DATE>=TO_DATE('2012-01-01','YYYY-MM-DD')

  

posted @   samrv  阅读(87)  评论(0编辑  收藏  举报
相关博文:
阅读排行:
· 在鹅厂做java开发是什么体验
· 百万级群聊的设计实践
· WPF到Web的无缝过渡:英雄联盟客户端的OpenSilver迁移实战
· 永远不要相信用户的输入:从 SQL 注入攻防看输入验证的重要性
· 浏览器原生「磁吸」效果!Anchor Positioning 锚点定位神器解析
点击右上角即可分享
微信分享提示