insert into PP_FAPEDL (numped, codemp, codcli, codart, pneto, volumen, descr, canped, exist, numlin, numalm, ubiart, enviada)
select fapedl.numped as numped
     , fapedl.codemp as codemp
	 , fapedl.codcli as codcli
	 , fapedl.codart as codart
	 , alart.pneto as pneto
	 , alartdv.dva2 as volumen
	 , fapedl.descr as descr
	 , fapedl.canped as canped
	 , almac.exist as exist
	 , fapedl.numlin as numlin
	 , fapedl.numalm as numalm
	 , alartdv.dva12 as ubiart
	 ,'N' as enviada
from  RPS.dbo.fapedl LEFT JOIN RPS.dbo.alart ON alart.codart = fapedl.codart AND alart.codemp = fapedl.codemp
                    LEFT JOIN RPS.dbo.almac ON almac.nomart = fapedl.codart AND almac.codemp = fapedl.codemp AND almac.nalm = fapedl.numalm
                     LEFT JOIN RPS.dbo.alartdv ON alartdv.codart = fapedl.codart AND alartdv.codemp = fapedl.codemp
where fapedl.numped='1234'