Query to find all APIs of Oracle Apps modules

Query to find all APIs of Oracle Apps modules
Query to list all APIs in Oracle EBS
List of all Oracle apps APIs
Syntax of Oracle EBS APIs
oracle ebs api list
oracle ebs inventory api

  SELECT SUBSTR (a.OWNER, 1, 20),
         SUBSTR (a.NAME, 1, 30),
         SUBSTR (a.TYPE, 1, 20),
         SUBSTR (u.status, 1, 10) Stat,
         u.last_ddl_time,
         SUBSTR (text, 1, 80)   Description
    FROM dba_source a, dba_objects u
   WHERE     u.object_name = a.name
         AND a.text LIKE '%Header%'
         AND a.TYPE = u.object_type
         AND a.name LIKE 'AR_%API%'               -- Check for AR Related APIs
ORDER BY a.owner, a.name;

Related posts:

• PTD and YTD balances query in Oracle R12
• Register a test concurrent program from backend in Oracle EBS
• Supervisor Hierarchy and Approval Limits in Oracle EBS R12
• Sales order line status query in Oracle apps
• Query to find all Expense report entry delegations
• Query to find vacation rules in Oracle R12
• Purchase Order Receipt details query in Oracle apps
• Oracle apps query to find approval limits
• View accounting query in oracle apps R12
• Query to get AR invoice SLA and GL details
• Accounting entries not transferred to the General Ledger
• View java class source in oracle database
• Load Java source code in oracle database
• Query to get price list details in Oracle EBS
• Query to find all APIs of Oracle Apps modules
• Oracle R12 shipping status query
• OAF customizations queries
• Oracle apps list of concurrent programs in a Request Set
• R12 AR cash receipt SLA and GL details query
• Oracle apps AR Applications and SLA details
• Oracle EBS query to get AP Invoice SLA Details
• Oracle EBS query to get AR Invoice SLA Details
• Query to get Organization Hierarchy in Oracle apps
• Oracle apps query to find incompatible programs blocking a concurrent request
• Oracle AR Remit to address query
• Oracle Apps iExpense credit card details query
• Form function attached to which responsibility and user
• E-Business suite tax rates and accounts query
• Query to get customer tax registration details in R12
• Query to get Sales order and lines details in Oracle Apps
• Purchase Requisition Vertex debug xml query in Oracle EBS
• Purchase Order Vertex debug xml query in Oracle EBS
• AP Invoice Vertex debug xml query in Oracle EBS
• AR Invoice Vertex debug xml query in Oracle EBS
• Query to find AP invoice workflow item key in oracle apps
• Query to find the responsibility attached to user in oracle apps
• How to enable debug log in Oracle apps EBS
• Query to find and remove Oracle database locks
• How to add AME role and responsibility to user
• Oracle form attached to which responsibility
• Query to get workflow details
• Query to find serial number material transactions details
• SQL query to get MIME type for file extension
• Query to get concurrent program and executable details
• Query to get responsibility level profile option values
• Query to validate migration of XML/BI Publisher Template and Data Definition
• Query to get details of XML/BI Publisher Template and Data Definition
• Query to get Site level and Organization level Profile Option Value
• Query to get attribute values of Inventory Item Template
• Query to find period status for Inventory General Ledger Purchasing Payables Receivables Fixed Assets
• Oracle apps EBS sql to get Fixed Asset (FA) details with Net Book Value (NBV) and Depreciation
• Query to find Sales Orders that are shipped but not invoiced
• Query to get details of WIP discrete jobs
• Query to get Customer Bank Account Details
• Query to get description of GL Code Combination
• PL-SQL code to reset application user password
• PL-SQL code to write a file
• PL-SQL code to read a file
• Query to find second and third highest value
• PL-SQL Procedure to send email with attachment
• PL-SQL to delete Concurrent Program and Executable
• Query to get the details of the lock in the database
• PL-SQL code to delete XML/BI Publisher template and Data Definition
• Query to find Purchase Order and Invoice Details
• Query to find AP Invoices matched with receipts
• Query to find Table size
• Query to find Form Personalization
• Query to find Supplier Bank Details
• Query to find Credit Memos on an AP invoice
• Query to find the AP invoices that are applied to multiple Purchase Orders
• Query to find profile option values
• Query to get details of concurrent program parameters
• PL-SQL Code to find Menu Hierarchy of a responsibility
• Query to find details of Flex value sets
• Query to find concurrent program Responsibility and Request Group
• Query to find BOM and Routings data
• Concurrent program SQL statement currently running in background
• AR Invoice grouping rule from RA_INTERFACE_LINES_ALL
• Query to find shipset and fulfilment set
• Query to find scheduled concurrent programs
• Query to kill database session for a concurrent request
• Query to get DFF (Descriptive Flex Field) Details

Upload your own post and refer it anywhere anytime: