Search Results po_ordr_dtl




Overview
Explore in AI Chat

Overview

The PO_ORDR_DTL table is a core data object within the Oracle E-Business Suite (EBS) Process Manufacturing Logistics (GML) module. It serves as the primary repository for purchase order line-level information. Each record in this table represents a distinct item or material being procured on a specific purchase order, linking the high-level purchase order header to detailed transactional data. Its extensive network of foreign key relationships underscores its central role in integrating procurement with inventory, quality, and financial operations, particularly in a process manufacturing environment where material specifications and handling are critical.

Key Information Stored

The table stores detailed transactional data for each purchase order line. Key columns, as indicated by its primary and foreign keys, include LINE_ID (a unique system identifier) and the composite key of PO_ID and LINE_NO (which defines the line's position on the order). Essential descriptive and control columns reference other master data tables: ITEM_ID (the purchased item), FROM_WHSE and TO_WHSE (warehouse logistics), ORDER_UM1/PRICE_UM (unit of measure), and TERMS_CODE. Operational columns such as SHIP_MTHD, FOB_CODE, and FRTBILL_MTHD govern shipping and freight. The table also tracks quality requirements (QC_GRADE_WANTED), holds (POHOLD_CODE), and cancellations (CANCELLATION_CODE), providing a complete audit trail for the line's lifecycle.

Common Use Cases and Queries

This table is fundamental for operational reporting and process integration. Common use cases include generating detailed purchase order line reports, tracking item-specific receipt and return transactions, and validating line statuses during goods receipt. A typical query might join PO_ORDR_DTL to the header (PO_ORDR_HDR) and item master (IC_ITEM_MST_B) to report on open lines:

  • SELECT hdr.PO_NUMBER, dtl.LINE_NO, mst.ITEM_NO, dtl.ORDER_QTY1, dtl.UNIT_PRICE FROM GML.PO_ORDR_DTL dtl JOIN GML.PO_ORDR_HDR hdr ON dtl.PO_ID = hdr.PO_ID JOIN INV.IC_ITEM_MST_B mst ON dtl.ITEM_ID = mst.ITEM_ID WHERE hdr.STATUS = 'OPEN';

It is also critical for downstream processes, as its LINE_ID is the foreign key for receipt (PO_RECV_DTL), return (PO_RTRN_DTL), and schedule (PO_RELS_SCH) detail tables.

Related Objects

PO_ORDR_DTL is a hub within the GML procurement schema. Its primary relationship is with the PO_ORDR_HDR table via the PO_ID column. It references numerous master data tables, including IC_ITEM_MST_B for items, IC_WHSE_MST for warehouses, SY_UOMS_MST for units of measure, and QC_GRAD_MST for quality grades. Crucially, it is the parent table for key transactional child tables: PO_RECV_DTL (receipts), PO_RTRN_DTL (returns), and PO_RELS_SCH (release schedules). It also links to blanket purchase agreements via PO_BPOS_DTL. This structure ensures data integrity from the purchase order line through to final receipt and inventory posting.