← All tables
Oracle Fusion/Procurement/Receiving
RCV_TRANSACTIONS
Receiving transactions — RECEIVE, DELIVER, RETURN TO VENDOR, CORRECT and inspection rows against a PO shipment.
Key Columns
TRANSACTION_IDTRANSACTION_TYPESHIPMENT_HEADER_IDSHIPMENT_LINE_IDPO_HEADER_IDPO_LINE_IDPO_LINE_LOCATION_IDQUANTITYDESTINATION_TYPE_CODE
Common Joins
Used In
ReceivingInventoryAP
Notes
PARENT_TRANSACTION_ID chains RECEIVE → DELIVER → CORRECT so you can trace a unit through inspection to stock.
Related
PO line → schedule → distribution → receipt
A PO line (PO_LINES_ALL) has one or more schedules (PO_LINE_LOCATIONS_ALL) that carry the ship-to and need-by date; each schedule has accounting distributions (PO_DISTRIBUTIONS_ALL). Receipts (RCV_TRANSACTIONS) and AP invoice matching both reference the schedule's LINE_LOCATION_ID for three-way match.