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.
- 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
You need to login to post a comment.