SELECT distinct fr.responsibility_name,
fm.user_menu_name,
fme.prompt prompt_name,
fff.user_function_name
FROM apps.fnd_menu_entries_vl fme,
apps.fnd_menus_vl fm,
apps.fnd_form_functions_vl fff,
apps.fnd_form_vl ff,
apps.fnd_responsibility_vl fr
WHERE 1 = 1
AND fff.USER_FUNCTION_NAME = 'XX_CUST_CONTACT_FUN'
AND fme.function_id = fff.function_id
AND fm.menu_id = fme.menu_id
AND fr.menu_id = fm.menu_id;
fm.user_menu_name,
fme.prompt prompt_name,
fff.user_function_name
FROM apps.fnd_menu_entries_vl fme,
apps.fnd_menus_vl fm,
apps.fnd_form_functions_vl fff,
apps.fnd_form_vl ff,
apps.fnd_responsibility_vl fr
WHERE 1 = 1
AND fff.USER_FUNCTION_NAME = 'XX_CUST_CONTACT_FUN'
AND fme.function_id = fff.function_id
AND fm.menu_id = fme.menu_id
AND fr.menu_id = fm.menu_id;
No comments:
Post a Comment