EBS-从职责到报表名

 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%' -- 报表名或程序名