EBS: 查询职责定义

查询职责名称含有”MIS“的所有职责 （环境： EBS R12.2 + LINUX 6.5, 测试库： vision）

 

-- 查询职责定义  
--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(+)
 

　　

查询职责定义