How to Get Order Fulfillment ID, Order Number, and Status in Oracle Fusion Order Management

SELECT

dha.order_number,

dla.line_number,

dfl.fulfill_line_id,

dfl.status_code

FROM

doo_headers_all dha

JOIN doo_lines_all dla

ON dha.header_id = dla.header_id

JOIN doo_fulfill_lines_all dfl

ON dfl.line_id = dla.line_id

WHERE

dha.order_number = 'YOUR_ORDER_NUMBER' -- Replace with order number from UI

AND dla.line_number = 1 -- Replace with line number from UI

ORDER BY

dha.order_number,

dla.line_number;