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

　　

查询职责定义