SELECT lpad(' ', 6 *(LEVEL -1)) || menu_entry.entry_sequence sequence,
lpad(' ', 6 *(LEVEL -1)) || ft.PROMPT Menu,
lpad(' ', 6*(level -1)) || menu.user_menu_name Menu_Name,
lpad(' ', 6 *(LEVEL -1)) || func.user_function_name "Function",
func.description,
menu.menu_id,
func.function_id,
menu_entry.grant_flag grant_flag,
decode(menu_entry.sub_menu_id, NULL, 'FUNCTION', decode(menu_entry.function_id, NULL, 'SUBMENU', 'BOTH')) type
FROM fnd_menu_entries menu_entry,
fnd_menus_tl menu,
fnd_form_functions_tl func,
fnd_menu_entries_tl ft
WHERE menu_entry.sub_menu_id = menu.menu_id(+)
AND menu_entry.function_id = func.function_id(+)
AND grant_flag = 'Y'
AND ft.menu_id = menu_entry.menu_id
AND ft.entry_sequence = menu_entry.entry_sequence
AND LEVEL < 4 START WITH menu_entry.menu_id = --$Sql_stmt$--67850--79510
(SELECT b.menu_id
FROM fnd_responsibility b,
fnd_responsibility_tl t
WHERE b.responsibility_id = t.responsibility_id
AND t.responsibility_name = '&Responsibility_Name')
CONNECT BY menu_entry.menu_id = PRIOR menu_entry.sub_menu_id
ORDER siblings BY menu_entry.entry_sequence;
lpad(' ', 6 *(LEVEL -1)) || ft.PROMPT Menu,
lpad(' ', 6*(level -1)) || menu.user_menu_name Menu_Name,
lpad(' ', 6 *(LEVEL -1)) || func.user_function_name "Function",
func.description,
menu.menu_id,
func.function_id,
menu_entry.grant_flag grant_flag,
decode(menu_entry.sub_menu_id, NULL, 'FUNCTION', decode(menu_entry.function_id, NULL, 'SUBMENU', 'BOTH')) type
FROM fnd_menu_entries menu_entry,
fnd_menus_tl menu,
fnd_form_functions_tl func,
fnd_menu_entries_tl ft
WHERE menu_entry.sub_menu_id = menu.menu_id(+)
AND menu_entry.function_id = func.function_id(+)
AND grant_flag = 'Y'
AND ft.menu_id = menu_entry.menu_id
AND ft.entry_sequence = menu_entry.entry_sequence
AND LEVEL < 4 START WITH menu_entry.menu_id = --$Sql_stmt$--67850--79510
(SELECT b.menu_id
FROM fnd_responsibility b,
fnd_responsibility_tl t
WHERE b.responsibility_id = t.responsibility_id
AND t.responsibility_name = '&Responsibility_Name')
CONNECT BY menu_entry.menu_id = PRIOR menu_entry.sub_menu_id
ORDER siblings BY menu_entry.entry_sequence;
No comments:
Post a Comment