EBS: 查询职责定义
查询职责名称含有”MIS“的所有职责 (环境: EBS R12.2 + LINUX 6.5, 测试库: vision)
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 | -- 查询职责定义 --N: System Administrator>>Security>>Responsibility>>Define; SELECT FR.RESPONSIBILITY_KEY, FA.APPLICATION_NAME, FR.RESPONSIBILITY_NAME, FR.DESCRIPTION AS RESP_DESCRIPTION, '' AS EFFECTIVE_DATE_FROM, '' AS EFFECTIVE_DATE_TO, 'Oracle Applications' AS "AVAILABLE_FROM" , 'Standard' AS DATA_GROUP_NAME, DFA.APPLICATION_NAME AS DATA_GROUP_APPLICATION, FM.USER_MENU_NAME, '' AS WEB_HOST_NAME, '' AS WEB_AGENT_NAME, FRG.REQUEST_GROUP_NAME, FRFA.APPLICATION_NAME AS REQUEST_GROUP_APPLICATION -- FR.* FROM FND_RESPONSIBILITY_VL FR, FND_APPLICATION_VL FA, FND_MENUS_VL FM , FND_APPLICATION_VL DFA, FND_REQUEST_GROUPS FRG, FND_APPLICATION_VL FRFA WHERE FR.RESPONSIBILITY_KEY LIKE '%(MIS)' AND FR.APPLICATION_ID = FA.APPLICATION_ID AND FR.MENU_ID = FM.MENU_ID AND FR.DATA_GROUP_APPLICATION_ID = DFA.APPLICATION_ID AND FR.REQUEST_GROUP_ID = FRG.REQUEST_GROUP_ID(+) AND FRG.APPLICATION_ID = FRFA.APPLICATION_ID(+) |
查询职责定义
优质生活从拆开始
【推荐】国内首个AI IDE,深度理解中文开发场景,立即下载体验Trae
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· 全程不用写代码,我用AI程序员写了一个飞机大战
· MongoDB 8.0这个新功能碉堡了,比商业数据库还牛
· 记一次.NET内存居高不下排查解决与启示
· DeepSeek 开源周回顾「GitHub 热点速览」
· 白话解读 Dapr 1.15:你的「微服务管家」又秀新绝活了