Oracle E-Business Suite Tables and Field Explorer

• MTL_SYSTEM_ITEMS_BItemsItem master: one row per item per inventory organization, with every item attribute (control flags, planning, costing, order management, purchasing).
• MTL_SYSTEM_ITEMS_TLItemsItem descriptions in each installed language.
• MTL_ITEM_CATEGORIESItemsItem category assignments: which category an item belongs to in each category set and organization.
• MTL_CATEGORIES_BItemsItem categories: the code combinations of the Item Categories key flexfield.
• MTL_ITEM_REVISIONS_BItemsItem revisions with their effectivity dates and the ECO that implemented them.
• MTL_UNITS_OF_MEASURE_TLItemsUnits of measure: name, code, class and whether the unit is the base unit of its class.
• MTL_UOM_CONVERSIONSItemsUnit of measure conversions to the base unit of the class, both standard and item specific.
• MTL_PARAMETERSInventoryInventory organization parameters: organization code, item master org, costing method, calendar and default accounts.
• MTL_SECONDARY_INVENTORIESInventorySubinventories of each organization, with asset, quantity tracking, locator control and accounts.
• MTL_ITEM_LOCATIONSInventoryStock locators: the key flexfield combinations for row, rack and bin inside a subinventory.
• MTL_ONHAND_QUANTITIES_DETAILInventoryOn hand quantity by item, organization, subinventory, locator, lot and revision, one row per receipt layer (FIFO).
• MTL_MATERIAL_TRANSACTIONSInventoryMaterial transactions: every completed receipt, issue, transfer, shipment and adjustment, with source and cost.
• MTL_TRANSACTION_TYPESInventoryInventory transaction types, each tied to an action and a source type.
• MTL_TXN_SOURCE_TYPESInventoryTransaction source types, such as purchase order, sales order, job or schedule, account and account alias.
• MTL_TRANSACTION_ACCOUNTSCostingMaterial transaction distributions: the accounting lines created by the cost manager for each material transaction.
• MTL_LOT_NUMBERSInventoryLot definitions per item and organization, with expiration and status.
• MTL_SERIAL_NUMBERSInventorySerial numbers with their current status, organization, subinventory, locator and last transaction.
• MTL_RESERVATIONSInventoryReservations of supply (on hand, PO, job) against demand such as sales order lines.
• MTL_TXN_REQUEST_HEADERSInventoryMove order headers: requisition, replenishment, pick wave and manufacturing pick move orders.
• MTL_TXN_REQUEST_LINESInventoryMove order lines: item, quantities requested, detailed and delivered, from and to subinventory.
• MTL_MATERIAL_TRANSACTIONS_TEMPInventoryPending material transactions and allocations, waiting for the transaction manager or for pick confirmation.
• BOM_STRUCTURES_BBOM and routingBill of material headers: one row per assembly, organization and alternate.
• BOM_COMPONENTS_BBOM and routingBill of material components: quantity, operation, supply type and effectivity of each component.
• BOM_OPERATIONAL_ROUTINGSBOM and routingRouting headers: one row per assembly, organization and alternate routing.
• BOM_OPERATION_SEQUENCESBOM and routingRouting operations: sequence, department, standard operation and effectivity.
• BOM_OPERATION_RESOURCESBOM and routingResources used on each routing operation, with usage rate and basis.
• BOM_DEPARTMENTSBOM and routingDepartments (work centers) of each organization.
• BOM_RESOURCESBOM and routingResources, overheads, material cost codes and material overheads.
• WIP_ENTITIESWIP productionEvery WIP job and schedule name with its entity type and assembly.
• WIP_DISCRETE_JOBSWIP productionDiscrete job details: status, class, quantities, dates and the BOM and routing used.
• WIP_OPERATIONSWIP productionJob and schedule operations with quantities in each intraoperation step.
• WIP_REQUIREMENT_OPERATIONSWIP productionMaterial requirements of jobs and schedules: the component list copied from the bill at job creation.
• WIP_OPERATION_RESOURCESWIP productionResources required on job operations, with applied units and value.
• WIP_TRANSACTIONSWIP productionWIP resource and overhead transactions charged to jobs.
• WIP_PERIOD_BALANCESCostingJob value by accounting period: costs in, relieved and variances by cost element and level.
• WIP_ACCOUNTING_CLASSESCostingWIP accounting classes and their valuation and variance accounts.
• CST_ITEM_COSTSCostingItem cost summary per item, organization and cost type (Frozen, Average, Pending and user types).
• CST_ITEM_COST_DETAILSCostingItem cost detail by cost element, level, resource and operation.
• CST_COST_TYPESCostingCost type definitions, such as Frozen, Average and Pending.
• OE_ORDER_HEADERS_ALLOrder Management and shippingSales order headers in Order Management, one row per order across all operating units.
• OE_ORDER_LINES_ALLOrder Management and shippingSales order lines: item, quantities, prices, warehouse, dates and workflow status.
• OE_TRANSACTION_TYPES_ALLOrder Management and shippingOrder and line transaction types: category, default price list, default line types and the Receivables transaction type.
• OE_TRANSACTION_TYPES_TLOrder Management and shippingNames of order and line transaction types in each language.
• OE_ORDER_HOLDS_ALLOrder Management and shippingHolds applied to orders and lines, linked to the hold source and any release.
• OE_HOLD_SOURCES_ALLOrder Management and shippingHold sources: the criteria (order, customer, item and so on) a hold was applied by.
• OE_PRICE_ADJUSTMENTSOrder Management and shippingPrice adjustments, freight and special charges applied to orders and lines.
• QP_LIST_HEADERS_BOrder Management and shippingPrice list and modifier list headers in Advanced Pricing.
• QP_LIST_LINESOrder Management and shippingPrice list lines and modifier lines.
• WSH_DELIVERY_DETAILSOrder Management and shippingDelivery lines in Shipping Execution: one or more per order line, with pick release status and shipped quantity.
• WSH_DELIVERY_ASSIGNMENTSOrder Management and shippingLinks delivery details to deliveries and to parent containers.
• WSH_NEW_DELIVERIESOrder Management and shippingDeliveries: a set of delivery lines shipped together to one destination.
• PO_HEADERS_ALLPurchasing and receivingPurchasing document headers: standard POs, blanket and contract agreements, planned POs and quotations.
• PO_LINES_ALLPurchasing and receivingPurchase order and agreement lines: item, description, price, quantity and category.
• PO_LINE_LOCATIONS_ALLPurchasing and receivingPO shipments (schedules): ship to org, dates, quantities received, accepted and billed, and match option.
• PO_DISTRIBUTIONS_ALLPurchasing and receivingPO distributions: charge, accrual and variance accounts, destination, and the requisition or project they came from.
• PO_RELEASES_ALLPurchasing and receivingReleases against blanket agreements and planned POs.
• PO_REQUISITION_HEADERS_ALLPurchasing and receivingRequisition headers, purchase and internal.
• PO_REQUISITION_LINES_ALLPurchasing and receivingRequisition lines: item, quantity, need by date, destination and the PO shipment that fulfilled it.
• PO_AGENTSPurchasing and receivingBuyers: employees set up as purchasing agents.
• PO_ACTION_HISTORYPurchasing and receivingApproval and action history of purchasing documents.
• RCV_SHIPMENT_HEADERSPurchasing and receivingReceipt and ASN headers: receipt number, source, supplier and organization.
• RCV_SHIPMENT_LINESPurchasing and receivingReceipt lines: item and quantities shipped and received against a PO shipment, internal requisition or RMA.
• RCV_TRANSACTIONSPurchasing and receivingReceiving transactions: receive, accept, reject, transfer, deliver, return and correct, chained by parent transaction.
• HZ_PARTIESCustomers and suppliersTrading Community Architecture parties: organizations, people, groups and relationships behind customers and suppliers.
• HZ_CUST_ACCOUNTSCustomers and suppliersCustomer accounts: the selling relationship with a party, referenced by orders and invoices.
• HZ_CUST_ACCT_SITES_ALLCustomers and suppliersCustomer account sites per operating unit, pointing to a party site.
• HZ_CUST_SITE_USES_ALLCustomers and suppliersBusiness purposes of a customer site: bill to, ship to, statements, dunning and others.
• HZ_PARTY_SITESCustomers and suppliersParty sites: the link between a party and a location.
• HZ_LOCATIONSCustomers and suppliersPhysical addresses used by customers and, since R12, by supplier sites.
• HZ_CUSTOMER_PROFILESCustomers and suppliersCustomer credit profiles at account or site level: profile class, credit hold, terms and collector.
• AP_SUPPLIERSCustomers and suppliersSuppliers (vendors): name, number, type, terms and the TCA party behind them.
• AP_SUPPLIER_SITES_ALLCustomers and suppliersSupplier sites per operating unit: address, pay and purchasing flags, terms and liability account.
• AP_INVOICES_ALLPayablesPayables invoice headers: supplier, number, date, amount, type, payment status and terms.
• AP_INVOICE_LINES_ALLPayablesPayables invoice lines (R12): item, freight, tax and miscellaneous lines with their PO and receipt match.
• AP_INVOICE_DISTRIBUTIONS_ALLPayablesPayables invoice distributions: account, amount, period and validation and accounting status.
• AP_PAYMENT_SCHEDULES_ALLPayablesInvoice installments: due date, gross amount, amount remaining, discount and hold.
• AP_HOLDS_ALLPayablesInvoice holds placed by validation or by users, and their releases.
• AP_CHECKS_ALLPayablesPayments (checks, EFT, wires): number, date, amount, supplier, status and bank account.
• AP_INVOICE_PAYMENTS_ALLPayablesInvoice payments: which payment paid which invoice installment and for how much.
• RA_CUSTOMER_TRX_ALLReceivablesReceivables transaction headers: invoices, credit memos, debit memos, deposits and chargebacks.
• RA_CUSTOMER_TRX_LINES_ALLReceivablesReceivables transaction lines: item, tax and freight lines with their sales order reference.
• RA_CUST_TRX_LINE_GL_DIST_ALLReceivablesReceivables accounting distributions: receivable, revenue, tax, freight and unearned accounts.
• RA_CUST_TRX_TYPES_ALLReceivablesReceivables transaction types: class, posting and default accounts.
• AR_PAYMENT_SCHEDULES_ALLReceivablesOpen and closed receivable items: one row per installment of a transaction and per receipt, with amount due remaining.
• AR_CASH_RECEIPTS_ALLReceivablesReceipts: cash and miscellaneous receipts with customer, amount, method and status.
• AR_RECEIVABLE_APPLICATIONS_ALLReceivablesApplications of receipts and credit memos to transactions, with amounts and accounts.
• GL_LEDGERSGeneral Ledger and SLALedgers (R12 replacement for sets of books): chart of accounts, calendar, currency and accounting method.
• GL_CODE_COMBINATIONSGeneral Ledger and SLAAccounting flexfield combinations: every account string used in the ledgers.
• GL_JE_BATCHESGeneral Ledger and SLAJournal batches.
• GL_JE_HEADERSGeneral Ledger and SLAJournal entry headers: ledger, source, category, period, currency and status.
• GL_JE_LINESGeneral Ledger and SLAJournal entry lines: account, entered and accounted debits and credits, and the subledger link.
• GL_IMPORT_REFERENCESGeneral Ledger and SLAJournal Import references: the link from a GL journal line back to the subledger lines it came from.
• GL_BALANCESGeneral Ledger and SLAAccount balances by ledger, account, currency and period: period activity and beginning balance.
• GL_PERIOD_STATUSESGeneral Ledger and SLAPeriod status per application and ledger: open, closed, future or never opened, for GL and each subledger.
• GL_DAILY_RATESGeneral Ledger and SLADaily currency conversion rates by from currency, to currency, date and rate type.
• XLA_TRANSACTION_ENTITIESGeneral Ledger and SLASubledger Accounting transaction entities: one row per subledger document (invoice, receipt, material transaction) that has accounting events.
• XLA_EVENTSGeneral Ledger and SLAAccounting events raised by subledgers, with status and processing status.
• XLA_AE_HEADERSGeneral Ledger and SLASubledger journal entry headers created by Create Accounting, with GL transfer status.
• XLA_AE_LINESGeneral Ledger and SLASubledger journal entry lines: account, accounting class, amounts, party and the GL link id.
• XLA_DISTRIBUTION_LINKSGeneral Ledger and SLALinks each subledger journal line to the source distribution (AP invoice distribution, AR distribution, material accounting row).
• MTL_SYSTEM_ITEMS_INTERFACEOpen interfacesItem open interface: rows loaded here are imported by the Import Items program.
• MTL_TRANSACTIONS_INTERFACEOpen interfacesMaterial transaction open interface, processed by the Inventory transaction manager.
• OE_HEADERS_IFACE_ALLOpen interfacesSales order header open interface, processed by Order Import.
• OE_LINES_IFACE_ALLOpen interfacesSales order line open interface, processed by Order Import.
• PO_HEADERS_INTERFACEOpen interfacesPurchasing documents open interface (headers), processed by Import Standard Purchase Orders and Import Price Catalogs.
• PO_REQUISITIONS_INTERFACE_ALLOpen interfacesRequisition open interface, processed by Requisition Import (used by MRP, Inventory min-max and external systems).
• RCV_TRANSACTIONS_INTERFACEOpen interfacesReceiving open interface: receipts, deliveries and ASNs processed by the Receiving Transaction Processor.
• AP_INVOICES_INTERFACEOpen interfacesPayables open interface invoice headers, processed by Payables Open Interface Import.
• AP_INVOICE_LINES_INTERFACEOpen interfacesPayables open interface invoice lines.
• RA_INTERFACE_LINES_ALLOpen interfacesAutoInvoice interface lines, filled by Order Management (Invoicing activity) and external billing systems.
• GL_INTERFACEOpen interfacesJournal Import interface: journal lines from subledgers and external systems waiting to be imported into GL.
• WIP_JOB_SCHEDULE_INTERFACEOpen interfacesRequests to create or update discrete jobs, processed by the WIP Mass Load program.
• HR_ALL_ORGANIZATION_UNITSSetup, AOL and HRAll organizations: business groups, operating units, inventory organizations, legal entities and HR organizations.
• PER_ALL_PEOPLE_FSetup, AOL and HRPeople (employees, contingent workers, applicants), date tracked.
• FND_USERSetup, AOL and HRApplication users: user name, dates, linked employee, customer or supplier contact.
• FND_CONCURRENT_REQUESTSSetup, AOL and HRConcurrent requests: program, user, phase, status, timings, parameters and log and output files.
• FND_CONCURRENT_PROGRAMSSetup, AOL and HRConcurrent program definitions.
• FND_LOOKUP_VALUESSetup, AOL and HRLookup codes and meanings (QuickCodes) for every lookup type, by language.
• FND_FLEX_VALUESSetup, AOL and HRValues of value sets, such as the account segment values of the chart of accounts.
• FND_ID_FLEX_SEGMENTSSetup, AOL and HRKey flexfield segment definitions: which SEGMENTn column holds which segment and its value set.

Up and Down browse from the search box, Enter adds the table to the query, Esc clears.