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' ) |
优质生活从拆开始
标签:
EBS
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】博客园社区专享云产品让利特惠,阿里云新客6.5折上折
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· 在鹅厂做java开发是什么体验
· 百万级群聊的设计实践
· WPF到Web的无缝过渡:英雄联盟客户端的OpenSilver迁移实战
· 永远不要相信用户的输入:从 SQL 注入攻防看输入验证的重要性
· 浏览器原生「磁吸」效果!Anchor Positioning 锚点定位神器解析