APPS.WMS_PACKING_WORKBENCH_PVT dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 776: ' AND (NOT exists (select 1 from wms_dispatched_tasks wdt, mtl_material_transactions_temp mmtt where wdt.transaction_temp_id = mmtt.transaction_temp_id and mmtt.lpn_id = mol.lpn_id)))) ';

772: 'AND nvl(mol.wms_process_flag,1) <> 2 AND mol.organization_id = :org_id AND mol.inventory_item_id = nvl(:inventory_item_id, mol.inventory_item_id) '||
773: 'AND nvl(mol.project_id, -9999) = nvl(:project_id, nvl(mol.project_id, -9999)) AND nvl(mol.task_id, -9999) = nvl(:task_id, nvl(mol.task_id, -9999)) '||
774: 'AND ((mol.lpn_id IS NULL) OR '||
775: ' (mol.lpn_id IS NOT NULL AND (NOT exists (select 1 from wms_dispatched_tasks wdt where wdt.transfer_lpn_id = mol.lpn_id)) '||
776: ' AND (NOT exists (select 1 from wms_dispatched_tasks wdt, mtl_material_transactions_temp mmtt where wdt.transaction_temp_id = mmtt.transaction_temp_id and mmtt.lpn_id = mol.lpn_id)))) ';
777:
778: l_sub_where_str VARCHAR2(100) :=
779: ' AND (nvl(lpn.subinventory_code,mol.from_subinventory_code)=:subinventory) ';
780:

Line 3368: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt

3364: INTO l_mmtt_exists, l_cur_rec.move_order_line_id, l_cur_rec.inventory_item_id
3365: , l_cur_rec.revision, l_cur_rec.transaction_quantity, l_cur_rec.transaction_uom
3366: , l_cur_rec.lot_number, l_cur_rec.serial_transaction_temp_id
3367: , l_cur_rec.secondary_transaction_quantity, l_cur_rec.secondary_uom_code --INVCONV kkillams
3368: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt
3369: WHERE mtlt.transaction_temp_id(+) = mmtt.transaction_temp_id
3370: AND mmtt.transaction_header_id = p_transaction_header_id
3371: AND mmtt.transaction_temp_id = p_transaction_temp_id
3372: AND mmtt.inventory_item_id <> -1

Line 4080: UPDATE mtl_material_transactions_temp

4076: x_transaction_temp_id := l_txn_tmp_id;
4077: ELSE
4078: -- Update existing MMTT
4079: BEGIN
4080: UPDATE mtl_material_transactions_temp
4081: SET transaction_quantity = transaction_quantity + l_mol_list(i).transaction_quantity,
4082: primary_quantity = primary_quantity + l_mol_list(i).primary_quantity,
4083: secondary_transaction_quantity = CASE WHEN l_mol_list(i).secondary_transaction_quantity IS NOT NULL
4084: THEN l_mol_list(i).secondary_transaction_quantity + secondary_transaction_quantity

Line 4344: FROM mtl_material_transactions_temp mmtt

4340: p_revision IS NULL and (p_lot_number IS NOT NULL or p_fm_serial_number IS NOT NULL) THEN
4341: BEGIN
4342: SELECT 1
4343: INTO l_mmtt_exists
4344: FROM mtl_material_transactions_temp mmtt
4345: WHERE mmtt.transaction_header_id = p_transaction_header_id
4346: AND mmtt.transaction_temp_id = p_transaction_temp_id
4347: AND mmtt.content_lpn_id IS NULL
4348: AND mmtt.inventory_item_id = p_inventory_item_id

Line 4563: UPDATE mtl_material_transactions_temp

4559: l_ser_txn_id := l_txn_tmp_id;
4560: ELSE
4561: -- Update existing MMTT
4562: BEGIN
4563: UPDATE mtl_material_transactions_temp
4564: SET transaction_quantity = transaction_quantity + p_transaction_qty,
4565: primary_quantity = primary_quantity + p_primary_qty,
4566: secondary_transaction_quantity =
4567: decode(secondary_transaction_quantity, NULL, NULL, secondary_transaction_quantity+p_secondary_qty)

Line 4829: FROM mtl_material_transactions_temp

4825: BEGIN
4826: SELECT content_lpn_id, inventory_item_id, primary_quantity, transaction_uom, secondary_uom_code
4827: INTO l_cont_lpn_id, l_item_id, l_mmtt_qty, l_txn_uom
4828: , l_sec_uom --INCONV kkillams
4829: FROM mtl_material_transactions_temp
4830: WHERE transaction_header_id = p_transaction_header_id
4831: AND transaction_temp_id = p_transaction_temp_id;
4832: IF l_debug = 1 THEN
4833: trace('Found MMTT, contLPNID='||l_cont_lpn_id||', l_item_id='||l_item_id||',l_mmtt_qty='||l_mmtt_qty);

Line 4907: DELETE mtl_material_transactions_temp

4903: IF l_debug = 1 THEN
4904: trace('MMTT is for LPN or, Lot and serial number is null, deleting MMTT');
4905: END IF;
4906: END IF;
4907: DELETE mtl_material_transactions_temp
4908: WHERE transaction_temp_id = p_transaction_temp_id;
4909: l_row_count := SQL%ROWCOUNT;
4910: IF l_debug = 1 THEN
4911: trace(l_row_count||' rows of MMTT deleted with tmp_id '||p_transaction_temp_id);

Line 4977: DELETE mtl_material_transactions_temp

4973:
4974: -- MMTT
4975: IF l_mmtt_qty = abs(p_quantity) THEN
4976: -- Delete MMTT
4977: DELETE mtl_material_transactions_temp
4978: WHERE transaction_temp_id = p_transaction_temp_id;
4979: l_row_count := SQL%ROWCOUNT;
4980: IF l_debug = 1 THEN
4981: trace(l_row_count||' rows of MMTT deleted with tmp_id '||p_transaction_temp_id);

Line 4989: UPDATE mtl_material_transactions_temp

4985: IF l_row_count <> 1 THEN
4986: RAISE fnd_api.g_exc_error;
4987: END IF;
4988: ELSIF l_mmtt_qty > abs(p_quantity) THEN
4989: UPDATE mtl_material_transactions_temp
4990: SET primary_quantity = primary_quantity - abs(p_quantity)
4991: ,transaction_quantity = inv_convert.inv_um_convert(
4992: l_item_id,null,primary_quantity - abs(p_quantity),p_uom,l_txn_uom,null,null)
4993: --INVCONV kkillams