SELECT lev "LEVEL", fm.user_menu_name "MASTER_MENU",
entry_sequence "ENTRY_SEQ", a.prompt "PROMPT",
fms.user_menu_name "CHILD_MENU",
ffv.user_function_name "FUNCTION_NAME"
FROM (SELECT LEVEL lev, fme.menu_id, fme.sub_menu_id, function_id,
entry_sequence, PRIOR entry_sequence prior_entry_seq,
fme.prompt
FROM fnd_menu_entries_vl fme
WHERE fme.grant_flag = 'Y'
START WITH fme.menu_id = '69914'
CONNECT BY PRIOR fme.sub_menu_id = fme.menu_id) a,
fnd_menus_vl fm,
fnd_menus_vl fms,
fnd_form_functions_vl ffv
WHERE a.menu_id = fm.menu_id AND fms.menu_id(+) = a.sub_menu_id
AND ffv.function_id(+) = a.function_id
ORDER BY lev, prior_entry_seq, entry_sequence;
entry_sequence "ENTRY_SEQ", a.prompt "PROMPT",
fms.user_menu_name "CHILD_MENU",
ffv.user_function_name "FUNCTION_NAME"
FROM (SELECT LEVEL lev, fme.menu_id, fme.sub_menu_id, function_id,
entry_sequence, PRIOR entry_sequence prior_entry_seq,
fme.prompt
FROM fnd_menu_entries_vl fme
WHERE fme.grant_flag = 'Y'
START WITH fme.menu_id = '69914'
CONNECT BY PRIOR fme.sub_menu_id = fme.menu_id) a,
fnd_menus_vl fm,
fnd_menus_vl fms,
fnd_form_functions_vl ffv
WHERE a.menu_id = fm.menu_id AND fms.menu_id(+) = a.sub_menu_id
AND ffv.function_id(+) = a.function_id
ORDER BY lev, prior_entry_seq, entry_sequence;
No comments:
Post a Comment