Below the statement to get the list of all Oracle EBS Forms with their business functions:
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' --Select language
AND fff.application_id = 401 --Select module
ORDER BY ffft.user_function_name;
Nessun commento:
Posta un commento