Oracle Apps important tables

Oracle Apps important tables, www.askhareesh.com
ONT- Order Management

Table Name Description 
OE_ORDER_HEADERS_ALL stores header information for orders in Order Management. 
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

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 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


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 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

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 from subledgers 
GL_DAILY_RATES Stores the daily conversion rates for foreign currency




*/