Search Results return_id




Overview
Explore in AI Chat

Overview

The PO_RTRN_HDR table is a core data object within the Oracle E-Business Suite Process Manufacturing Logistics (GML) module. It functions as the primary header table for recording and managing return transactions. This table serves as the master record for a return, establishing the foundational context—such as the returning organization, vendor, and shipping details—under which individual returned items, stored in the related PO_RTRN_DTL table, are processed. Its role is critical for tracking the lifecycle of material returns within the manufacturing and logistics supply chain.

Key Information Stored

The table's primary key is the RETURN_ID column, which uniquely identifies each return transaction. Other significant columns, as indicated by its foreign key relationships, store essential reference data. These include RETURN_VENDOR_ID to link to the vendor master (PO_VEND_MST), ORGN_CODE to identify the returning organization (SY_ORGN_MST), and SHIPPER_CODE for carrier information (OP_SHIP_MST). The RTRNADDR_ID links to an address master (SY_ADDR_MST), likely for the return-to location, while TEXT_CODE provides a link to descriptive text blocks (PO_TEXT_HDR). Collectively, these columns define the who, where, and how of a return transaction.

Common Use Cases and Queries

This table is central to reporting and operational inquiries related to returns. Common use cases include generating return authorization lists, analyzing return patterns by vendor or organization, and auditing return transaction history. A typical reporting query would join PO_RTRN_HDR to its detail lines and related master tables to provide a comprehensive view. For example, to find all returns for a specific vendor, one might use a SQL pattern such as:

  • SELECT h.RETURN_ID, h.ORGN_CODE, v.VENDOR_NAME, COUNT(d.LINE_NUM)
  • FROM GML.PO_RTRN_HDR h
  • JOIN GML.PO_VEND_MST v ON h.RETURN_VENDOR_ID = v.VENDOR_ID
  • JOIN GML.PO_RTRN_DTL d ON h.RETURN_ID = d.RETURN_ID
  • WHERE v.VENDOR_NAME = '&VENDOR_NAME'
  • GROUP BY h.RETURN_ID, h.ORGN_CODE, v.VENDOR_NAME;

Related Objects

PO_RTRN_HDR maintains documented relationships with several key master and transaction tables, primarily through foreign key constraints. The most critical relationship is with the PO_RTRN_DTL table, where the header RETURN_ID is referenced by the detail line's RETURN_ID column. For reference data, it joins to: PO_VEND_MST on RETURN_VENDOR_ID; SY_ORGN_MST and SY_ORGN_MST_B on ORGN_CODE; OP_SHIP_MST on SHIPPER_CODE; SY_ADDR_MST on RTRNADDR_ID; and PO_TEXT_HDR on TEXT_CODE. These relationships are essential for constructing valid joins in reports and ensuring data integrity across the return management process.