APPS.WMS_TASK_DISPATCH_PUT_AWAY dependencies on MTL_TRANSACTION_LOTS_INTERFACE

Line 3124: * Helper routine to create MTL_TRANSACTION_LOTS_INTERFACE records

3120: RETURN FALSE;
3121: END insert_dup_msnt;
3122:
3123: /* FP-J Lot/Serial Support Enhancement
3124: * Helper routine to create MTL_TRANSACTION_LOTS_INTERFACE records
3125: * for the lot and quantity corresponding to the drop quantity
3126: * Called for a receiving LPN when INV and PO patch levels are J or higher
3127: */
3128: FUNCTION insert_mtli_helper(

Line 4878: FROM mtl_transaction_lots_interface

4874: IF (l_is_crossdocked) THEN
4875: IF (l_lot_code > 1) THEN
4876: SELECT serial_transaction_temp_id
4877: INTO l_msnt_temp_id
4878: FROM mtl_transaction_lots_interface
4879: WHERE lot_number = p_lot
4880: AND product_transaction_id = l_product_transaction_id;
4881: ELSE
4882: l_msnt_temp_id := p_temp_id;

Line 5454: DELETE FROM mtl_transaction_lots_interface

5450: mydebug('complete_putaway: Deleted msni with l_product_transaction_id '||l_product_transaction_id);
5451: END IF;
5452:
5453: IF l_lot_code = 2 THEN
5454: DELETE FROM mtl_transaction_lots_interface
5455: WHERE product_transaction_id = l_product_transaction_id;
5456:
5457: IF (l_debug = 1) THEN
5458: mydebug('complete_putaway: Deleted mtli with l_product_transaction_id '||l_product_transaction_id);