PO — Purchasing
258 documented tables · 543 views — Oracle EBS ETRM 12.2.2
Most-referenced tables
| Table | Description | Data Vault class* |
|---|---|---|
PO_VENDORS |
Suppliers | hub-leaning |
PO_VENDOR_SITES_ALL |
Supplier sites | hub-leaning |
PO_HEADERS_ALL |
Document headers (for purchase orders, purchase agreements, quotations, RFQs) | hub |
PO_AGENTS |
Buyers table | hub-leaning |
PO_HAZARD_CLASSES_B |
Hazardous classes | hub-leaning |
RCV_TRANSACTIONS |
Receiving transactions | hub-leaning |
PO_LINES_ALL |
Purchase document lines (for purchase orders, purchase agreements, quotations, RFQs) | hub |
RCV_ROUTING_HEADERS |
Receiving routing headers | hub-leaning |
PO_LINE_LOCATIONS_ALL |
Document shipment schedules (for purchase orders, purchase agreements, quotations, RFQs) | hub-leaning |
RCV_SHIPMENT_LINES |
Receiving shipment line information | hub |
PO_UN_NUMBERS_B |
United Nations numbers | hub-leaning |
PO_DISTRIBUTIONS_ALL |
Purchase order distributions | hub-leaning |
PO_RELEASES_ALL |
Purchase order releases | hub |
PO_REQUISITION_HEADERS_ALL |
Requisition headers | hub |
RCV_SHIPMENT_HEADERS |
Shipment and receipt header information | hub-leaning |
*Heuristic classification mined from FK structure — a modeling suggestion, not Oracle's.
Key public APIs
| Package | Class | Procedures | Used by |
|---|---|---|---|
PO_CLM_INTG_GRP |
GRP | 5 | 52 packages |
PO_CODE_RELEASE_GRP |
GRP | 2 | 24 packages |
PO_CONTERMS_UTL_GRP |
GRP | 17 | 20 packages |
PO_DOCUMENT_CHECKS_GRP |
GRP | 13 | 17 packages |
PO_AP_INVOICE_MATCH_GRP |
GRP | 7 | 16 packages |
PO_DOC_STYLE_GRP |
GRP | 6 | 13 packages |
PO_DOCUMENT_CONTROL_GRP |
GRP | 5 | 11 packages |
PO_UDA_PUB |
PUB | 4 | 9 packages |
PO_THIRD_PARTY_STOCK_GRP |
GRP | 10 | 9 packages |
PO_DOCUMENT_ARCHIVE_GRP |
GRP | 3 | 9 packages |