Search Results po_recv_dtl




Overview
Explore in AI Chat

Overview

The PO_RECV_DTL table is a core transactional data object within the Oracle E-Business Suite (EBS) Process Manufacturing Logistics (GML) module. It serves as the detailed repository for all receipt line information generated during the goods receipt process against purchase orders. Each record in this table represents a specific item line received, capturing the quantity, unit of measure, and associated transactional details. Its primary role is to record the fulfillment of purchase order lines, providing a granular audit trail for inventory transactions, cost accounting, and vendor performance analysis. The table's integrity is maintained through its relationships with purchase order headers (PO_ORDR_HDR) and lines (PO_ORDR_DTL), as well as the receipt header (PO_RECV_HDR).

Key Information Stored

The table stores detailed attributes for each received line. Its structure is defined by two primary keys: a composite key (RECV_ID, LINE_NO) for business logic and a unique surrogate key (LINE_ID). Critical columns include RECV_ID, linking the line to its parent receipt header, and POLINE_ID, which references the source purchase order line in PO_ORDR_DTL. Key transactional data columns are ITEM_ID for the received item, RECV_UM1 and RECV_UM2 for units of measure, and TO_WHSE/FROM_WHSE for warehouse movement. Additional columns like SHIPPER_CODE, FOB_CODE, and SHIP_MTHD capture shipping and freight details, while TEXT_CODE allows for associated notes. The table also holds references to the vendor (SHIPVEND_ID) and receiving address (RECVADDR_ID).

Common Use Cases and Queries

This table is central to reporting and reconciliation in procurement and inventory. Common use cases include generating detailed receipt reports, reconciling received quantities against ordered quantities, and analyzing receipt timeliness. A typical query joins PO_RECV_DTL to PO_RECV_HDR for receipt dates and PO_ORDR_DTL for original order information. For example, to find all receipts for a specific item in a date range, one would query: SELECT prd.recv_id, prd.line_no, prd.item_id, prh.recv_date, prd.recv_qty1 FROM po_recv_dtl prd JOIN po_recv_hdr prh ON prd.recv_id = prh.recv_id WHERE prd.item_id = :p_item_id AND prh.recv_date BETWEEN :p_date_from AND :p_date_to;. The table is also critical for drill-downs from summary receipt inquiries and for supporting custom integrations that consume receipt data.

Related Objects

PO_RECV_DTL maintains extensive foreign key relationships, integrating it deeply within the EBS schema. Its primary dependencies are: