DBA Data[Home] [Help]

APPS.INV_PICK_RELEASE_PVT dependencies on MTL_SERIAL_NUMBERS_TEMP

Line 570: From mtl_serial_numbers_temp msnt

566: FROM mtl_serial_numbers msn
567: WHERE reservation_id = rsv_id
568: AND current_status = 3
569: AND NOT EXISTS (Select serial_number
570: From mtl_serial_numbers_temp msnt
571: Where msnt.fm_serial_number = msn.serial_number);
572: -- Possible Performance improvement
573: -- Select serials for this item into a table and use that table
574: