Oracle Apps Tables Name (Most Ueses)

General Ledger (GL)

GL_JE_BATCHES
GL_JE_HEADERS
GL_JE_LINES
GL_CODE_COMBINATIONS
GL_BALANCES
GL_JE_CATEGORIES_TL
GL_JE_SOURCES_TL

GL_LEDGERS
GL_SETS_OF_BOOKS

 Accounts Payables (AP):


AP_INVOICES_ALL
AP_EXPENSE_REPORT_HEADERS_ALL
AP_INVOICE_RELATIONSHIPS
AP_INVOICE_DISTRIBUTIONS_ALL
AP_PAYMENT_SCHEDULES_ALL
AP_HOLDS_ALL
AP_AE_LINES_ALL
AP_AE_HEADERS_ALL
AP_CHECKS_ALL

 Accounts Receivables (AR):

RA_CUSTOMER_TRX_ALL
RA_CUST_TRX_TYPES_ALL
RA_CUSTOMER_TRX_LINES_ALL
RA_CUST_TRX_LINE_GL_DIST_ALL
AR_PAYMENT_SCHEDULES_ALL
AR_CASH_RECEIPTS_ALL
AR_RECEIVABLES_TRX_ALL
AR_RECEIPT_METHOD_ACCOUNTS_ALL
AR_RECEIVABLE_APPLICATIONS_ALL

Oracle Inventory (INV)

MTL_SYSTEM_ITEMS_B
MTL_SYSTEM_ITEMS_TL
MTL_ITEM_CATEGORIES
MTL_ITEM_SUB_INVENTORIES
MTL_CATEGORIES_B
MTL_CATEGORY_SETS_B
MTL_CATEGORY_SETS_TL
MTL_DEMAND
MTL_ONHAND_QUANTITIES
MTL_MATERIAL_TRANSACTIONS_TEMP
MTL_SYSTEM_ITEMS_FVL
MTL_LOT_NUMBERS
MTL_UNITS_OF_MEASURE_TL
MTL_TXN_SOURCE_TYPES
MTL_MATERIAL_TRANSACTIONS
MTL_TRANSACTION_TYPES
MTL_SECONDARY_INVENTORIES -------Sub Inventory Table
MTL_ITEM_LOCATIONS  -------Locator Table

Purchasing (PO)
PO_HEADERS_ALL
PO_LINES_ALL
PO_LINE_LOCATIONS_ALL
PO_DISTRIBUTIONS_ALL
PO_REQUISITION_HEADERS_ALL
PO_REQUISITION_HEADERS_ALL
PO_REQUISITION_LINES
PO_REQ_DISTRIBUTIONS_ALL
PO_VENDORS
PO_VENDOR_SITES_ALL

Order Management (OM)
Entered
OE_ORDER_HEADERS_ALL
OE_ORDER_LINES_ALL
OE_PRICE_ADJUSTMENTS
OE_ORDER_PRICE_ATTRIBS
OE_ORDER_HOLDS_ALL
Booked
OE_ORDER_HEADERS_ALL
WSH_DELIVERY_DETAILS

Pick Released 
WSH_DELIVERY_DETAILS
WSH_PICKING_BATCHES
MTL_RESERVATIONS

Full Transaction
MTL_MATERIAL_TRANSACTIONS
MTL_TXN_REQUEST_HEADERS
MTL_TXN_REQUEST_LINES
WSH_DELIVERY_DETAILS
WSH_NEW_DELIVERIES
WSH_DELIVERY_ASSIGNMENTS

Pick Confirmed
WSH_DELIVERY_DETAILS
Ship Confirmed
WSH_DELIVERY_DETAILS
MTL_MATERIAL_TRANSACTIONS
WSH_NEW_DELIVERIES
OE_ORDER_LINES_ALL
WSH_DELIVERY_LEGS
OE_ORDER_HEADERS_ALL

Auto invoice
WSH_DELIVERY_DETAILS
RA_INTERFACE_LINES_ALL
RA_CUSTOMER_TRX_ALL
RA_CUSTOMER_TRX_LINES_ALL

Price Details
QP_LIST_HEADERS_B
QP_PRICING_ATTRIBUTES
QP_LIST_LINES

Payment Terms
RA_TERMS
Auto Matic Numbering System
AR_SYSTEM_PARAMETES_ALL

Fixed Assets 
FA_ADDITIONS_B
FA_ADDITIONS_TL
FA_ADJUSTMENTS
FA_ADJUSTMENTS_T

Customer Information
HZ_PARTIES
HZ_PARTY_SITES
HZ_LOCATIONS
HZ_CUST_ACCOUNTS
HZ_CUST_ACCOUNT_SITES_ALL
HZ_CUST_SITE_USES_ALL
HZ_CUSTOMER_PROFILES
HZ_CUST_PROFILE_CLASSES
RA_CUSTOMERS

TAX
JAI_TAX_LINES
JAI_CMN_TAXES_ALL
JAI_PO_TAXES
JAI_CMN_INVENTORY_ORGS
JAI_RGM_REGISTRATIONS
JAI_OM_OE_SO_TAXES

Projects

PA_PROJECTS_ALL



Posted by
Labels: