Protected by Copyscape Web Copyright Protection Software

Pages

Search This Blog

Monday, April 7, 2014

Query To Display All Forms and Pages for a Responsibility In Oracle Applications R12


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