1554: , wdd1.subinventory
1555: , wdd1.locator_id
1556: FROM wsh_delivery_details wdd1
1557: , wsh_delivery_details wdd2
1558: , wsh_delivery_assignments_v wda
1559: , wms_license_plate_numbers wlpn
1560: WHERE wdd1.delivery_detail_id = wda.delivery_detail_id
1561: AND wdd2.delivery_detail_id = wda.parent_delivery_detail_id
1562: AND wlpn.lpn_id(+) = wdd2.lpn_id
1578: , wdd1.revision revision
1579: , wdd1.subinventory
1580: , wdd1.locator_id
1581: FROM wsh_delivery_details wdd1
1582: , wsh_delivery_assignments_v wda
1583: , wsh_new_deliveries wnd
1584: , wms_license_plate_numbers wlpn
1585: , wsh_delivery_details wdd2
1586: WHERE wda.delivery_id = wnd.delivery_id