Trace a Sales Order
SQLOracle Fusion · Supply Chain · Order ManagementHigh confidenceGenerated
Traces a sales order from header through line to fulfillment status.
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 numberRelevant tables
DOO_HEADERS_ALL
CuratedSales order header
Key columns
HEADER_IDORDER_NUMBERBUSINESS_UNIT_IDSOURCE_ORDER_SYSTEM
DOO_LINES_ALL
CuratedSales order line
Key columns
LINE_IDHEADER_IDINVENTORY_ITEM_IDORDERED_QUANTITY
DOO_FULFILL_LINES_ALL
CuratedFulfillment/orchestration status
Key columns
FULFILL_LINE_IDLINE_IDHEADER_IDFULFILLMENT_LINE_STATUS_CODE
Relationship
Key columns
| Table | Key columns |
|---|---|
| DOO_HEADERS_ALL | HEADER_IDORDER_NUMBERBUSINESS_UNIT_IDSOURCE_ORDER_SYSTEM |
| DOO_LINES_ALL | LINE_IDHEADER_IDINVENTORY_ITEM_IDORDERED_QUANTITY |
| DOO_FULFILL_LINES_ALL | FULFILL_LINE_IDLINE_IDHEADER_IDFULFILLMENT_LINE_STATUS_CODE |
Related questions
GroundingGenerated
Model-generated, grounded against the curated knowledge layer. Check specifics against your instance.