How to link wsh_delivery_details table with doo_fulfill_lines_all
Summary: what is correct join between wsh_delivery_details table and doo_fulfill_lines_all
Content (required):
I have one order line with 3 fulfillment lines.
Select dfl.fulfill_line_number
from wsh_delivery_details wdd
join doo_fulfill_lines_all dfl on (
dfl.fulfill_line_id = wdd.source_shipment_id
)
where ....
is always pointing to dfl.fulfill_line_number = 1
Version (include the version you are using, if applicable):
22B
Code Snippet (add any code snippets that support your topic, if applicable):
Tagged:
0