In FOM. What is the fields names on the DOO_ tables to link a service line with its parent line.

I'm trying to match the Service Line with its parent Line. I've created a SQL query in FOM. In my output, the service line is not matching up with its parent line. What is the fields names on the DOO_ tables to link a service line with its parent line.

I'm trying to get the output to resemble the Order as such.

Here is my SQL dataset:

SELECT distinct
dha.order_number,
dha.source_order_number,
dla.display_line_number,
dla.line_number,
dla.source_line_number,
dfla.fulfill_line_id,
dfla.fulfill_line_number,
esib.item_number
FROM doo_fulfill_line_details fd,