[Oracle EBS] Query To Find Application Name And Short Name

This query can be used to lists all the applications related information and to find the APPLICATION_SHORT_NAME of a module (eg. Payables, Receivables, Order Management, etc.)

SELECT fa.application_id           "Application ID",
       fat.application_name        "Application Name",
       fa.application_short_name   "Application Short Name",
       fa.basepath                 "Basepath"
  FROM fnd_application     fa,
       fnd_application_tl  fat
 WHERE fa.application_id = fat.application_id
   AND fat.language      = USERENV('LANG')
   --AND fat.application_name = 'General Ledger' 
 ORDER BY fat.application_name;

Artikel Terkait :

• [Oracle EBS] Query Period Status
• [Oracle EBS] Query To Find Application Name And Short Name
• [Oracle EBS] GL Journals Stuck With Funds Status In Process
• [Oracle EBS] Fixed Asset Error APP-OFA-48392 in Asset Workbench
• [Linux] Transfer Files Or Folder Using SCP
• [PostgreSQL] Truncate Table and Reset Sequence
• [Oracle EBS] ORA-01591 In-Doubt Transactions
• [Oracle EBS] Query to list Reports assigned to a Responsibility