In Oracle Fusion, the FND_APPLICATION and FND_APPLICATION_TL tables store information about all registered applications within the system. These tables are part of the Application Object Library (AOL) and are often queried by developers or administrators to understand which applications are installed and their respective details.
Here’s a simple SQL query that retrieves the Application ID, Short Name, and User-Friendly Application Name:
select fa.application_id ,fa.application_short_name ,fat.application_name from fnd_application fa ,fnd_application_tl fat where 1=1 and fa.application_id = fat.application_id and fat.language ='US' order by fat.application_id
APPLICATION_ID | APPLICATION_NAME | APPLICATION_SHORT_NAME |
0 | Oracle Middleware Extensions for Applications | FND |
1 | System Administration | SYSADMIN |
3 | Applications Utilities | AU |
101 | General Ledger | GL |
140 | Assets | FA |
200 | Payables | AP |
201 | Purchasing | PO |
222 | Receivables | AR |
235 | Tax | ZX |
260 | Cash Management | CE |
401 | Inventory Management | INV |
435 | Financials Common Module | FUN |
Comments
Post a Comment