Oracle APPS Important Tables

ONT	Order Management
OE_ORDER_HEADERS_ALL	OE_ORDER_HEADERS_ALL stores header information for orders in Order Management.
OE_ORDER_LINES_ALL	OE_ORDER_LINES_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
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 lines (for purchase orders, purchase agreements, quotations, RFQs)
PO_LINE_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_LINE_LOCATIONS_ARCHIVE_ALL	Archived purchase order shipments
PO_HEADERS_ARCHIVE_ALL	Archived 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
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 items 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_ITEMS_B	Inventory item definitions
MTL_TRANSACTION_ACCOUNTS	Material transaction distributions
MTL_TRANSACTION_TYPES	Inventory Transaction Types Table
MTL_TXN_REQUEST_HEADERS	Move Order headers table
MTL_TXN_REQUEST_LINES	Move order lines table
MTL_UNIT_TRANSACTIONS	Serial number transactions
GL	General Ledger
GL_CODE_COMBINATIONS	Stores valid account combinations
GL_SETS_OF_BOOKS	Stores information about the sets of books
GL_IMPORT_REFERENCES	Stores individual transactions from subledgers
GL_DAILY_RATES	Stores the daily conversion rates for foreign currency 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 encumbrance balances 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
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 commitment lines
RA_CUST_TRX_LINE_GL_DIST_ALL	Accounting records for revenue, unearned revenue and unbilled receivables
RA_CUST_TRX_LINE_SALESREPS_ALL	Sales credit assignments for transactions
AR_ADJUSTMENTS_ALL	Pending and approved invoice adjustments
RA_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 transactions except adjustments and miscellaneous cash receipts
AR_RECEIVABLE_APPLICATIONS_ALL	Accounting information for cash and credit memo applications
AR_TRANSACTION_HISTORY_ALL	Life 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 no longer used
HZ_CUST_PROF_CLASS_AMTS	Customer profile class amount limits for each currency
HZ_CUST_SITE_USES_ALL	Stores business purposes 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	Links party to physical locations
HZ_PARTY_SITE_USES	The way that a party uses a particular site or address
HZ_RELATIONSHIPS	Relationships between entities
HZ_RELATIONSHIP_TYPES	Relationship types
CE	Cash Management
CE_BANK_ACCOUNTS	This table contains bank account information. Each bank account must be affiliated with one bank branch.
CE_BANK_ACCT_BALANCES	This table stores the internal bank account balances
CE_BANK_ACCT_USES_ALL	This table stores information about your bank account uses.
CE_STATEMENT_HEADERS	Bank statements
CE_STATEMENT_LINES	Bank statement lines
CE_STATEMENT_HEADERS_INT	Open interface for bank statements
CE_STATEMENT_LINES_INTERFACE	Open interface for bank statement lines
CE_TRANSACTION_CODES	Bank transaction codes
AP-	Accounts Payables
Table	Name Description
AP_ACCOUNTING_EVENTS_ALL	Accounting events table
AP_AE_HEADERS_ALL	Accounting entry headers table
AP_AE_LINES_ALL	Accounting entry lines table
AP_BANK_ACCOUNTS_ALL	Bank Account Details
AP_BANK_ACCOUNT_USES_ALL	Bank Account Uses Information
AP_BANK_BRANCHES	Bank Branches
AP_BATCHES_ALL	Summary invoice batch information
AP_CHECKS_ALL	Supplier payment data
AP_HOLDS_ALL	Invoice hold information
AP_INVOICES_ALL	Detailed invoice records
AP_INVOICE_LINES_ALL	AP_INVOICE_LINES_ALL contains records for invoice lines entered manually, generated automatically or imported from the Open Interface.
AP_INVOICE_DISTRIBUTIONS_ALL	Invoice distribution line information
AP.AP_INVOICE_PAYMENTS_ALL	Invoice payment records
AP_PAYMENT_DISTRIBUTIONS_ALL	Payment distribution information
AP_PAYMENT_HISTORY_ALL	Maturity and reconciliation history for Payments
AP_PAYMENT_SCHEDULES_ALL	Scheduled payment information on invoices
AP_INTERFACE_REJECTIONS	Information about data that could not be loaded by Payables Open Interface Import
AP_INVOICES_INTERFACE	Information used to create an invoice using Payables Open Interface Import
AP_INVOICE_LINES_INTERFACE	Information used to create one or more invoice distributions
AP_SUPPLIERS	AP_SUPPLIERS stores information about your supplier level attributes.
AP_SUPPLIER_SITES_ALL	AP_SUPPLIER_SITES_ALL stores information about your supplier site level attributes.
AP_SUPPLIER_CONTACTS	Stores Supplier Contacts
FA	Fixed Assets
FA_ADDITIONS_B	Descriptive information about assets
FA_ADJUSTMENTS	Information used by the posting program to generate journal entry lines in the general ledger
FA_ASSET_HISTORY	Historical information about asset reclassifications and unit adjustments
FA_ASSET_INVOICES	Accounts payable and purchasing information for each asset
FA_BOOKS	Financial information of each asset
FA_BOOK_CONTROLS	Control information that affects all assets in a depreciation book
FA_CALENDAR_PERIODS	Detailed calendar information
FA_CALENDAR_TYPES	General calendar information
FA_CATEGORIES_B	Default financial information for asset categories
FA_CATEGORY_BOOKS	Default financial information for an asset category and depreciation book combination
FA_DEPRN_DETAIL	Depreciation amounts charged to the depreciation expense account in each distribution line
FA_DEPRN_PERIODS	Information about each depreciation period
FA_DEPRN_EVENTS	Information about depreciation accounting events.
FA_DEPRN_SUMMARY	Depreciation information at the asset level
FA_DISTRIBUTION_ACCOUNTS	Table to store account ccids for all distributions for a book
FA_DISTRIBUTION_DEFAULTS	Distribution set information
FA_DISTRIBUTION_HISTORY	Employee, location, and Accounting Flexfield values assigned to each asset
FA_DISTRIBUTION_SETS	Header information for distribution sets
FA_FORMULAS	Depreciation rates for formula-based methods
FA_LOCATIONS	Location flexfield segment value combinations
FA_MASS_ADDITIONS	Information about assets that you want to automatically add to Oracle Assets from another system
FA_METHODS	Depreciation method information
FA_RETIREMENTS	Information about asset retirements and reinstatements
HRMS	Human Resource Management System
HR_ALL_ORGANIZATION_UNITS	Organization unit definitions.
HR_ALL_POSITIONS_F	Position definition information.
HR_LOCATIONS_ALL	Work location definitions.
PER_ADDRESSES	Address information for people
PER_ALL_PEOPLE_F	DateTracked table holding personal information for employees, applicants and other people.
PER_ALL_ASSIGNMENTS_F	Allocated Tasks
PER_ANALYSIS_CRITERIA	Flexfield combination table for the personal analysis key flexfield.
PER_ASSIGNMENT_EXTRA_INFO	Extra information for an assignment.
PER_ASSIGNMENT_STATUS_TYPES	Predefined and user defined assignment status types.
PER_CONTRACTS_F	The details of a persons contract of employment
PER_CONTACT_RELATIONSHIPS	Contacts and relationship details for dependents, beneficiaries, emergency contacts, parents etc.
PER_GRADES	Grade definitions for a business group.
PER_JOBS	Jobs defined for a Business Group
PER_PAY_BASES	Definitions of specific salary bases
PER_PAY_PROPOSALS	Salary proposals and performance review information for employee assignments
PER_PEOPLE_EXTRA_INFO	Extra information for a person
PER_PERIODS_OF_PLACEMENT	Periods of placement details for a non-payrolled worker
PER_PERIODS_OF_SERVICE	Period of service details for an employee.
PER_PERSON_ANALYSES	Special information types for a person
PER_PERSON_TYPES	Person types visible to specific Business Groups.
PER_PERSON_TYPE_USAGES_F	Identifies the types a person may be.
PER_PHONES	PER_PHONES holds phone numbers for current and ex-employees, current and ex-applicants and employee contacts.
PER_SECURITY_PROFILES	Security profile definitions to restrict user access to specific HRMS records
PAY	Payroll
PAY_ACTION_INFORMATION	Archived data stored by legislation
PAY_ALL_PAYROLLS_F	Payroll group definitions.
PAY_ASSIGNMENT_ACTIONS	Action or process results, showing which assignments have been processed by a specific payroll action, or process.
PAY_ELEMENT_CLASSIFICATIONS	Element classifications for legislation and information needs.
PAY_ELEMENT_ENTRIES_F	Element entry list for each assignment.
PAY_ELEMENT_ENTRY_VALUES_F	Actual input values for specific element entries.
PAY_ELEMENT_LINKS_F	Eligibility rules for an element type.
PAY_ELEMENT_TYPES_F	Element definitions.
PAY_ELEMENT_TYPE_USAGES_F	Used to store elements included or excluded from a defined run type.
PAY_ORG_PAYMENT_METHODS_F	Payment methods used by a Business Group.
PAY_PAYMENT_TYPES	Types of payment that can be processed by the system.
PAY_PAYROLL_ACTIONS	Holds information about a payroll process.
PAY_PEOPLE_GROUPS	People group flexfield information.
PAY_PERSONAL_PAYMENT_METHODS_F	Personal payment method details for an employee.
PAY_RUN_RESULTS	Result of processing a single element entry.
PAY_RUN_RESULT_VALUES	Result values from processing a single element entry.
PAY_SECURITY_PAYROLLS	List of payrolls and security profile access rules.
PAY_INPUT_VALUES_F	Input value definitions for specific elements.
BOM	Bills Of Material
BOM_DEPARTMENTS	Departments
BOM_DEPARTMENT_CLASSES	Department classes
BOM_DEPARTMENT_RESOURCES	Resources associated with departments
BOM_OPERATIONAL_ROUTINGS	Routings
BOM_OPERATION_NETWORKS	Routing operation networks
BOM_OPERATION_RESOURCES	Resources on operations
BOM_OPERATION_SEQUENCES	Routing operations
BOM_OPERATION_SKILLS
BOM_RESOURCES	Resources, overheads, material cost codes, and material overheads
BOM_STANDARD_OPERATIONS	Standard operations
BOM_ALTERNATE_DESIGNATORS	Alternate designators
BOM_COMPONENTS_B	Bill of material components
BOM_STRUCTURES_B	Bills of material
BOM_STRUCTURE_TYPES_B	Structure Type master table
WIP	Work in Process
WIP_DISCRETE_JOBS	Discrete jobs
WIP_ENTITIES	Information common to jobs and schedules
WIP_LINES	Production lines
WIP_MOVE_TRANSACTIONS	Shop floor move transactions
WIP_MOVE_TXN_ALLOCATIONS	Move transaction allocations for repetitive schedules
WIP_OPERATIONS	Operations necessary for jobs and schedules
WIP_OPERATION_NETWORKS	Operation dependency
WIP_OPERATION_OVERHEADS	Overheads for operations in an average costing organization
WIP_OPERATION_RESOURCES	Resources necessary for operations
WIP_OPERATION_YIELDS	This table keeps all costing information for operation yield costing.
WIP_TRANSACTIONS	WIP resource transactions
WIP_TRANSACTION_ACCOUNTS	Debits and credits due to resource transactions
FND	Appication Object Library
FND_APPLICATION	Applications registered with Oracle Application Object Library
FND_CONCURRENT_PROGRAMS	Concurrent programs
FND_CONCURRENT_REQUESTS	Concurrent requests information
FND_CURRENCIES	Currencies enabled for use at your site
FND_DATA_GROUPS	Data groups registered with Oracle Application Object Library
FND_FLEX_VALUES	Valid values for flexfield segments
FND_FLEX_VALUE_HIERARCHIES	Child value ranges for key flexfield segment values
FND_FLEX_VALUE_SETS	Value sets used by both key and descriptive flexfields
FND_FORM	Application forms registered with Oracle Application Object Library
FND_FORM_FUNCTIONS	Functionality groupings
FND_ID_FLEXS	Registration information about key flexfields
FND_ID_FLEX_SEGMENTS	Key flexfield segments setup information and correspondences between table columns and key flexfield segments
FND_ID_FLEX_STRUCTURES	Key flexfield structure information
FND_LOOKUP_TYPES	Oracle Application Object Library QuickCodes
FND_LOOKUP_VALUES	QuickCode values
FND_MENUS	New menu tabl for Release 10SC
FND_PROFILE_OPTIONS	User profile options
FND_PROFILE_OPTION_VALUES	Values of user profile options defined at different profile levels
FND_REQUEST_SETS	Reports sets
FND_REQUEST_SET_PROGRAMS	Reports within report sets
FND_REQUEST_SET_STAGES	Stores request set stages
FND_RESPONSIBILITY	Responsibilities
FND_RESP_FUNCTIONS	Function Security
FND_USER	Application users
JA	Asia/Pacific Localizations
JAI_CMN_BOE_HDRS	Stores BOE header info when a BOE Invoice is created through IL
JAI_CMN_BOE_DTLS	Detail table for BOE Invoices
JAI_CMN_TAXES_ALL	Master table for Localization Taxes
JAI_CMN_TAX_CTGS_ALL	Stores tax categories and their link to excise ITEM classes.
JAI_CMN_TAX_CTG_LINES	Stores the tax lines for defined tax categories
JAI_CMN_VENDOR_SITES	Stores excise account related information about vendors.
JAI_RGM_DEFINITIONS	Stores regime information.
JAI_RGM_TAXES	This table stores tax details for transactions having TCS tax type.
JAI_CMN_RG_23AC_I_TRXS	Stores Information of RG23A/C records and known as Quantity Register.
JAI_CMN_RG_23AC_II_TRXS	Stores Information of RG23A/C Part II Details. Also known as Amount Register
JAI_CMN_RG_23D_TRXS	Quantity register for Trading Organizations
JAI_CMN_RG_BALANCES	Store the current balances of RG23A, RG23C and PLA Registers
JAI_CMN_RG_PLA_TRXS	Stores the Transaction Information of PLA Register.
JAI_CMN_RG_PLA_HDRS	Stores PLA header Infomation when a PLA invoice is created in AP module
JAI_CMN_RG_PLA_DTLS	Stores PLA Detail Information when a PLA Invoice is created in AP Module
QP	Advanced Pricing
QP_LIST_HEADERS_B	QP_LIST_HEADERS_B stores the header information for all lists. List types can be, for example, Price Lists, Discount Lists or Promotions.
QP_LIST_LINES	QP_LIST_LINES stores all list lines for lists in QP_LIST_HEADERS_B.
QP_PRICE_FORMULAS_B	QP_PRICE_FORMULAS_B stores the pricing formula header information.
QP_PRICE_FORMULA_LINES	QP_PRICE_FORMULA_LINES stores each component that makes up the formula.
QP_PRICING_ATTRIBUTES	QP_PRICING_ATTRIBUTES stores product information and pricing attributes.
QP_QUALIFIERS	QP_QUALIFIERS stores qualifier attribute information.
XLA	Subledger Accounting
XLA_EVENTS	The XLA_EVENTS table record all information related to a specific event. This table is created as a type XLA_ARRAY_EVENT_TYPE.
XLA_TRANSACTION_ENTITIES	The table XLA_ENTITIES contains information about sub-ledger document or transactions.
XLA_AE_HEADERS	The XLA_AE_HEADERS table stores subledger journal entries. There is a one-to-many relationship between accounting events and journal entry headers.
XLA_AE_LINES	The XLA_AE_LINES table stores the subledger journal entry lines. There is a one-to-many relationship between subledger journal entry headers and subledger journal entry lines.
XLA_DISTRIBUTION_LINKS	The XLA_DISTRIBUTION_LINKS table stores the link between transactions and subledger journal entry lines.
XLA_ACCOUNTING_ERRORS	The XLA_ACCOUNTING_ERRORS table stores the errors encountered during execution of the Accounting Program.
XLA_ACCTG_METHODS_B	The XLA_ACCTG_METHODS_B table stores Subledger Accounting Methods (SLAM) across products. SLAMs provided by development are not chart of accounts specific. Enabled SLAMs are assigned to ledgers.
XLA_EVENT_TYPES_B	The XLA_EVENT_TYPES_B table stores all event types that belong to an event class.
XLA_GL_LEDGERS	This table contains ledger information used by subledger accounting.