Oracle 报表-请求-菜单-职责查询 

 1 SELECT DISTINCT '请求组' TYPE,
 2                 fcp.user_concurrent_program_name user_function_name,
 3                 frg.request_group_id,
 4                 frg.request_group_name,
 5                 frv.responsibility_name
 6   FROM fnd_request_group_units    frgu,
 7        fnd_request_groups         frg,
 8        fnd_responsibility_vl      frv,
 9        fnd_concurrent_programs_vl fcp
10  WHERE 1 = 1
11    AND frgu.request_unit_id = fcp.concurrent_program_id
12    AND frg.request_group_id = frgu.request_group_id
13    AND frv.request_group_id = frg.request_group_id
14    AND fcp.user_concurrent_program_name LIKE 'CUX%' 
15 UNION ALL
16 SELECT DISTINCT '菜单' TYPE,
17                 fff.user_function_name,
18                 fmv.menu_id request_group_id,
19                 fmv.menu_name request_group_name,
20                 frv.responsibility_name
21   FROM fnd_form_functions_vl fff,
22        fnd_menus_vl          fmv,
23        fnd_menu_entries_vl   fme,
24        fnd_responsibility_vl frv
25  WHERE 1 = 1
26    AND fff.user_function_name LIKE 'CUX%'
27    AND frv.menu_id = fmv.menu_id
28    AND fmv.menu_id = fme.menu_id
29    AND fme.function_id = fff.function_id

 

posted @ 2020-09-27 19:41  kiko_0926  阅读(190)  评论(0)    收藏  举报