1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

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

Discussion in 'Oracle Apps Technical' started by jagadekara, May 28, 2014.

  1. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Query To Display All Forms and Pages for a Responsibility In Oracle Applications R12

    Code (SQL):
    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
    )