查询Report 被哪些Responsbility引用

查询Report 被哪些Responsbility引用

-----根据FunctionName查找它的FUnction ID
Select * From apps.fnd_form_functions_vl fffv
Where fffv.Parameters Like '%AUS_PO_REPORT%' -----fucntion_id = 9345
 
-----根据Function ID查找他的Menue ID
Select fmev.MENU_ID,fmev.* From apps.fnd_menu_entries_vl fmev --Where fmev.SUB_MENU_ID = 9404
Where fmev.FUNCTION_ID = 9345  --menu_id = 67803
 
-----根据Menu 查找下一级的MenuID(SUB_MENU_ID)为此 Menu ID的MenuID  -----------------循环

Select * From apps.fnd_menu_entries_vl fmev  Where fmev.SUB_MENU_ID In
(
68339
)

Select * From apps.fnd_responsibility_vl frv Where frv.MENU_ID In
(
 68339
,68071
,68290
,68291
,68292
,72277
,71071
,71376
)