OracleOps AI
← Answer Library

Trace a sales order from header to fulfillment.

Trace a Sales Order

Oracle Fusion · Supply Chain · Order Management

SQL RequestHigh confidence

Traces a sales order from header through line to fulfillment status.

Grounded in: Curated SQL pattern — Order Management

SQL

SQL
SELECT
  dha.order_number,
  dla.inventory_item_id,
  dla.ordered_quantity,
  dfla.fulfillment_line_status_code
FROM doo_headers_all dha
JOIN doo_lines_all dla ON dla.header_id = dha.header_id
JOIN doo_fulfill_lines_all dfla ON dfla.line_id = dla.line_id
WHERE dha.order_number = :order_number;

Bind Variables

:order_numberSales order number

Key Tables

DOO_HEADERS_ALL

Sales order header

DOO_LINES_ALL

Sales order line

DOO_FULFILL_LINES_ALL

Fulfillment/orchestration status

Related Questions

Have a follow-up, or a different question?

Continue in Ask Oracle AI