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

How to link wsh_delivery_details table with doo_fulfill_lines_all

Received Response
438
Views
10
Comments

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):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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