查找报表或菜单所属职责代码,OracleEBS代码库,德仔网

代码语言

代码分类

【OracleEBS】查找报表或菜单所属职责

作者:Dezai.CN / 发布于2012/8/28/ 711

<div>
<div id="cnblogs_post_body">
<div id="cnblogs_post_body">
<div class="articalContent">--报表所属职责
SELECT  FCPT.USER_CONCURRENT_PROGRAM_NAME,
        FRG.REQUEST_GROUP_NAME,
        FR.RESPONSIBILITY_KEY
FROM FND_CONCURRENT_PROGRAMS_TL  FCPT,
        FND_REQUEST_GROUP_UNITS      FRGU,
        FND_REQUEST_GROUPS           FRG,
        FND_RESPONSIBILITY           FR
WHERE FCPT.CONCURRENT_PROGRAM_ID =  FRGU.REQUEST_UNIT_ID
   AND FRGU.REQUEST_GROUP_ID =  FRG.REQUEST_GROUP_ID
   AND FRG.REQUEST_GROUP_ID =  FR.REQUEST_GROUP_ID
   AND  lower(FCPT.USER_CONCURRENT_PROGRAM_NAME) LIKE  lower('&program_name');</div>
<div class="articalContent"></div>
<div class="articalContent">--菜单所属职责
select fffv.function_name,  fm.menu_name,fr.responsibility_key
from fnd_form_functions_vl  fffv,
        fnd_menu_entries_vl     fmev,
        fnd_menus               fm,
        fnd_responsibility     fr
where fffv.function_id =  fmev.function_id
   and fmev.menu_id =  fm.menu_id
   and fmev.menu_id =  fr.menu_id(+)
   and fffv.function_name =  '&function_name';</div>
</div>
</div>
</div>

评论列表

本站所提供的代码，版权归原作者所有，若有侵犯作者版权，请与我们联系，我们将立即删除或修改。谢谢!
本站所有代码发布及提供者。

试试其它关键字

　职责　

同语言下

可能有用的

Dezai.CN贡献的其它代码(4037)