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,
1