Results for “po_requisitions_headers_all”

16 results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

OE.SO_DROP_SHIP_SOURCES is a transactional detail table in the Oracle Order Management (OE) schema that records the linkage between drop-ship sales order lines and the corresponding Oracle Purchasing documents. In a drop-ship fulfillment model, goods are shipped directly from a supplier to the customer without passing through the selling organization's inventory. Because the sales order and the procurement transaction are stored as independent documents, Oracle E-Business Suite relies on this table to persist the cross-reference between the two flows.

The object is present and VALID in both Oracle EBS 12.1.1 and 12.2.2. Under an enterprise data warehouse modeling convention, the metadata classifies this object as a link, a modeling suggestion that reflects its role as an associative bridge joining parties (sales order lines) to counterparties (requisition and purchase order lines) rather than acting as a hub or satellite.

Key Information Stored

The table is stored in the APPS_TS_TX_DATA tablespace with a PCT Free of 10 and comprises 16 documented columns. The most significant are:

Common Use Cases and Queries

Primary use cases center on reconciling sales orders to procurement activity for drop-shipped goods, tracking supplier performance, and reporting on the status of back-to-back fulfillment. Analysts frequently join through LINE_ID to retrieve the order context by column set HEADER_ID, LINE_ID and through REQUISITION_LINE_ID or PO_LINE_ID to obtain sourcing detail.

A representative query locating the purchase order for a given sales order line:

  • SELECT s.LINE_ID, s.PO_HEADER_ID, s.PO_LINE_ID, s.LINE_LOCATION_ID FROM OE.SO_DROP_SHIP_SOURCES s WHERE s.LINE_ID = :p_line_id;

Other practical patterns include auditing records lacking a requisition reference, aggregating drop-ship volume by ORG_ID (operating unit), and joining to PO_LINE_LOCATIONS_ALL to trace receipt and delivery status.

Related Objects

The following objects participate in the defined foreign-key relationships:

  • OE.SO_LINES_ALL — joined on SO_DROP_SHIP_SOURCES.LINE_ID; the demand source.
  • PO_REQUISITION_LINES_ALL — joined on REQUISITION_LINE_ID.
  • PO_REQUISITION_HEADERS_ALL — joined on REQUISITION_HEADER_ID.
  • PO_LINES_ALL — joined on PO_LINE_ID.
  • PO_HEADERS_ALL — joined on PO_HEADER_ID.
  • PO_LINE_LOCATIONS_ALL — joined on LINE_LOCATION_ID; supplies shipment and schedule detail.
  • PO_RELEASES_ALL — joined on PO_RELEASE_ID for blanket releases.
  • OE.SO_HEADERS_ALL — referenced by HEADER_ID for order-level context.