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:
- DROP_SHIP_SOURCE_ID — System-generated surrogate primary key, uniquely identifying each drop-ship sourcing record.
- HEADER_ID — Foreign key to the sales order header in SO_HEADERS_ALL.
- LINE_ID — Foreign key to the sales order line in SO_LINES_ALL; indexed by SO_DROP_SHIP_SOURCES_N2 as the primary business-key candidate.
- REQUISITION_HEADER_ID / REQUISITION_LINE_ID — Foreign keys to PO_REQUISITIONS_HEADERS_ALL and PO_REQUISITION_LINES_ALL, tying the line to the originating requisition.
- PO_HEADER_ID / PO_LINE_ID — Foreign keys to PO_HEADERS_ALL and PO_LINES_ALL, identifying the released purchase order and line.
- LINE_LOCATION_ID — Foreign key to PO_LINE_LOCATIONS_ALL, capturing the shipment or schedule detail.
- PO_RELEASE_ID — Foreign key to PO_RELEASES_ALL, relevant for blanket agreement releases.
- ORG_ID — Operating unit identifier supporting multi-org security.
- DESTINATION_ORGANIZATION_ID — Customer location or ship-to organization reference.
- CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard Who audit columns.
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.
-
VIEW: APPS.AHL_OSP_ORDERS_V 12.1.1
-
VIEW: APPS.AHL_OSP_ORDERS_V 12.2.2
-
eTRM - OE Tables and Views 12.2.2
Temporary table
-
eTRM - OE Tables and Views 12.1.1
Temporary table
-
eTRM - AHL Tables and Views 12.1.1
Ahl Production Workorder Operations Information stored in this table
-
eTRM - AHL Tables and Views 12.2.2
Ahl Production Workorder Operations Information stored in this table
-
eTRM - MSC Tables and Views 12.1.1
This table contains the mapping between user-defined zone and included regions
-
eTRM - MSC Tables and Views 12.2.2
This table contains the mapping between user-defined zone and included regions
-
eTRM - PO Tables and Views 12.1.1
Temporary table for tracking a receiving upgrade from Release 9 to Release 10
-
eTRM - PO Tables and Views 12.2.2
Temporary table for tracking a receiving upgrade from Release 9 to Release 10