Query to find Application Short Name of a module


The following query lists all the applications related information. This query can be used to find the APPLICATION_SHORT_NAME of a module (eg. Payables, Receivables, Order Management, etc.) that are often used for downloading FNDLOAD LDT files, adding responsibility to a user and many more.

You can uncomment the FAT.APPLICATION_NAME condition (very bottom line of the query) to learn about a particular module. In this case, I used "Payables".


-------------------------------------------------------------------------------
-- Query to find all APPLICATION (module) information
-------------------------------------------------------------------------------
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 = 'Payables'  -- <change it>
 ORDER BY fat.application_name;
 

APPLICATION SHORT NAME
APPLICATION NAME
FNDApplication Object Library
SYSADMINSystem Administration
AUApplication Utilities
ADApplications DBA
SQLGLGeneral Ledger
OFAAssets
ALRAlert
RGApplication Report Generator
CSService
ECe-Commerce Gateway
SQLAPPayables
POPurchasing
ARReceivables
QAQuality
CECash Management
PAProjects
ASSales Foundation
CNIncentive Compensation
OEOrder Entry
INVInventory
ANSales Analysis
ODQData Query
AXGlobal Accounting Engine
AKCommon Modules-AK
MFGManufacturing
BOMBills of Material
ENGEngineering
MRPMaster Scheduling/MRP
CRPCapacity
WIPWork in Process
CZConfigurator
PERHuman Resources
PAYPayroll
FFFastFormula
DTDateTrack
SSPSSP
MSCAdvanced Supply Chain Planning
BENAdvanced Benefits
OTALearning Management
JAAsia/Pacific Localizations
JEEuropean Localizations
JGRegional Localizations
JLLatin America Localizations
CHVSupplier Scheduling
ICXOracle iProcurement
AHMHosting Manager(Obsolete)
CSTCost Management
RLARelease Management Integration Kit (Obsolete)
VEHAutomotive Integration Kit (Obsolete)
HXTTime and Labor
AZApplication Implementation
PJMProject Manufacturing
FLMFlow Manufacturing
RHXAdvanced Planning Foundation(obsolete)
GHRUS Federal Human Resources
DEMDemo Order Entry (AOL Class)
CLRCulinary Application
CCTTelephony Manager
BISApplications BIS
ADSApplications Demonstration Services
CUSTOMCustom Development
ADS_DEVADS Development
XTRTreasury
PNProperty Manager
WMSWarehouse Management
WPSManufacturing Scheduling
FIIFinancial Intelligence
POAPurchasing Intelligence
HRIHuman Resources Intelligence
OKCContracts Core
CSCCustomer Care
CSDDepot Repair
ITAInformation Technology Audit
CDROracle Clinical Data Repository
DUMMY_GMOObsolete Process Operations
CLJJapan Consulting Localizations
RRCRetail Core
CLLLAD Consulting Localizations
RRSSite Management
CLEEMEA Consulting Localizations
CSFField Service
CSSSupport (obsolete)
OKSService Contracts
MEControlled Availability Product(Obsolete)
BIMMarketing Intelligence
BICCustomer Intelligence (obsolete)
IESScripting
AMVMarketing Encyclopedia System
ASTTeleSales
ASFSales Online
CSPSpares Management
OKXContracts Integration
AMSMarketing
XNMMarketing for Communications (Obsolete)
XNCSales for Communications (Obsolete)
XNSService for Communications (obsolete)
XNPNumber Portability
XDPProvisioning
FPTBanking Center (obsolete)
IEOInteraction Center Technology
GMAProcess Manufacturing Systems
GMIProcess Manufacturing Inventory
GMDProcess Manufacturing Product Development
GMEProcess Manufacturing Process Execution
GMPProcess Manufacturing Process Planning
GMFProcess Manufacturing Financials
GMLProcess Manufacturing Logistics
GRProcess Manufacturing Regulatory Management
PMIProcess Manufacturing Intelligence
XLASubledger Accounting
ONTOrder Management
QPAdvanced Pricing
RLMRelease Management
VEAAutomotive
WSHShipping Execution
IBAiMarketing (Obsolete)
IBEiStore
IBUiSupport
IBYPayments
IBPBill Presentment & Payment
BILSales Intelligence
BIXInteraction Center Intelligence
IEMEmail Center
OZPTrade Planning (Obsolete)
OZFTrade Management
OZSiClaims (Obsolete)
ASGCRM Gateway for Mobile Devices
JTFCRM Foundation
IEXCollections
IEUUniversal Work Queue
ASOOrder Capture
MSOConstraint Based Optimization
OKEProject Contracts
IPACapital Resource Logistics – Projects
CUINetwork Logistics – Inventory
CUPNetwork Logistics – Purchasing
CUFCapital Resource Logistics – Financials
CUSNetwork Logistics
CUNNetwork Logistics – NATS (obsolete)
CUACapital Resource Logistics – Assets
WSMShop Floor Management
SHTApplications Shared Technology
ECXXML Gateway
FRMReport Manager
EAASEM Exchange (obsolete)
BSCBalanced Scorecard
ABMActivity Based Management (Obsolete)
EVMValue Based Management
FEMEnterprise Performance Foundation
POMExchange
MWAMobile Applications
OPIOperations Intelligence
ISCSupply Chain Intelligence
CSRScheduler
IEBInteraction Blending
MSDDemand Planning
HXCTime and Labor Engine
PQHPublic Sector HR
PQPPublic Sector Payroll
PSBPublic Sector Budgeting
GMSGrants Accounting
PSPLabor Distribution
IGWGrants Proposal
IGSStudent System
IGFFinancial Aid
IGCContract Commitment
PSAPublic Sector Financials
FVFederal Financials
ENIProduct Intelligence
PVPartner Management
ASLSales Offline
CUEBilling Connect (obsolete)
EAMEnterprise Asset Management
FTETransportation Execution
IGIPublic Sector Financials International
ITGInternet Procurement Enterprise Connector
OKRContracts for Rights (Obsolete)
IPDProduct Development (obsolete)
MSRInventory Optimization
PRGCProgress Custom
POSiSupplier Portal
BNEWeb Applications Desktop Integrator
ASPOracle Sales for Handhelds
BIVService Intelligence
CSIInstall Base
CSLField Service/Laptop
CUGCitizen Interaction Center
IMTiMeeting (obsolete)
OKIContracts Intelligence
IECAdvanced Outbound Telephony
CSEAsset Tracking
OKOContracts for Sales (Obsolete)
JTSCRM Self Service Administration
JTMMobile Application Foundation
AHLComplex Maintenance Repair and Overhaul
IMCCustomers Online
OKBContracts for Subscriptions (Obsolete)
XNIInstall Base Intelligence (Obsolete)
QRMRisk Management
PONSourcing
OKLLease and Finance Management
IBCContent Manager
AMFFulfillment Services (Obsolete)
QOTQuoting
CSMField Service/Palm
DOMDocument Managment and Collaboration
EGOAdvanced Product Catalog
DDDCADView-3D
PJIProject Intelligence
XNBOracle Telecommunications Billing Integrator
ZFAFinancial Analyzer
ZSASales Analyzer
CLNSupply Chain Trading Connector for RosettaNet
EDRE-Records
PRPProposals
OUCUniversity Curriculum
TESTtest
PSRPublic Sector Receivables
CSNCall Center
CLAAPAC Consulting Localizations
AMWInternal Controls Manager
XDOXML Publisher
WMAManufacturing Mobile Applications
ISXiSettlement
MIVMedia Interactive
OAMOracle Applications Manager
BIEeCommerce Intelligence
BINCommunications Intelligence
CUCRevenue Accounting
CURMass Market Receivables for Comms
IBTiAuction
XNAService Assurance for Communications
XNTTeleBusiness for Telecom/Utilities
MQAMobile Quality Applications
CTBClinical Transaction Base
IETCall Center Connectors
IEVIVR Integrator
IEPPredictive
HCPHealthcare Intelligence
HCAHealthcare
PBRBudgeting and Planning
IAMDigital Asset Management
OKTRoyalty Management
GNIGenealogy Intelligence
CPGCCPG – CDOA
HCCiHCConnect
HCNiHCIntegrate
AMEApprovals Management
OKPContracts for Procurement (Obsolete)
HCTHealthcare Terminology Server
MIAMobile Applications for Inventory Management
GMWProcess Manufacturing Portal
BIYSystems Intelligence
PFTOracle Profitability Manager
RMGRisk Manager
FTPTransfer Pricing
DNADevelopment
BLCUtility Billing
PTXPatch Tracking System
EMSEnvironment Management System
RCMRegulatory Capital Manager (obsolete)
JMFSupply Chain Localizations
IRCiRecruitment
GMOManufacturing Execution System for Process Manufacturing
IPMOracle Imaging Process Management
IBWOracle Web Analytics
XLELegal Entity Configurator
ASNSales
MSTTransportation Planning
FUNFinancials Common Modules
GCSFinancial Consolidation Hub
ZXE-Business Tax
LNSLoans
IAiAssets
FPAProject Portfolio Analysis
ZPBEnterprise Planning and Budgeting
BANKINGBanking
COREBANKCore Banking
INSTITBANKInstitutional Banking
IZUOracle E-Business Suite Diagnostics
DPPOracle Price Protection
MTHOracle Manufacturing Operations Center
QPROracle Deal Management
DDRDemand Signal Repository
INLOracle Landed Cost Management

1 Comments :

Thanks For Sharing your best thoughts. I've got really inspired to read your article. If the people want SMM Panel Services then don't miss the chance to visit our website.
Cheap SMM Panel
SMM Reseller Panel

Reply

Post a Comment