Oracle E-Business Suite: Sorumluluklarla İlgili Menulerin Bulunması

Sorumluklara bağlı bulunan menülerin bulunması için yazılmış bir script.

SELECT DISTINCT a.responsibility_name, c.user_menu_name  
 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  
 WHERE a.responsibility_id(+) = b.responsibility_id  
 AND a.responsibility_name='System Administrator'  
 AND b.menu_id = c.menu_id  
 AND b.menu_id = d.menu_id  
 AND e.application_id = f.application_id  
 AND f.application_id = b.application_id  
 AND a.LANGUAGE = 'US';