EBS: FND_从菜单到FORM的查询

-- 职责之 菜单的子菜单(假设只存在父子二层关系)
SELECT FR.RESPONSIBILITY_KEY,
FR.RESPONSIBILITY_NAME,
FR.DESCRIPTION AS RESPONSIBILITY_DESCRIPTION,
FM.MENU_NAME,
FM.USER_MENU_NAME,
FM.DESCRIPTION AS MENU_DESCRIPTION,
FME.PROMPT AS "提示",
fff2.function_name,
fff2.type as "功能类型",
fff2.user_function_name,
fff2.description as function_description
FROM FND_RESPONSIBILITY_VL FR,
FND_MENUS_VL FM,
FND_MENU_ENTRIES_VL FME,
-- FND_FORM_FUNCTIONS_VL fff,
FND_MENUS_VL FM2,
FND_MENU_ENTRIES_VL FME2,
FND_FORM_FUNCTIONS_VL fff2
WHERE 1=1
AND FR.MENU_ID = FM.MENU_ID
AND FM.MENU_ID = FME.MENU_ID
AND FME.SUB_MENU_ID = FM2.MENU_ID
-- and fme.function_id = fff.function_id
-- AND fff.user_function_name LIKE '提货计划管理'
-- AND FM2.USER_MENU_NAME LIKE 'WSH_发货计划'
AND FM2.MENU_ID = FME2.MENU_ID
and fme2.function_id = fff2.function_id
-- AND FME.PROMPT LIKE '%装车%' -- '提货计划管理'
AND fff2.user_function_name LIKE '工程库存调整单' -- '提货计划管理'
AND FR.RESPONSIBILITY_NAME LIKE 'CUX%' -- 'CUX:客户化开发'