Posted By

theonlyalterego on 11/06/10


Tagged

Oracle apps Applications oracleapplications


Versions (?)

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


 / Published in: SQL
 

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.

  1. SELECT application_name, application_short_name, fa.application_id
  2. FROM fnd_application fa, fnd_application_tl fat
  3. WHERE application_short_name LIKE 'AR'
  4. AND fa.application_id = fat.application_id
  5. ORDER BY fa.application_id

Report this snippet  

You need to login to post a comment.