Query To Find Menu Attached To Responsibility In Oracle Apps
Query To Find Menu Attached To Responsibility In Oracle Apps. Query to display all forms and pages for a responsibility in oracle applications r12. This query helps to get concurrent program details of to which responsibility attached and request group information.
Select unique fu.user_id, fu.user_name user_name, fr.responsibility_key responsibility, fa.application_name application. Select r.responsibility_name responsibility name , a.application_name application name , r.responsibility_key responsibility key , r.description description , main.user_menu_name menu , fun.user_function_name menu exclusions (function) , sub.user_menu_name menu exclusions (menu) , fu.description , ex.last_update_date from. For any remote support,implementation/upgrade projects,queries,collaborations please mail us at support@funoracleapps.com
From Apps.fnd_Responsibility_Vl Fr, Apps.fnd_Request_Groups Frg, Apps.fnd_Request_Group_Units Frgu,
Each of these responsibilities can be assigned to various user accounts. Select r.responsibility_name responsibility name , a.application_name application name , r.responsibility_key responsibility key , r.description description , main.user_menu_name menu , fun.user_function_name menu exclusions (function) , sub.user_menu_name menu exclusions (menu) , fu.description , ex.last_update_date from. From apps.fnd_responsibility_tl a, apps.fnd_responsibility b, apps.fnd_menus_tl c, apps.fnd_menus d, apps.fnd_application_tl e, apps.fnd_application f.
Connect By Menu_Entry.menu_Id = Prior Menu_Entry.sub_Menu_Id.
From fnd_user fu, fnd_user_resp_groups fg, fnd_application_tl fa, fnd_responsibility fr. U can find the menus,form_functions using this query. Oracle query to get oracle menus & functions along with sub menu's and their functions.
Responsibility Name With Menus Details In Oracle Apps.
Select frv.responsibility_name, fpov.profile_option_value org_id, hou.name from apps.fnd_profile_options_vl fpo, apps.fnd_responsibility_vl frv, apps.fnd_profile_option_values fpov, apps.hr_organization_units hou where hou.name = < ou name > and fpov.profile_option_value = to_char (hou.organization_id) and. Sql query to list all oracle reports assigned to a responsibility. Under that main menu you can have other sub menus or functions.
This Query Helps To Get Concurrent Program Details Of To Which Responsibility Attached And Request Group Information.
From (select * from fnd_menu_entries_vl where prompt is not null and grant_flag ='y' ) fmev. Where fg.user_id (+) = fu.user_id. For any remote support,implementation/upgrade projects,queries,collaborations please mail us at support@funoracleapps.com
Oracle Erp Cloud Sql Query To Find Bank Accounts Associated With A Supplier
A responsibility will have one main menu. Select fa.application_name, fr.responsibility_name program_attached_to, frg.request_group_name, fcp.request_set_name, fcp.user_request_set_name. Replace the menu id field “menu_id” with your specific menu id whose complete drilldown you require , you can extract the id from frontend form “define menus” in system administrator responsibility.
Post a Comment for "Query To Find Menu Attached To Responsibility In Oracle Apps"