APPS.WMS_TASK_UTILS_PVT dependencies on MTL_TRANSACTION_LOTS_TEMP

Line 125: FROM mtl_transaction_lots_temp

121: AND wdt.transaction_temp_id <> p_temp_id);
122:
123: CURSOR msnt_to_del(p_tmp_id NUMBER) IS
124: SELECT serial_transaction_temp_id
125: FROM mtl_transaction_lots_temp
126: WHERE transaction_temp_id = p_tmp_id;
127:
128: CURSOR c_fm_to_serial_number IS
129: SELECT fm_serial_number

Line 137: FROM mtl_serial_numbers_temp msnt, mtl_transaction_lots_temp mtlt

133:
134: CURSOR c_fm_to_lot_serial_number IS
135: SELECT fm_serial_number
136: , to_serial_number
137: FROM mtl_serial_numbers_temp msnt, mtl_transaction_lots_temp mtlt
138: WHERE mtlt.transaction_temp_id = p_temp_id
139: AND msnt.transaction_temp_id = mtlt.serial_transaction_temp_id;
140:
141: CURSOR c_lot_allocations IS

Line 143: FROM mtl_transaction_lots_temp

139: AND msnt.transaction_temp_id = mtlt.serial_transaction_temp_id;
140:
141: CURSOR c_lot_allocations IS
142: SELECT serial_transaction_temp_id
143: FROM mtl_transaction_lots_temp
144: WHERE transaction_temp_id = p_temp_id;
145:
146: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
147: BEGIN

Line 441: FROM mtl_transaction_lots_temp mtlt

437: CLOSE c_lot_allocations;
438:
439: DELETE mtl_serial_numbers_temp
440: WHERE transaction_temp_id IN(SELECT mtlt.serial_transaction_temp_id
441: FROM mtl_transaction_lots_temp mtlt
442: WHERE mtlt.transaction_temp_id = p_temp_id);
443:
444: IF (l_debug = 1) THEN
445: mydebug(' updating mtlt ');

Line 448: UPDATE mtl_transaction_lots_temp

444: IF (l_debug = 1) THEN
445: mydebug(' updating mtlt ');
446: END IF;
447:
448: UPDATE mtl_transaction_lots_temp
449: SET serial_transaction_temp_id = NULL
450: WHERE transaction_temp_id = p_temp_id;
451:
452: IF (l_debug = 1) THEN

Line 1473: FROM mtl_transaction_lots_temp

1469: --BUG 2698630 fix
1470:
1471: CURSOR mtlt(txn_tmp_id NUMBER) IS
1472: SELECT *
1473: FROM mtl_transaction_lots_temp
1474: WHERE transaction_temp_id = txn_tmp_id;
1475:
1476: CURSOR msnt(txn_tmp_id NUMBER) IS
1477: SELECT *