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
