DBA Data[Home] [Help]

APPS.INV_LABEL_PVT2 dependencies on WSH_DELIVERY_ASSIGNMENTS

Line 357: FROM wsh_delivery_details wdd1, wsh_delivery_assignments_v wda, wsh_delivery_details wdd2

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:

Line 377: FROM wsh_delivery_details wdd, wsh_delivery_assignments wda,

373: , msnt.fm_serial_number fm_serial_number --Added to fix Bug# 4290536
374: , NVL(msnt.to_serial_number, msnt.fm_serial_number) to_serial_number --Added to fix Bug# 4290536
375: , wdd.subinventory
376: , wdd.requested_quantity_uom
377: FROM wsh_delivery_details wdd, wsh_delivery_assignments wda,
378: wsh_new_deliveries wnd, mtl_serial_numbers_temp msnt
379: WHERE wda.delivery_id = wnd.delivery_id
380: AND NVL(wdd.transaction_temp_id, -1) = msnt.transaction_temp_id(+)
381: AND wdd.delivery_detail_id = wda.delivery_detail_id