Most Frequently Used Tables in Oracle APPS

Most Frequently Used Tables in Oracle APPS

Following are the most frequently used tables throughout the whole Oracle Applications[ Oracle EBS]

CONCURRENT MANAGER

FND_CONCURRENT_REQUEST
FND_CONC_REQ_SUMMARY_V
FND_CONCURRENT_PROGRAMS_VL 
FND_REQUEST_GROUP_UNITS 
FND_REQUEST_GROUPS

GL Tables
GL_CODE_COMBINATIONS
GL_INTERFACE
GL_JE_BATCHES
GL_JE_HEADERS
GL_JE_LINES

ORACLE FINANCIALS – PAYABLES - INVOICES 
AP_INVOICES_INTERFACE
AP_INVOICE_LINES_INTERFACE

ORACLE FINANCIALS – RECEIVABLES - CUSTOMERS 
RA_CUSTOMERS_INTERFACE_ALL
RA_CUSTOMER_PROFILES_INT_ALL
RA_CONTACT_PHONES_INT_ALL
RA_CUSTOMER_BANKS_INT_ALL
RA_CUST_PAY_METHOD_INT_ALL
HZ_PARTY_INTERFACE

ORACLE FINANCIALS – RECEIVABLES - INVOICES 
RA_INTERFACE_LINES_ALL
RA_INTERFACE_DISTRIBUTIONS_ALL
RA_INTERFACE_SALESCREDITS_ALL

ORACLE FINANCIALS – RECEIVABLES – LOCK BOX 
AR_PAYMENTS_INTERFACE_ALL

ORACLE FINANCIALS – RECEIVABLES - TAX 
AR_TAX_INTERFACE

ORACLE FINANCIALS - CASH MANAGEMENT – BANK STATEMENTS 
CE_STATEMENT_HEADERS_INT_ALL
CE_STATEMENT_LINES_INTERFACE

ORACLE FINANCIALS - FIXED ASSETS 
FA_INV_INTERFACE

ORACLE FINANCIALS - GENERAL LEDGER – JOURNAL ENTRY 
GL_INTERFACE

ORACLE MANUFACTURING – COST MANAGEMENT 
CST_PC_ITEM_COST_INTERFACE
CST_PC_COST_DET_INTERFACE

ORACLE MANUFACTURING - INVENTORY 
MTL_REPLENISH_HEADERS_INT
MTL_REPLENISH_LINES_INT
MTL_SERIAL_NUMBERS_INTERFACE
MTL_SYSTEM_ITEMS_INTERFACE
MTL_TRANSACTION_LOTS_INTERFACE
MTL_TRANSACTIONS_INTERFACE

ORACLE MANUFACTURING – PURCHASING – PURCHASE ORDERS 
PO_HEADERS_INTERFACE
PO_LINES_INTERFACE
PO_DISTRIBUTIONS_INTERFACE
PO_REQUISITIONS_INTERFACE_ALL
PO_REQ_DIST_INTERFACE_ALL
PO_RESCHEDULE_INTERFACE

ORACLE MANUFACTURING – PURCHASING - RECEIVING 
RCV_HEADERS_INTERFACE
RCV_TRANSACTIONS_INTERFACE
RCV_LOTS_INTERFACE
RCV_SERIALS_INTERFACE

ORACLE MANUFACTURING - ORDER ENTRY – SALES ORDERS 
SO_HEADERS_INTERFACE_ALL
SO_HEADER_ATTRIBUTES_INTERFACE
SO_LINES_INTERFACE_ALL
SO_LINE_ATTRIBUTES_INTERFACE
SO_LINE_DETAILS_INTERFACE
SO_PRICE_ADJUSTMENTS_INTERFACE
SO_SALES_CREDITS_INTERFACE

ORACLE MANUFACTURING - MASTER SCHEDULING/MRP 
MRP_FORECAST_INTERFACE
MRP_SCHEDULE_INTERFACE

ORACLE MANUFACTURING - SHOP FLOOR MANAGEMENT 
WSM_LOT_JOB_INTERFACE
WSM_STARTING_LOTS_INTERFACE
WSM_LOT_MOVE_TXN_INTERFACE

ORACLE MANUFACTURING - QUALITY 
QA_RESULTS_INTERFACE

ORACLE MANUFACTURING - WORK IN PROCESS 
WIP_MOVE_TXN_INTERFACE
CST_COMP_SNAP_INTERFACE
WIP_COST_TXN_INTERFACE
WIP_JOB_SCHEDULE_INTERFACE
WIP_JOB_DTLS_INTERFACE

VERSION INFORMATION 
V$VERSION

DETAILED PATCH INFORMATION
APPS.FND_PRODUCT_INSTALLATIONS
APPS.FND_APPLICATION_ALL_VIEW

GENERIC PATCH INFORMATION
AD_APPLIED_PATCHES 

TABLE IS REFERENCED BY
USER_CONSTRAINTS

FIND THE # OF COLUMNS
INFORMATION_SCHEMA
USER_TAB_COLUMNS
SYSCOLUMNS

DATABASE NAME
GLOBAL_NAME
V$INSTANCE
V$DATABASE

ALL TABLES 
ALL_OBJECTS

PL/SQL 
USER_SOURCE 
USER_OBJECTS 
ALL_SOURCE
USER_SOURCE

DB LINKS
ALL_DB_LINKS