[Home] [Help]
6665: NVL(msnt1.fm_serial_number, msnt2.fm_serial_number),
6666: NVL(msnt1.to_serial_number, msnt2.to_serial_number)
6667: , mmtt.secondary_transaction_quantity --INVCONV kkillams
6668: , mmtt.secondary_uom_code --INVCONV kkillams
6669: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt, mtl_serial_numbers_temp msnt1, mtl_serial_numbers_temp msnt2
6670: WHERE mmtt.organization_id = p_organization_id
6671: AND mmtt.transaction_header_id = l_trx_header_id
6672: AND mtlt.transaction_temp_id(+) = mmtt.transaction_temp_id
6673: AND msnt1.transaction_temp_id(+) = mtlt.serial_transaction_temp_id
6928: IF (l_debug = 1) THEN
6929: mdebug('inserting serials '|| l_serial_number_from || '-' || l_serial_number_to || ' into mmtt', G_INFO);
6930: mdebug('with l_trx_tmp_id='|| l_trx_tmp_id, G_INFO);
6931: END IF;
6932: --Insert serials into MTL_SERIAL_NUMBERS_TEMP
6933: x_error_code := inv_trx_util_pub.insert_ser_trx(
6934: p_trx_tmp_id=> l_trx_tmp_id,
6935: p_user_id=> fnd_global.user_id,
6936: p_fm_ser_num=> l_serial_number_from,
8346: END IF;
8347: l_insert_lot_rec := FALSE;
8348: END IF;
8349:
8350: -- Insert record into MTL_SERIAL_NUMBERS_TEMP
8351: IF ( l_insert_ser_rec ) THEN
8352: OPEN LPN_serial_cur(Nested_LPN_rec.lpn_id, l_crnt_item_rec.inventory_item_id,
8353: l_crnt_item_rec.revision, l_crnt_item_rec.lot_number);
8354: FETCH LPN_serial_cur INTO l_crnt_ser_rec;