EBS职责清单(Responsibility)

最新推荐文章于 2022-06-09 12:02:17 发布

weixin_30294021

最新推荐文章于 2022-06-09 12:02:17 发布

阅读量465

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/samrv/p/9397620.html

版权

-- 職責清單 -- Responsibilities select --FR.APPLICATION_ID,FR.RESPONSIBILITY_ID, FR.RESPONSIBILITY_NAME, FA.APPLICATION_NAME, FR.RESPONSIBILITY_KEY, FR.DESCRIPTION, FR.START_DATE, FR.END_DATE, DECODE(FR.DATA_GROUP_ID,0,'Standard','Multiple Reporting Currencies') AS DATA_GROUP_NAME, -- FR.DATA_GROUP_APPLICATION_ID, DGFA.APPLICATION_NAME AS "DATA_GROUP_APPLICATION", -- FR.MENU_ID, FM.MENU_NAME, FRG.REQUEST_GROUP_NAME, -- FR.GROUP_APPLICATION_ID, gfa.application_name as "REQUEST_GROUP_APPLICATION" -- FR.REQUEST_GROUP_ID --FR.* from apps.FND_RESPONSIBILITY_VL FR, apps.fnd_application_vl FA, apps.fnd_application_vl DGFA, apps.fnd_application_vl GFA, apps.FND_MENUS_VL FM, apps.FND_REQUEST_GROUPS FRG where FR.APPLICATION_ID = FA.APPLICATION_ID AND FR.MENU_ID = FM.MENU_ID AND FR.DATA_GROUP_APPLICATION_ID = DGFA.APPLICATION_ID AND FR.REQUEST_GROUP_ID = FRG.REQUEST_GROUP_ID and FR.GROUP_APPLICATION_ID = gfa.application_id AND FR.responsibility_NAME LIKE '%DG%' ORDER BY FR.APPLICATION_ID

转载于:https://www.cnblogs.com/samrv/p/9397620.html