My Oracle Support Banner

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.