APPS.WMS_UNLOAD_UTILS_PVT dependencies on MTL_TRANSACTION_LOTS_TEMP

Line 98: FROM mtl_transaction_lots_temp

94: AND wdt.transaction_temp_id <> p_temp_id);
95:
96: CURSOR msnt_to_del(p_tmp_id NUMBER) IS
97: SELECT serial_transaction_temp_id
98: FROM mtl_transaction_lots_temp
99: WHERE transaction_temp_id = p_tmp_id;
100:
101: CURSOR c_fm_to_serial_number IS
102: SELECT fm_serial_number

Line 115: FROM mtl_transaction_lots_temp

111: WHERE msnt.transaction_temp_id = p_sn_temp_id;
112:
113: CURSOR c_lot_allocations IS
114: SELECT serial_transaction_temp_id
115: FROM mtl_transaction_lots_temp
116: WHERE transaction_temp_id = p_temp_id;
117:
118: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
119:

Line 509: FROM mtl_transaction_lots_temp mtlt

505: CLOSE c_lot_allocations;
506:
507: DELETE mtl_serial_numbers_temp
508: WHERE transaction_temp_id IN(SELECT mtlt.serial_transaction_temp_id
509: FROM mtl_transaction_lots_temp mtlt
510: WHERE mtlt.transaction_temp_id = p_temp_id);
511:
512: IF (l_debug = 1) THEN
513: mydebug(' updating mtlt ');

Line 516: UPDATE mtl_transaction_lots_temp

512: IF (l_debug = 1) THEN
513: mydebug(' updating mtlt ');
514: END IF;
515:
516: UPDATE mtl_transaction_lots_temp
517: SET serial_transaction_temp_id = NULL
518: WHERE transaction_temp_id = p_temp_id;
519: IF (l_debug = 1) THEN
520: mydebug(' update done ');

Line 815: FROM mtl_transaction_lots_temp

811:
812:
813: CURSOR msnt_to_del (p_temp_id IN NUMBER) IS
814: SELECT serial_transaction_temp_id
815: FROM mtl_transaction_lots_temp
816: WHERE transaction_temp_id = p_temp_id;
817:
818:
819: CURSOR c_fm_to_serial_number (p_temp_id IN NUMBER) IS

Line 835: FROM mtl_transaction_lots_temp

831:
832:
833: CURSOR c_lot_allocations (p_temp_id IN NUMBER) IS
834: SELECT serial_transaction_temp_id
835: FROM mtl_transaction_lots_temp
836: WHERE transaction_temp_id = p_temp_id;
837:
838:
839: CURSOR c_next_temp_id

Line 1347: UPDATE mtl_transaction_lots_temp

1343: WHERE transaction_temp_id = l_serial_transaction_temp_id;
1344: END LOOP;
1345: CLOSE c_lot_allocations;
1346:
1347: UPDATE mtl_transaction_lots_temp
1348: SET serial_transaction_temp_id = NULL
1349: WHERE transaction_temp_id = p_txn_temp_id;
1350:
1351: IF (l_debug = 1) THEN

Line 1485: DELETE FROM MTL_TRANSACTION_LOTS_TEMP

1481: x_return_status := fnd_api.g_ret_sts_success;
1482:
1483: IF(p_allocate_lot_flag <> 'Y' AND p_reserved_lot IS NULL) THEN
1484: IF (p_is_bulk_task = 'Y') THEN
1485: DELETE FROM MTL_TRANSACTION_LOTS_TEMP
1486: WHERE transaction_temp_id IN (SELECT transaction_temp_id
1487: FROM mtl_material_transactions_temp
1488: WHERE parent_line_id = p_txn_temp_id);
1489: ELSE

Line 1490: DELETE FROM MTL_TRANSACTION_LOTS_TEMP

1486: WHERE transaction_temp_id IN (SELECT transaction_temp_id
1487: FROM mtl_material_transactions_temp
1488: WHERE parent_line_id = p_txn_temp_id);
1489: ELSE
1490: DELETE FROM MTL_TRANSACTION_LOTS_TEMP
1491: WHERE transaction_temp_id = p_txn_temp_id;
1492: END IF;
1493: IF (l_debug = 1) THEN
1494: mydebug('Deleted '||SQL%ROWCOUNT||' rows from MTLT');