EBS: 职责

-- 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')

  

posted @ 2022-12-02 14:42  samrv  阅读(84)  评论(0编辑  收藏  举报