How Can One Link tables WSH_DELIVERY_DETAILS And RCV_SHIPMENT_LINES For Internal Sales Orders With Split Delivery Detail Rows?
(Doc ID 2722043.1)
Last updated on OCTOBER 21, 2020
Applies to:Oracle Shipping Execution - Version 12.0.0 and later
Information in this document applies to any platform.
How to query for the below condition
For Internal Sales Orders (ISOs), want to link records in RCV_SHIPMENT_LINES to records in WSH_DELIVERY_DETAILS
when a delivery detail is split from another delivery detail, and each delivery detail has a different lot number.
There is one row in OE_ORDER_LINES_ALL.
There are two rows in WSH_DELIVERY_DETAILS where one line has a value in SPLIT_FROM_DELIVERY_DETAIL_ID
that links to the other line. Each delivery detail line has a different lot number.
There are two rows in RCV_SHIPMENT_LINES.
Since there are different lot numbers in each WSH_DELIVERY_DETAILS row,
we want to match the appropriate lot number to each RCV_SHIPMENT_LINE.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document