[Home] [Help]
7225: NVL(msnt1.fm_serial_number, msnt2.fm_serial_number),
7226: NVL(msnt1.to_serial_number, msnt2.to_serial_number)
7227: , mmtt.secondary_transaction_quantity --INVCONV kkillams
7228: , mmtt.secondary_uom_code --INVCONV kkillams
7229: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt, mtl_serial_numbers_temp msnt1, mtl_serial_numbers_temp msnt2
7230: WHERE mmtt.organization_id = p_organization_id
7231: AND mmtt.transaction_header_id = l_trx_header_id
7232: AND mtlt.transaction_temp_id(+) = mmtt.transaction_temp_id
7233: AND msnt1.transaction_temp_id(+) = mtlt.serial_transaction_temp_id
7488: IF (l_debug = 1) THEN
7489: mdebug('inserting serials '|| l_serial_number_from || '-' || l_serial_number_to || ' into mmtt', G_INFO);
7490: mdebug('with l_trx_tmp_id='|| l_trx_tmp_id, G_INFO);
7491: END IF;
7492: --Insert serials into MTL_SERIAL_NUMBERS_TEMP
7493: x_error_code := inv_trx_util_pub.insert_ser_trx(
7494: p_trx_tmp_id=> l_trx_tmp_id,
7495: p_user_id=> fnd_global.user_id,
7496: p_fm_ser_num=> l_serial_number_from,
8917: END IF;
8918: l_insert_lot_rec := FALSE;
8919: END IF;
8920:
8921: -- Insert record into MTL_SERIAL_NUMBERS_TEMP
8922: IF ( l_insert_ser_rec ) THEN
8923: OPEN LPN_serial_cur(Nested_LPN_rec.lpn_id, l_crnt_item_rec.inventory_item_id,
8924: l_crnt_item_rec.revision, l_crnt_item_rec.lot_number);
8925: FETCH LPN_serial_cur INTO l_crnt_ser_rec;