APPS.WMS_PACKING_WORKBENCH_PVT dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 719: ' 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)))) ';

715: '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) '||
716: '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)) '||
717: 'AND ((mol.lpn_id IS NULL) OR '||
718: ' (mol.lpn_id IS NOT NULL AND (NOT exists (select 1 from wms_dispatched_tasks wdt where wdt.transfer_lpn_id = mol.lpn_id)) '||
719: ' 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)))) ';
720:
721: l_sub_where_str VARCHAR2(100) :=
722: ' AND (nvl(lpn.subinventory_code,mol.from_subinventory_code)=:subinventory) ';
723:

Line 3202: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt

3198: INTO l_mmtt_exists, l_cur_rec.move_order_line_id, l_cur_rec.inventory_item_id
3199: , l_cur_rec.revision, l_cur_rec.transaction_quantity, l_cur_rec.transaction_uom
3200: , l_cur_rec.lot_number, l_cur_rec.serial_transaction_temp_id
3201: , l_cur_rec.secondary_transaction_quantity, l_cur_rec.secondary_uom_code --INVCONV kkillams
3202: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt
3203: WHERE mtlt.transaction_temp_id(+) = mmtt.transaction_temp_id
3204: AND mmtt.transaction_header_id = p_transaction_header_id
3205: AND mmtt.transaction_temp_id = p_transaction_temp_id
3206: AND mmtt.inventory_item_id <> -1

Line 3914: UPDATE mtl_material_transactions_temp

3910: x_transaction_temp_id := l_txn_tmp_id;
3911: ELSE
3912: -- Update existing MMTT
3913: BEGIN
3914: UPDATE mtl_material_transactions_temp
3915: SET transaction_quantity = transaction_quantity + l_mol_list(i).transaction_quantity,
3916: primary_quantity = primary_quantity + l_mol_list(i).primary_quantity,
3917: secondary_transaction_quantity = CASE WHEN l_mol_list(i).secondary_transaction_quantity IS NOT NULL
3918: THEN l_mol_list(i).secondary_transaction_quantity + secondary_transaction_quantity

Line 4178: FROM mtl_material_transactions_temp mmtt

4174: p_revision IS NULL and (p_lot_number IS NOT NULL or p_fm_serial_number IS NOT NULL) THEN
4175: BEGIN
4176: SELECT 1
4177: INTO l_mmtt_exists
4178: FROM mtl_material_transactions_temp mmtt
4179: WHERE mmtt.transaction_header_id = p_transaction_header_id
4180: AND mmtt.transaction_temp_id = p_transaction_temp_id
4181: AND mmtt.content_lpn_id IS NULL
4182: AND mmtt.inventory_item_id = p_inventory_item_id

Line 4397: UPDATE mtl_material_transactions_temp

4393: l_ser_txn_id := l_txn_tmp_id;
4394: ELSE
4395: -- Update existing MMTT
4396: BEGIN
4397: UPDATE mtl_material_transactions_temp
4398: SET transaction_quantity = transaction_quantity + p_transaction_qty,
4399: primary_quantity = primary_quantity + p_primary_qty,
4400: secondary_transaction_quantity =
4401: decode(secondary_transaction_quantity, NULL, NULL, secondary_transaction_quantity+p_secondary_qty)

Line 4663: FROM mtl_material_transactions_temp

4659: BEGIN
4660: SELECT content_lpn_id, inventory_item_id, primary_quantity, transaction_uom, secondary_uom_code
4661: INTO l_cont_lpn_id, l_item_id, l_mmtt_qty, l_txn_uom
4662: , l_sec_uom --INCONV kkillams
4663: FROM mtl_material_transactions_temp
4664: WHERE transaction_header_id = p_transaction_header_id
4665: AND transaction_temp_id = p_transaction_temp_id;
4666: IF l_debug = 1 THEN
4667: trace('Found MMTT, contLPNID='||l_cont_lpn_id||', l_item_id='||l_item_id||',l_mmtt_qty='||l_mmtt_qty);

Line 4741: DELETE mtl_material_transactions_temp

4737: IF l_debug = 1 THEN
4738: trace('MMTT is for LPN or, Lot and serial number is null, deleting MMTT');
4739: END IF;
4740: END IF;
4741: DELETE mtl_material_transactions_temp
4742: WHERE transaction_temp_id = p_transaction_temp_id;
4743: l_row_count := SQL%ROWCOUNT;
4744: IF l_debug = 1 THEN
4745: trace(l_row_count||' rows of MMTT deleted with tmp_id '||p_transaction_temp_id);

Line 4811: DELETE mtl_material_transactions_temp

4807:
4808: -- MMTT
4809: IF l_mmtt_qty = abs(p_quantity) THEN
4810: -- Delete MMTT
4811: DELETE mtl_material_transactions_temp
4812: WHERE transaction_temp_id = p_transaction_temp_id;
4813: l_row_count := SQL%ROWCOUNT;
4814: IF l_debug = 1 THEN
4815: trace(l_row_count||' rows of MMTT deleted with tmp_id '||p_transaction_temp_id);

Line 4823: UPDATE mtl_material_transactions_temp

4819: IF l_row_count <> 1 THEN
4820: RAISE fnd_api.g_exc_error;
4821: END IF;
4822: ELSIF l_mmtt_qty > abs(p_quantity) THEN
4823: UPDATE mtl_material_transactions_temp
4824: SET primary_quantity = primary_quantity - abs(p_quantity)
4825: ,transaction_quantity = inv_convert.inv_um_convert(
4826: l_item_id,null,primary_quantity - abs(p_quantity),p_uom,l_txn_uom,null,null)
4827: --INVCONV kkillams