Advanced Search

Return to Snippet

Revision: 13386
at April 22, 2009 05:23 by datelt
Updated Code 
SELECT fr.responsibility_name,
       fm.user_menu_name,
       fme.entry_sequence,
       fme.prompt,
       fme.description,
       fff.function_name,
       fff.user_function_name,
       fff.description
  FROM fnd_responsibility_vl fr,
       fnd_menus_vl fm,
       fnd_menu_entries_vl fme,
       fnd_form_functions_vl fff
 WHERE fm.menu_id = fr.menu_id
   AND fme.menu_id = fm.menu_id
   AND fff.function_id = fme.function_id
   AND fff.function_name = :function_name;

Revision: 13385
at April 22, 2009 05:18 by datelt
Initial Code 
fme.ENTRY_SEQUENCE,
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
Search Function-Responsibility relation

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    
function

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
SQL