16 maggio 2013

Oracle EBS: get list of the all forms and their functions


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: