从职责到报表名
1 -- 从职责到报表名 2 select FR.RESPONSIBILITY_KEY, 3 FR.RESPONSIBILITY_NAME, 4 FR.DESCRIPTION AS RESPONSIBILITY_DESCRIPTION, 5 FRG.APPLICATION_ID, 6 FRG.REQUEST_GROUP_ID, 7 FRG.REQUEST_GROUP_NAME, 8 -- FRG.DESCRIPTION AS REQUEST_GROUP_DESC, 9 FRG.REQUEST_GROUP_CODE, 10 FCP.USER_CONCURRENT_PROGRAM_NAME 11 -- frgu.* 12 from APPS.FND_RESPONSIBILITY_VL FR, -- 职责 13 APPS.FND_REQUEST_GROUPS frg, -- 请求组 14 apps.FND_REQUEST_GROUP_UNITS frgu, -- 请求明细等 15 APPS.FND_CONCURRENT_PROGRAMS_VL FCP -- 并发程序 16 where 1=1 17 and frg.request_group_id = frgu.request_group_id 18 AND FR.REQUEST_GROUP_ID = FRG.REQUEST_GROUP_ID 19 -- AND FR.APPLICATION_ID = FRG.APPLICATION_ID 20 AND FRGU.REQUEST_UNIT_ID = FCP.CONCURRENT_PROGRAM_ID 21 AND FCP.USER_CONCURRENT_PROGRAM_NAME LIKE 'Inventory Packing Slip%' -- 报表名或程序名
返回: