ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDE9379D2E0530100007F1FF2 FND Menu Name Y select fmv.menu_name value, fmv.user_menu_name description from fnd_menus_vl fmv order by fmv.menu_name US 8E2FF36EDE9E79D2E0530100007F1FF2 FND Responsibility Name Y select frv.responsibility_name value, frv.description from fnd_responsibility_vl frv order by frv.responsibility_name US 8E2FF36EDE8B79D2E0530100007F1FF2 FND User Menu Name Y select fmv.user_menu_name value, fmv.menu_name||': '||fmv.description description from fnd_menus_vl fmv order by fmv.user_menu_name US 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US 78A3E30AF12D4BF0AE48C3FC1FA36630Y select fmv.user_menu_name, fmv.menu_name, xxen_util.meaning(fmv.type,'MENU_TYPE',0) menu_type, fmv.description, xxen_util.zero_to_null(x.responsibility_count) responsibility_count, xxen_util.zero_to_null(x.active_responsibility_count) active_responsibility_count, xxen_util.user_name(fmv.created_by) created_by, xxen_util.client_time(fmv.creation_date) creation_date, xxen_util.user_name(fmv.last_updated_by) last_updated_by, xxen_util.client_time(fmv.last_update_date) last_update_date from fnd_menus_vl fmv, ( select fr.menu_id, count(*) responsibility_count, count(case when nvl(fr.end_date,sysdate)>=sysdate then 1 end) active_responsibility_count from fnd_responsibility fr group by fr.menu_id ) x where 1=1 and fmv.menu_id=x.menu_id(+) order by nvl(x.responsibility_count,0) desc, fmv.user_menu_name Display the responsibility count columns as blank instead of zero using xxen_util.zero_to_null. US FND Menus Lists all Oracle E-Business Suite menus (FND_MENUS) together with the number of responsibilities that reference each menu. The Responsibility Count column shows the total number of responsibilities pointing at the menu; Active Responsibility Count excludes end-dated responsibilities. Use the Assigned To Responsibility parameter to find the menu behind a specific responsibility, or Menus With Responsibilities Only to hide unused menus. Results are ordered by responsibility count so the most widely used menus appear first. Enginatics 1=1 1 10 1=1 fmv.user_menu_name=:user_menu_name LOV FND User Menu Name 8E2FF36EDE8B79D2E0530100007F1FF2 Y select fmv.user_menu_name value, fmv.menu_name||': '||fmv.description description from fnd_menus_vl fmv order by fmv.user_menu_name US User Menu Name 2 20 1=1 fmv.menu_name=:menu_name LOV FND Menu Name 8E2FF36EDE9379D2E0530100007F1FF2 Y select fmv.menu_name value, fmv.user_menu_name description from fnd_menus_vl fmv order by fmv.menu_name US Menu Name 3 30 1=1 fmv.type=:menu_type LOV custom Y select flvv.lookup_code id, flvv.meaning value, flvv.description from fnd_lookup_values_vl flvv where flvv.lookup_type='MENU_TYPE' and flvv.security_group_id=0 and flvv.enabled_flag='Y' order by flvv.meaning US Menu Type 4 40 1=1 fmv.menu_id in ( select frv.menu_id from fnd_responsibility_vl frv where frv.responsibility_name=:responsibility_name) LOV FND Responsibility Name 8E2FF36EDE9E79D2E0530100007F1FF2 Y select frv.responsibility_name value, frv.description from fnd_responsibility_vl frv order by frv.responsibility_name US Assigned To Responsibility 5 50 1=1 x.responsibility_count is not null LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US Menus With Responsibilities Only