Advanced Search

Return to Snippet

Revision: 35373
at November 6, 2010 05:55 by theonlyalterego
Initial Code 
select application_name, application_short_name, fa.application_id
from fnd_application fa, fnd_application_tl fat
where application_short_name like 'AR'
and fa.application_id = fat.application_id
order by fa.application_id
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    
use this SQL query to find out an applications full name (aka long name) and/or application id based on the application short name. This can obviously be re-written to perform the reverse.

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
Oracle Applications - Find Application (Module) Long Name from Short name

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    
Oracle

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
SQL