APPS.WMS_PACKING_WORKBENCH_PVT dependencies on MTL_TRANSACTION_LOTS_TEMP

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 4102: UPDATE mtl_transaction_lots_temp

4098:
4099: -- Update MTLT
4100: IF p_lot_number IS NOT NULL THEN
4101: BEGIN
4102: UPDATE mtl_transaction_lots_temp
4103: SET transaction_quantity = transaction_quantity + l_mol_list(i).transaction_quantity,
4104: primary_quantity = primary_quantity + l_mol_list(i).primary_quantity,
4105: secondary_quantity = CASE WHEN l_mol_list(i).secondary_transaction_quantity IS NOT NULL
4106: THEN l_mol_list(i).secondary_transaction_quantity + secondary_quantity

Line 4843: FROM mtl_transaction_lots_temp mtlt, mtl_serial_numbers_temp msnt

4839: SELECT mtlt_row_id, mtlt_qty, msnt_row_id
4840: INTO l_mtlt_row_id, l_mtlt_qty, l_msnt_row_id
4841: FROM
4842: (SELECT mtlt.rowid mtlt_row_id, mtlt.primary_quantity mtlt_qty, msnt.rowid msnt_row_id
4843: FROM mtl_transaction_lots_temp mtlt, mtl_serial_numbers_temp msnt
4844: WHERE msnt.transaction_temp_id = mtlt.serial_transaction_temp_id
4845: AND mtlt.transaction_temp_id = p_transaction_temp_id
4846: AND mtlt.lot_number = p_lot_number
4847: AND msnt.fm_serial_number = p_serial_number

Line 4860: FROM mtl_transaction_lots_temp

4856: SELECT t.mtlt_row_id, t.mtlt_qty
4857: INTO l_mtlt_row_id, l_mtlt_qty
4858: FROM
4859: (SELECT rowid mtlt_row_id, primary_quantity mtlt_qty
4860: FROM mtl_transaction_lots_temp
4861: WHERE transaction_temp_id = p_transaction_temp_id
4862: AND lot_number = p_lot_number
4863: AND primary_quantity = p_quantity
4864: order by creation_date desc) t

Line 4939: DELETE mtl_transaction_lots_temp

4935:
4936: IF p_lot_number IS NOT NULL THEN
4937: IF l_mtlt_qty = abs(p_quantity) THEN
4938: -- Delete MTLT
4939: DELETE mtl_transaction_lots_temp
4940: WHERE rowid = l_mtlt_row_id;
4941: l_row_count := SQL%ROWCOUNT;
4942: IF l_debug = 1 THEN
4943: trace(l_row_count||' rows of MTLT deleted with row_id '||l_mtlt_row_id);

Line 4952: UPDATE mtl_transaction_lots_temp

4948: RAISE fnd_api.g_exc_error;
4949: END IF;
4950: ELSIF l_mtlt_qty > abs(p_quantity) THEN
4951: -- Update MTLT
4952: UPDATE mtl_transaction_lots_temp
4953: SET primary_quantity = primary_quantity - abs(p_quantity)
4954: ,transaction_quantity = inv_convert.inv_um_convert(
4955: l_item_id,null,primary_quantity - abs(p_quantity),p_uom,l_txn_uom,null,null)
4956: WHERE rowid = l_mtlt_row_id;