Monday, 14 November 2016

Appliocation, Menus , Submenus assigned to User oracle sql query

/* Formatted on 11/14/2016 2:31:06 PM (QP5 v5.114.809.3010) */
  SELECT   fu.USER_NAME,
           r.responsibility_name,
           f.user_menu_name,
           me.prompt "Main_Prompt",
           me.description "Main_Desc",
           metl.prompt "sub_prompt",
           metl.description "sub_desc"
    FROM   apps.fnd_user fu,
           apps.fnd_user_resp_groups urg,
           apps.fnd_menus_vl f,
           apps.fnd_responsibility fr,
           apps.fnd_responsibility_tl r,
           apps.fnd_menus fm,
           apps.fnd_menu_entries fme,
           apps.fnd_menu_entries_tl me,
           apps.fnd_menus fm2,
           apps.fnd_menu_entries fme2,
           apps.fnd_menu_entries_tl metl
   WHERE   1 = 1 AND fr.menu_id = f.menu_id AND fu.user_id = urg.user_id
           AND (urg.responsibility_id = fr.responsibility_id
                AND urg.responsibility_application_id = fr.application_id)
           AND (fr.responsibility_id = r.responsibility_id
                AND fr.application_id = r.application_id)
           AND (fme.menu_id = me.menu_id
                AND fme.entry_sequence = me.entry_sequence)
           AND fr.menu_id = fm.menu_id
           AND fm.menu_id = fme.menu_id
           AND fme.sub_menu_id = fm2.menu_id
           AND fm2.menu_id = fme2.menu_id
           AND (fme2.menu_id = metl.menu_id
                AND fme2.entry_sequence = metl.entry_sequence)
                 and fr.RESPONSIBILITY_ID=51348
           AND metl.language = 'US'
           AND me.language = 'US'
ORDER BY   urg.description

No comments:

Post a Comment