Join Between WSH_DELIVERY_DETAILS and DOO_FULFILL_LINES_ALL for Split Lines and Partial Shipments — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!