APPS.WMS_UNLOAD_UTILS_PVT dependencies on MTL_TRANSACTION_LOTS_TEMP

Line 69: FROM mtl_transaction_lots_temp

65: AND wdt.transaction_temp_id <> p_temp_id);
66:
67: CURSOR msnt_to_del(p_tmp_id NUMBER) IS
68: SELECT serial_transaction_temp_id
69: FROM mtl_transaction_lots_temp
70: WHERE transaction_temp_id = p_tmp_id;
71:
72: CURSOR c_fm_to_serial_number IS
73: SELECT fm_serial_number

Line 86: FROM mtl_transaction_lots_temp

82: WHERE msnt.transaction_temp_id = p_sn_temp_id;
83:
84: CURSOR c_lot_allocations IS
85: SELECT serial_transaction_temp_id
86: FROM mtl_transaction_lots_temp
87: WHERE transaction_temp_id = p_temp_id;
88:
89: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
90:

Line 370: FROM mtl_transaction_lots_temp mtlt

366: CLOSE c_lot_allocations;
367:
368: DELETE mtl_serial_numbers_temp
369: WHERE transaction_temp_id IN(SELECT mtlt.serial_transaction_temp_id
370: FROM mtl_transaction_lots_temp mtlt
371: WHERE mtlt.transaction_temp_id = p_temp_id);
372:
373: IF (l_debug = 1) THEN
374: mydebug(' updating mtlt ');

Line 377: UPDATE mtl_transaction_lots_temp

373: IF (l_debug = 1) THEN
374: mydebug(' updating mtlt ');
375: END IF;
376:
377: UPDATE mtl_transaction_lots_temp
378: SET serial_transaction_temp_id = NULL
379: WHERE transaction_temp_id = p_temp_id;
380:
381: IF (l_debug = 1) THEN

Line 620: FROM mtl_transaction_lots_temp

616:
617:
618: CURSOR msnt_to_del (p_temp_id IN NUMBER) IS
619: SELECT serial_transaction_temp_id
620: FROM mtl_transaction_lots_temp
621: WHERE transaction_temp_id = p_temp_id;
622:
623:
624: CURSOR c_fm_to_serial_number (p_temp_id IN NUMBER) IS

Line 640: FROM mtl_transaction_lots_temp

636:
637:
638: CURSOR c_lot_allocations (p_temp_id IN NUMBER) IS
639: SELECT serial_transaction_temp_id
640: FROM mtl_transaction_lots_temp
641: WHERE transaction_temp_id = p_temp_id;
642:
643:
644: CURSOR c_next_temp_id

Line 1026: UPDATE mtl_transaction_lots_temp

1022: WHERE transaction_temp_id = l_serial_transaction_temp_id;
1023: END LOOP;
1024: CLOSE c_lot_allocations;
1025:
1026: UPDATE mtl_transaction_lots_temp
1027: SET serial_transaction_temp_id = NULL
1028: WHERE transaction_temp_id = p_txn_temp_id;
1029:
1030: IF (l_debug = 1) THEN