--SQL Script to know the form name (.fmb) and funtion name in oracle apps 11i
SELECT fff.function_name,
ff.form_name,
ffft.user_function_name,
fff.function_id,
ff.form_id,
fff.application_id
FROM fnd_form ff,
fnd_form_functions fff,
fnd_form_functions_tl ffft
WHERE ff.form_id = fff.form_id
AND fff.function_id = ffft.function_id
AND ffft.language = 'US'
--AND fff.application_id = 20003 --Inventory Module
and ff.form_name like 'XXTABLE_NAME%' -- Form Name .fmb
ORDER BY ffft.user_function_name;
SELECT fff.function_name,
ff.form_name,
ffft.user_function_name,
fff.function_id,
ff.form_id,
fff.application_id
FROM fnd_form ff,
fnd_form_functions fff,
fnd_form_functions_tl ffft
WHERE ff.form_id = fff.form_id
AND fff.function_id = ffft.function_id
AND ffft.language = 'US'
--AND fff.application_id = 20003 --Inventory Module
and ff.form_name like 'XXTABLE_NAME%' -- Form Name .fmb
ORDER BY ffft.user_function_name;