APPS.INV_TRANSFER_ORDER_PVT dependencies on MTL_TRANSACTION_LOTS_TEMP

Line 288: FROM mtl_transaction_lots_temp

284: CURSOR c_mtlt IS
285: SELECT transaction_quantity,
286: secondary_quantity --INVCONV
287: , lot_number -- nsinghi bug#5724815.
288: FROM mtl_transaction_lots_temp
289: WHERE transaction_temp_id = p_trx_temp_id
290: ORDER BY creation_date
291: FOR UPDATE OF transaction_temp_id;
292:

Line 323: DELETE FROM mtl_transaction_lots_temp

319: IF (l_debug = 1) THEN
320: DEBUG('Deleting the row in mtlt ', 'UPDATE LOTS TEMP');
321: END IF;
322:
323: DELETE FROM mtl_transaction_lots_temp
324: WHERE transaction_temp_id = p_trx_temp_id;
325: ELSIF p_operation = 'UPDATE' THEN -- when cancel qty < sum(mmtt trx qty)
326: SELECT COUNT(*)
327: INTO l_lot_count

Line 328: FROM mtl_transaction_lots_temp

324: WHERE transaction_temp_id = p_trx_temp_id;
325: ELSIF p_operation = 'UPDATE' THEN -- when cancel qty < sum(mmtt trx qty)
326: SELECT COUNT(*)
327: INTO l_lot_count
328: FROM mtl_transaction_lots_temp
329: WHERE transaction_temp_id = p_trx_temp_id;
330:
331: -- nsinghi bug#5724815
332: OPEN c_get_sec_uom;

Line 350: DELETE FROM mtl_transaction_lots_temp

346: DEBUG('Delete current row ', 'UPDATE LOTS TEMP');
347: END IF;
348:
349: -- Delete the current row from mtlt since mtlt cancel qty > mtlt trx qty
350: DELETE FROM mtl_transaction_lots_temp
351: WHERE CURRENT OF c_mtlt;
352: ELSIF l_mtlt_trx_qty > l_mtlt_cancel_qty THEN
353: IF (l_debug = 1) THEN
354: DEBUG('Update current row ', 'UPDATE LOTS TEMP');

Line 392: UPDATE mtl_transaction_lots_temp

388: -- END
389:
390: l_mtlt_primary_qty := inv_convert.inv_um_convert(item_id => p_item_id, PRECISION => NULL, from_quantity => l_mtlt_trx_qty, from_unit => p_trx_uom, to_unit => p_primary_uom, from_name => NULL, to_name => NULL);
391:
392: UPDATE mtl_transaction_lots_temp
393: SET transaction_quantity = l_mtlt_trx_qty
394: , secondary_quantity = l_mtlt_sec_trx_qty -- INVCONV
395: , primary_quantity = l_mtlt_primary_qty
396: , last_update_date = p_last_update_date

Line 2602: FROM mtl_transaction_lots_temp

2598: , secondary_quantity
2599: , secondary_unit_of_measure
2600: , serial_transaction_temp_id
2601: , grade_code
2602: FROM mtl_transaction_lots_temp
2603: WHERE transaction_temp_id = l_trx_temp_id
2604: ORDER BY lot_number;
2605:
2606: CURSOR serial_csr(l_trx_temp_id NUMBER, l_lot_control_code NUMBER, l_ser_trx_temp_id NUMBER,

Line 3780: FROM mtl_transaction_lots_temp

3776: DEBUG('l_mmtt_rec.transaction_temp_id is '|| l_mmtt_rec.transaction_temp_id, 'Finalize_Pick_confirm');
3777: END IF;
3778:
3779: SELECT COUNT(*) INTO l_lot_count
3780: FROM mtl_transaction_lots_temp
3781: WHERE transaction_temp_id = p_transaction_temp_id;
3782:
3783: IF (l_debug = 1) THEN
3784: DEBUG('l_lot_count is '|| l_lot_count, 'Finalize_Pick_Confirm');

Line 4868: mtl_transaction_lots_temp mtlt

4864: SELECT WMS_CATCH_WEIGHT_PVT.G_PRICE_PRIMARY INTO l_catch_weight_enabled FROM DUAL
4865: WHERE EXISTS (
4866: SELECT 1
4867: FROM mtl_material_transactions_temp mmtt,
4868: mtl_transaction_lots_temp mtlt
4869: WHERE mmtt.organization_id = l_mmtt_rec.organization_id
4870: AND mmtt.inventory_item_id = l_mmtt_rec.inventory_item_id
4871: AND NVL(mmtt.revision, '@') = NVL(l_mmtt_rec.revision, '@')
4872: AND mmtt.transaction_source_type_id = INV_GLOBALS.G_SourceType_SalesOrder

Line 5352: mtl_transaction_lots_temp mtlt

5348: SELECT WMS_CATCH_WEIGHT_PVT.G_PRICE_PRIMARY INTO l_catch_weight_enabled FROM DUAL
5349: WHERE EXISTS (
5350: SELECT 1
5351: FROM mtl_material_transactions_temp mmtt,
5352: mtl_transaction_lots_temp mtlt
5353: WHERE mmtt.organization_id = l_mmtt_rec.organization_id
5354: AND mmtt.inventory_item_id = l_mmtt_rec.inventory_item_id
5355: AND NVL(mmtt.revision, '@') = NVL(l_mmtt_rec.revision, '@')
5356: AND mmtt.transaction_source_type_id = INV_GLOBALS.G_SourceType_SalesOrder

Line 5863: FROM mtl_transaction_lots_temp

5859: DEBUG('l_mmtt_rec.transaction_temp_id is '|| l_mmtt_rec.transaction_temp_id, 'Finalize_Pick_confirm');
5860: END IF;
5861:
5862: SELECT COUNT(*) INTO l_lot_count
5863: FROM mtl_transaction_lots_temp
5864: WHERE transaction_temp_id = p_transaction_temp_id;
5865:
5866: IF (l_debug = 1) THEN
5867: DEBUG('l_lot_count is '|| l_lot_count, 'Finalize_Pick_Confirm');