Oracle Drop Ship tables

Oracle Drop Ship tables

Table	Description
PO_LINE_LOCATIONS_ALL	Stores document shipment schedules for purchase orders, purchase agreements, quotations, and RFQs
PO_LINES_ALL	Stores purchase document lines for purchase orders, purchase agreements, quotations, and RFQs
PO_HEADERS_ALL	Stores document headers for purchase orders, purchase agreements, quotations, and RFQs
PO_DISTRIBUTIONS_ALL	Stores purchase order distributions
PO_REQUISITION_HEADERS_ALL	Stores requisition headers
PO_REQUISITION_LINES_ALL	Stores requisition lines
PO_REQ_DISTRIBUTIONS_ALL	This table stores requisition distributions
PO_REQUISITIONS_INTERFACE_ALL	This is the Requisition Import interface table
OE_ORDER_LINES_ALL	Stores information for all order lines in Oracle Order Management
RCV_SHIPMENT_LINES	Stores receiving shipment line information
OE_DROP_SHIP_SOURCES	Stores relationships between order lines in oe_order_lines_all table and associated oracle purchasing requisitions in PO_REQUISITIONS_ALL and Oracle purchasing purchase orders in PO_LINES_ALL

Check the blog posts:

OM Drop Ship process

OM Drop ship cycle in brief

OM Drop Ship Setups and Prerequisites

Drop Shipment Overview

Oracle Drop Ship tables