Oracle APPS
Important Table
ONT
– Order Management
Table Name Description
OE_ORDER_HEADERS_ALL OE_ORDER_HEADERS_ALL stores
header information for orders in Order management.
OE_ORDER_LINES_ALL OE_ORDER_LNES_ALL stores
information for all order lines in Oracle Order management.
OE_ORDER_SOURCES Feeder System Names that create
orders in Order management tables.
OE_ORDER_HOLDS_ALL This table stores information of
all the orders and lines that are on hold and the link to hold sources and hold
releases
OE_SALES_CREDITS This table stores information about
sales credits.
OE_TRANSACTION_TYPES_ALL This table stores
information about the order and line transaction types
WSH_DELIVERY_ASSIGNMENTS Delivery Assignments
WSH_DELIVERY_DETAILS Delivery Details
WSH_NEW_DELIVERIES Deliveries
WSH_TRIPS Trips
WSH_TRIP_STOPS Trip Stops
PO
– Purchasing
Table Name Description
PO_ACTION_HISTORY Document approval and control
action history table
PO_AGENTS Buyers table
PO_DISTRIBUTIONS_ALL Purchase order distributions
PO_HEADERS_ALL Document headers (for purchase
orders, purchase agreements, quotations, RFQs)
PO_LINES_ALL Purchase document line (for purchase
orders, purchase agreements, quotations, RFQs)
PO_LINES_LOCATIONS_ALL Document shipment schedules
(for purchase orders, purchase agreements, quotations, RFQs)
PO_RELEASES_ALL Purchase order releases
PO_LINES_ARCHIVE_ALL Archived purchase order lines
PO_LINES_LOCATIONS_ARCHIVE_ALL Archived purchase
order shipments
PO_HEADERS_ARCHIVE_ALL Archieved purchase orders
PO_LINE_TYPES_B Line types
PO_RELEASES_ARCHIVE_ALL Archived releases
PO_REQUISITION_HEADERS_ALL Requisition headers
PO_REQUISITION_LINES_ALL Requisition lines
PO_REQ_DISTRIBUTIONS_ALL Requisition distributions
RCV_TRANSACTIONS Receiving transactions
RCV_SHIPMENT_HEADERS Shipment and receipt header
information
RCV_SHIPMENT_LINES Receiving shipment line
information
INV
– Inventory
Table name Description
MTL_CATEGORIES_B Code combinations table for Item
Category
MTL_CATEGORY_SETS_B Category Sets
MTL_CUSTOMER_ITEMS Customer item Information
MTL_CUSTOMER_ITEM_XREFS Relationships between
customer item and inventory items
MTL_DEMAND Sales order demand and reservations
MTL_DEMAND_HISTORIES Sales order demand and
reservations
MTL_ITEM_LOCATIONS Definitions for stock locators
MTL_ITEM_REVISIONS_B Item revisions
MTL_ITEM_TEMPLATES_B Item template definitions
MTL_ITEM_TEMPL_ATTRIBUTES Item attributes and
attribute values for a template
MTL_LOT_NUMBERS Lot number definitions
MTL_MATERIAL_TRANSACTIONS Material transaction table
MTL_MATERIAL_TRANSACTIONS_TEMP Temporary table for
processing material transactions
MTL_ONHAND_QUANTITIES_DETAIL_FIFO Quantities by
control level and receipt
MTL_PARAMETERS Inventory control options and
defaults
MTL_RESERVATIONS Reservations
MTL_SECONDARY_INVENTORIES Subinventory definitions
MTL_SECONDARY_LOCATORS Item-subinventory-Locator
assignments
MTL_SERIAL_NUMBERS Serial number definitions
MTL_SYSTEM_ITEM_B Inventory item definitions
MTL_TRANSACTION_ACCOUNTS Material transaction
distributions
MTL_TRANSACTION_TYPES Inventory Transaction Types
Table
MTL_TXN_REQUEST_HEADERS Move Order header table
MTL_TXN_REQUEST_LINES Move Order lines table
MTL_UNIT_TRANSACTIONS Serial number transactions
GL
- General Ledger
Table Name Description
GL_CODE_COMBINATIONS Stores valid account
combinations
GL_SETS_OF_BOOKS Stores information about the sets
of books
GL_IMPORT_REFERENCES Stores individual transactions
for sub ledger
GL_DAILY_RATES Stores the daily conversion rates for
foreign currency
GL – Transactions
GL_PERIODS Stores information about the accounting
periods
GL_JE_HEADERS Stores journal entries
GL_JE_LINES Stores the journal entry lines that you
enter in the Enter Journals form
GL_JE_BATCHES Stores journal entry batches
GL_BALANCES Stores actual,budget, and encumbrace
balance for detail and summary accounts
GL_BUDGETS Stores Budget definitions
GL_INTERFACE Import journal entry batches
GL_BUDGET_INTERFACE Upload budget data from external
sources
GL_DAILY_RATES_INTERFACE Import daily conversion
rates
AR-Accounts
Receivables
Table name Description
RA_CUST_TRX_TYPES_ALL Transaction type for invoices,
commitments and credit memos
RA_CUSTOMER_TRX_ALL Header-level information about
invoices, debit memos, chargebacks, commitments and credit memos
RA_CUSTOMER_TRX_LINES_ALL Invoice, debit memo,
chargeback, credit memo and commitsment lines
RA_CUST_TRX_LINE_GL_DIST_ALL Accounting records for
revenue, unearned revenue and unbilled receibables
RA_CUST_TRX_LINE_SALESREPS_ALL Sales credit
assignments for transactions
AR_ADJUSTMENTS_ALL Pending and approved invoice
adjustments
AR_BATCHES_ALL
AR_CASH_RECEIPTS_ALL Detailed receipt information
AR_CASH_RECEIPT_HISTORY_ALL History of actions and
status changes in the life cycle of a receipt
AR_PAYMENT_SCHEDULES_ALL All transaction except
adjustments and miscellaneous cash receipts
AR_RECEIVABLE_APLICATIONS_ALL Accounting information
for cash and credit memo applications
AR_TRANSACTION_HISTORY_ALL Live cycle of a
transaction
HZ_CUST_ACCOUNTS Stores information about customer
accounts
HZ_CUSTOMER_PROFILES Credit information for customer
accounts and customer account sites
HZ_CUST_ACCT_SITES_ALL Stores all customer account
sites across all operating units
HZ_CUST_ACCT_RELATE_ALL Relationships between
customer accounts
HZ_CUST_CONTACT_POINTS This table is not longer used
HZ_CUST_PROF_CLASS_AMTS Customer profile class
amount limits for each currency
HZ_CUST_SITE_USES_ALL Stores business purpose
assigned to customer account sites
HZ_LOCATIONS Physical addresses
HZ_ORG_CONTACTS People as contacts for parties
HZ_ORG_CONTACT_ROLES Roles played by organization
contacts
HZ_PARTIES Information about parties such as
organizations, people and groups
HZ_PARTY_SITES link party to physical locations
HZ_PARTY_SITE_USES The way that a party uses a
prticular site or addrss
Hz_RELATIONSHIP Relationships between entities
HZ_RELATIONSHIP_TYPES Relationhip types
CE
_ Cash Management
Table Name Description
CE_BANK_ACCOUNTS This table contains bank account
informations. Each bank account must be affiliated with one bank branch