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;