
insert into inv_tipinv
select TIPO_INV,DES_TIPINV,'S'  from qrf.inv_tipinv;     
insert into inv_parametro
(COD_CIA,TIP_VALUAC,FOR_ARTICULO,FOR_LINEA,IND_INTCONTA,COD_CTAINVENT,          
COD_CTAENTRADA,COD_CTASALIDA,IND_CTLLOTE,IND_CTLDESP,IND_RECTRAS_AUTO,       
IND_COSPRO_GLO,PRE_ARTEMP,CON_ARTEMP)             
select COD_CIA,TIP_VALUAC,FOR_ARTICULO,FOR_LINEA,IND_INTCONTA,COD_CTAINVENT,          
COD_CTAENTRADA,COD_CTASALIDA,IND_CTLLOTE,IND_CTLDESP,IND_RECTRAS_AUTO,       
IND_COSPRO_GLO,PRE_ARTEMP,CON_ARTEMP from qrf.inv_parametro;
insert into inv_deptos
(COD_CIA,COD_DEPTO,DESCRIPCION,IND_IMPTOVNT,BLQPRECIOS,BODEGA,CCOSTO,SUFIJOCONTABLE)
select COD_CIA,COD_DEPTO,DESCRIPCION,IND_IMPTOVNT,BLQPRECIOS,null,null,null from qrf.inv_deptos;
insert into inv_linea select * from qrf.inv_linea;
insert into inv_clase select * from qrf.inv_clase;
insert into inv_marca select * from qrf.inv_marca;
insert into inv_comb_lcm select * from qrf.inv_comb_lcm;
insert into inv_medida select * from qrf.inv_medida;
insert into inv_bodega select * from qrf.inv_bodega;

insert into inv_articulo
(COD_CIA,COD_ARTICULO,TIPO_INV,COD_LINEA,COD_CLASE,COD_MARCA,DES_ARTICULO,           
IND_BLOQUEADO,MEDIDA,COD_MONEDA,MIN_VENTA,MAXDESCUENTO,CLASE_ABC,FRACCION,               
FEC_ULTMOD,COD_DEPTO,DES_BLOQUEADO,COD_TABCOMSN,IMPTOCONS,IMPTOVTAS,              
PESO,COD_PARTIDA,PROVEEDOR_TITULAR) 
select COD_CIA,COD_ARTICULO,TIPO_INV,COD_LINEA,COD_CLASE,COD_MARCA,DES_ARTICULO,           
IND_BLOQUEADO,MEDIDA,COD_MONEDA,MIN_VENTA,NULL,CLASE_ABC,FRACCION,               
FEC_ULTMOD,COD_DEPTO,DES_BLOQUEADO,COD_TABCOMSN,'ISC'||por_IMPTOCON,decode(ind_imptovnt,'S','ISV',NULL),              
PESO,COD_PARTIDA,PROVEEDOR_TITULAR from qrf.inv_articulo;     

insert into INV_LOTE select * from qrf.INV_LOTE;                                                                               

insert into inv_concepmovto select * from qrf.inv_concepmovto;

insert into INV_CONSEC_MOVTOS select * from qrf.INV_CONSEC_MOVTOS;                                                                                                                                              

insert into inv_encabmovimiento select * from qrf.inv_encabmovimiento;

insert into inv_detmovimiento select * from qrf.inv_detmovimiento;

insert into inv_encabtraslado select * from qrf.inv_encabtraslado;

-- delete from INV_ACUM_PERIODO;                                                                       

insert into INV_ARTICULO_CON_LOTE select * from qrf.INV_ARTICULO_CON_LOTE;                                                                  
insert into INV_ARTIC_BODEGA select * from qrf.INV_ARTIC_BODEGA;                                                                       
insert into INV_ARTIC_DESCOR select * from qrf.inv_artic_descor;                                                                       
insert into INV_ARTIC_LOCBOD select * from qrf.inv_artic_locbod;                                                                       
insert into INV_ARTIC_MEDIDA select * from qrf.inv_artic_medida;                                                                       
insert into INV_ARTIC_PROV   select * from qrf.inv_artic_prov;                                                                         
insert into INV_ATRIBUTOS select * from qrf.inv_atributos;                                                                          
insert into INV_ATRVAL       select * from qrf.inv_atrval;                                                                             
insert into INV_CONTEO       select * from qrf.inv_conteo;                                                                             
insert into INV_DETALLES     select * from qrf.inv_detalles;                                                                           
insert into INV_ENCABTABLACOMSN select * from qrf.inv_encabtablacomsn;                                                                    
insert into INV_ENCMOVDESP select * from qrf.inv_encmovdesp;                                                                         
insert into INV_ENCSOLTRASLADO select * from qrf.encsoltraslado;                                                                     
insert into INV_HIST_ENC_MOVTO select * from qrf.inv_hist_enc_movto;                                                                     
insert into INV_DETMOVDESP   select * from qrf.inv_detmovdesp;                                                                         
insert into INV_DETSOLTRASLADO select * from qrf.inv_detsoltraslado;                                                                     
insert into INV_DETTABLACOMSN select * from qrf.inv_dettablacomsn;                                                                                                                                    
insert into INV_GRUPO select * from qrf.inv_grupo;                                                                              
insert into INV_GRUPODET select * from qrf.inv_grupodet;                                                                           
insert into INV_HIST_DET_MOVTO select * from qrf.inv_hist_det_movto;                                                                     
insert into INV_HIST_LOTE select * from qrf.inv_hist_lote;                                                                          
insert into INV_LOTE_ARTIC_BODEGA select * from qrf.inv_lote_artic_bodega;
insert into INV_MOVGRUPO select * from qrf.inv_Movgrupo;                                                                           
insert into INV_MOVGRUPODET select * from qrf.inv_movgrupodet;                                                                        
insert into INV_NIVLOC select * from qrf.inv_Nivloc;                                                                             
insert into INV_NOMLOC select * from qrf.inv_nomloc;
insert into INV_LOC select * from qrf.inv_loc;
insert into INV_SUSTITUTO select * from qrf.inv_sustituto;                                                                          
insert into INV_TABLABONIFIC select * from qrf.inv_tablabonific;                                                                       
insert into INV_TABLADESC select * from qrf.inv_tabladesc;
insert into INV_TOMAFIS select * from qrf.inv_tomafis;  
insert into INV_DETTOMAFIS select * from qrf.inv_dettomafis;
/*
inv_detexisfis
(SECUENCIA,COD_LOTE,COD_ARTICULO,LOCALIZA,CAN_EXISTE,CAN_FISICO,COSTO)          
select SECUENCIA,COD_LOTE,COD_ARTICULO,LOCALIZA,CAN_EXISTE,CAN_FISICO,COSTO
 from qrf.inv_detexisfis; */    