353: , wdd1.revision revision
354: , wdd1.serial_number serial_number
355: , wdd1.subinventory
356: , wdd1.requested_quantity_uom
357: FROM wsh_delivery_details wdd1, wsh_delivery_assignments_v wda, wsh_delivery_details wdd2
358: WHERE wdd1.delivery_detail_id(+) = wda.delivery_detail_id
359: AND wda.parent_delivery_detail_id(+) = wdd2.delivery_detail_id
360: AND wdd2.delivery_detail_id = p_transaction_id; --168158
361: