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

Query to get a 1:1 relationship between a Fulfillment line and a Supply line in B2B Order for splits

Summary:

Hey guys. I need a query to get a 1:1 relationship between a Fulfillment Line and a Supply Line in a B2B order for Fulfillment Split cases. Currently, there is a case where the "SUPPLY_ORDER_REFERENCE_LINE_ID" column in the DOS_SUPPLY_LINES table has the Fulfill Line ID of the Child Split line corresponding to the Quantity of the Parent Fulfill Line. So I'm a bit confused. I included the query being used currently. Thanks in advance.

SELECT
  DSBOD.*
FROM
  DOO_HEADERS_ALL DHA,
  DOO_LINES_ALL DLA,
  DOO_FULFILL_LINES_ALL DFLA,
  DOS_SUPPLY_HEADERS DSH,

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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