Oracle R12 – Purchasing Module – Base Tables

Oracle R12 – Purchasing Module – Base Tables

Would like to share few Base table names & purpose of tables used in Oracle Purchasing Module:

Table Name	Purpose
po_req_distribution_all	Stores the information about the accounting distributions associated with each requisition line.
po_requisitions_headers_all	Stores the information about requisition headers.
po_requisition_lines_all	Stores the information about requisition lines.
po_distributions_all	Contains the accounting distribution information for every purchase order shipment line.
po_headers_all	Contains header information for your purchasing documents
po_lines_all	Stores current information about each purchase order line.
po_action_history	Stores all the Approvals notification Status
po_vendors	Stores information about the suppliers
po_vendor_sites_all	Stores information about the supplier sites.
po_vendor_contacts	Stores Supplier Contacts, supplier site and contact information
rcv_shipment_headers	Stores common information about the source of your receipts or expected receipts
rcv_shipment_lines	Stores information about items that have been shipped and/or received from a specific receipt source and also about the default destination for intransit shipments.
rcv_transactions	Stores historical information about receiving transactions that is performed
mtl_material_transactions	Stores a record of every material transaction or cost update performed in the Inventory.
po_releases_all	Contains the information about blanket and planned purchase order releases.
po_approval_list_headers	List of approvers for the purchasing document. Used for requisition approvals only
po_approval_list_lines	Contains the approval list lines for the requisition approval list.
po_document_types_all_b	Default, control, and option information you provide to customize Oracle Purchasing document management