Join Between WSH_DELIVERY_DETAILS and DOO_FULFILL_LINES_ALL for Split Lines and Partial Shipments
I’m working with a scenario involving a transfer order that also acts as a sales order. One of the order lines is split into three fulfillment lines, appearing in DOO_FULFILL_LINES_ALL
as 3-1, 3-2, and 3-3. Correspondingly, I see three delivery detail records in the WSH_DELIVERY_DETAILS
table.
My goal is to create a report that shows end-to-end fulfillment and shipping details for each of these split lines. However, I noticed that all the delivery detail records reference the same SOURCE_SHIPMENT_ID
, which maps to the FULFILL_LINE_ID
of the original (parent) fulfillment line.