ORACLE EBS中报表所在职责及菜单所在职责

--报表所在职责

SELECT DISTINCT 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 fcpt.user_concurrent_program_name LIKE '%CUX:销售出库明细表%';

--菜单所在职责

SELECT fm.menu_name 菜单,

fmt.user_menu_name 用户菜单名,

fmt.description 说明,

fmev.prompt 提示,

(SELECT user_menu_name

FROM fnd_menus_tl fmt1

WHERE 1 = 1

AND fmt1.menu_id = fmev.sub_menu_id

AND fmt1.language = userenv('LANG')) 子菜单,

fffv.function_name 功能,

fffv.user_function_name 用户功能名,

fmev.description 说明

FROM fnd_form_functions_vl fffv,

fnd_menu_entries_vl fmev,

fnd_menus fm,

fnd_menus_tl fmt

WHERE 1 = 1

AND fffv.function_id(+) = fmev.function_id

AND fmev.menu_id = fm.menu_id

AND fm.menu_id = fmt.menu_id

AND fmt.language = userenv('LANG')

AND fm.menu_name = 'SN_OM_SALESMAN'