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(+)

  

查询职责定义 

 

posted @   samrv  阅读(62)  评论(0编辑  收藏  举报
相关博文:
阅读排行:
· 全程不用写代码,我用AI程序员写了一个飞机大战
· MongoDB 8.0这个新功能碉堡了,比商业数据库还牛
· 记一次.NET内存居高不下排查解决与启示
· DeepSeek 开源周回顾「GitHub 热点速览」
· 白话解读 Dapr 1.15:你的「微服务管家」又秀新绝活了
点击右上角即可分享
微信分享提示