Oracle Database Tables List SCM
| 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 |
| AP- Accounts Payables |
| 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 |
| 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 |
