Sorumluğa Atanmış Ekranları Listeleyen Script

Merhaba, Verilen sorumluluğa atanmış olan fonksiyonların listesini veren sorgu örneği aşağıdaki gibidir.     SELECT frtl.responsibility_name, fr.responsibility_key, fm.menu_id, fm.menu_name, menu.function_id, menu.prompt, fffv.user_function_name, fffv.function_name, fffv.TYPE FROM (SELECT connect_by_root fmet.menu_id top_menu_id, fmet.menu_id menu_id, fmet.sub_menu_id, fmet.function_id, fmet.prompt FROM fnd_menu_entries_vl fmet CONNECT BY PRIOR fmet.sub_menu_id = fmet.menu_id AND PRIOR fmet.prompt IS NOT NULL) menu, fnd_responsibility fr, fnd_responsibility_tl frtl, fnd_menus […]