SELECT fmev.prompt , user_function_name,type
FROM (SELECT * FROM fnd_menu_entries_vl WHERE prompt is not null and grant_flag ='Y' ) fmev
, fnd_form_functions_vl ffv
WHERE fmev.function_id is not null
AND fmev.sub_menu_id is null
AND fmev.function_id = ffv.function_id(+)
AND ffv.type NOT IN ( 'SUBFUNCTION')
CONNECT BY PRIOR sub_menu_id = menu_id
START WITH menu_id in(
SELECT menu_id
FROM fnd_responsibility_vl fv
WHERE fv.responsibility_name like :P_Responsibility_name
)
No comments:
Post a Comment