DBA Data[Home] [Help]

APPS.INV_LABEL_PVT2 dependencies on WSH_NEW_DELIVERIES

Line 383: wsh_new_deliveries wnd, mtl_serial_numbers_temp msnt

379: , NVL(msnt.to_serial_number, msnt.fm_serial_number) to_serial_number --Added to fix Bug# 4290536
380: , wdd.subinventory
381: , wdd.requested_quantity_uom
382: FROM wsh_delivery_details wdd, wsh_delivery_assignments wda,
383: wsh_new_deliveries wnd, mtl_serial_numbers_temp msnt
384: WHERE wda.delivery_id = wnd.delivery_id
385: AND NVL(wdd.transaction_temp_id, -1) = msnt.transaction_temp_id(+)
386: AND wdd.delivery_detail_id = wda.delivery_detail_id
387: AND wdd.inventory_item_id IS NOT NULL