--EBS根据菜单名查找FORM名
select app.APPLICATION_ID,
app.APPLICATION_SHORT_NAME,
ff.FORM_NAME,
ff.USER_FORM_NAME,
fff.USER_FUNCTION_NAME,
fme.prompt,
fm.MENU_NAME,
fm.USER_MENU_NAME
from fnd_menu_entries_vl fme,
fnd_form_functions_vl fff,
fnd_form_vl ff,
fnd_application_vl app,
fnd_menus_vl fm
where fff.FUNCTION_ID = fme.FUNCTION_ID
and fme.PROMPT = '&PROMPT'
and fff.FORM_ID = ff.form_id
and ff.APPLICATION_ID = app.APPLICATION_ID
and fm.MENU_ID = fme.MENU_ID;
EBS根据菜单名查找FORM名
未经允许不得转载:徐万新之路 » EBS根据菜单名查找FORM名