APPS.WMS_TASK_DISPATCH_PUT_AWAY dependencies on MTL_SERIAL_NUMBERS_INTERFACE

Line 3216: * Helper routine to create MTL_SERIAL_NUMBERS_INTERFACE records

3212: RETURN FALSE;
3213: END insert_mtli_helper;
3214:
3215: /* FP-J Lot/Serial Support Enhancement
3216: * Helper routine to create MTL_SERIAL_NUMBERS_INTERFACE records
3217: * for the serials corresponding to the dropped quantity
3218: * Called for a receiving LPN when INV and PO patch levels are J or higher
3219: */
3220: FUNCTION insert_msni_helper(

Line 3802: FROM mtl_serial_numbers_interface msni

3798: , n_attribute7
3799: , n_attribute8
3800: , n_attribute9
3801: , n_attribute10
3802: FROM mtl_serial_numbers_interface msni
3803: -- Bug# 3281512 - Performance Fixes
3804: -- Since this cursor is only used for receiving, the product code
3805: -- will always be 'RCV'. This is needed in order to use the index.
3806: WHERE msni.product_code = 'RCV'

Line 5446: DELETE FROM mtl_serial_numbers_interface

5442: END IF; --END IF check sub type to call the corresponding API
5443: --14487832
5444: IF l_serial_code NOT IN (1,6) THEN
5445:
5446: DELETE FROM mtl_serial_numbers_interface
5447: WHERE product_transaction_id = l_product_transaction_id;
5448:
5449: IF (l_debug = 1) THEN
5450: mydebug('complete_putaway: Deleted msni with l_product_transaction_id '||l_product_transaction_id);