if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[paQrytm_TraRemFactMvo]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[paQrytm_TraRemFactMvo]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[paQrytm_TraRemFactMvo] @pmtmNumero VARCHAR(5)
 AS 
 SELECT tmItem,tmTipoReg,tmTipRem,tmRemesa,tmIdCiaRem,Compania,tmItemRem,tmDescripcion,tmCantidad,tmVrUnitario,tmVrCosto,tmUndTarifa,tmUndCosto,tmUnidades,tmPesoNeto,tmUndMed,tmVolumen,tmUndVol,tmCases,tmCajas,tmPalets,tmTarifaIva,tmVrIva,tmTarifaDct,tmVrDscto
,tmTarifaRet,tmVrRetFte,tmTarifaIca,tmVrReteIca,tmVrFaltante,tmRemision,tmDocCliente,tmReferencia1,tmReferencia2,tmReferencia3,tmCdMercancia,tmCdConc,tmCdCCosto,CT.CCosto,tmCdSubCos,SC.SubCosto,tmNitTercero,tmCdAgencia,tmpVehiculo,tmTipoVehic,tmNitRemite,tmRemitente,tmDirOrigen
,tmIdOrigen,CO.Localidad AS CiudadOrigen,CO.IdDep AS CodDepOrigen,DPO.Departamento AS DptoOrigen,tmNitDestntario,tmDestinatario,tmDirDestino,tmIdDestino,CD.Localidad AS CiudadDestino,CD.IdDep AS CodDepDestino,DPD.Departamento AS DptoDestino,tmCantFalt,tmUnidadFalt
,tmCdTarRet,tmCdTarIca,tmCdTarDct,tmPedRem,tmCiaPed,tmEtdoFact,tmFecRemesa,tmIntCumplido,tmVrDeclarado,tmTarifSeguro,tmVrSeguro,tmNitAsegurad,tmCostoCump,tmTipoOrd,tmNumOrden,tmIdCiaOrd
,tmCantPago,tmVrAutoIca,tmRemTransb,tmCostoAdic,tmNitMucTbdo,tmTipoNov,tmItemOrd,tmTarifIat,tmVrAviTab,tmCdTarifIat,tmTarifBom,tmVrSobBom,tmCdTarifBom,tmVrAutoIat,tmVrAutoBom
,tmEstado,tmObserv,tmTotFletes,tmTotOtros,tmTotCargos,tmTotDctos,tmTotCostoAfi,tmTotCostoRem,tmReteCree,tmTarifaCree,tmCdTarCree,tmReteIva,tmTarifaRiv,tmCdTarRiv,tmTarifaAri,tmCdTarAri,tmBaseIva,tmBaseRet,tmBaseIca,tmBaseRiv,tmVrNeto
,R.Fecha,R.FecDespacho,R.IdCliente,TC.RazonSocial,R.IdAgencia,A.Agencia AS NomAgencia,R.nRemolque,R.Modalidad,R.NumPedido,R.IdCiaPed,R.FechaPed,R.TipDcm,R.NumDocmto,R.IdCiaDcm,R.NumManif,R.IdCiaManif,R.EstCumplido,R.EstFactura,R.Observacion AS Observ
,R.CdRutaTarif,RT.Ruta AS DescRuta,R.IdConductor AS CedConductor,CDT.RazonSocial AS NomConductor
 FROM tm_TraRemFact AS T INNER JOIN Companias AS CN ON T.tmIdCiaRem=CN.IdCia
 INNER JOIN Localidades AS CO ON T.tmIdOrigen=CO.IdLocal INNER JOIN Departamentos AS DPO ON CO.IdDep=DPO.IdDep
 INNER JOIN Localidades AS CD ON T.tmIdDestino=CD.IdLocal INNER JOIN Departamentos AS DPD ON CD.IdDep=DPD.IdDep
 INNER JOIN Trn_TraRemesa AS R ON T.tmTipRem=R.TipDoc AND T.tmRemesa=R.NumOrden AND T.tmIdCiaRem=R.IdCia
 INNER JOIN Terceros AS TC ON R.IdCliente=TC.IdTercero INNER JOIN Terceros AS CDT ON R.IdConductor=CDT.IdTercero   
 LEFT JOIN Agencias AS A ON R.IdAgencia=A.IdAgencia LEFT JOIN Rutas AS RT ON R.CdRutaTarif=RT.IdRuta
 LEFT JOIN CentroCosto AS CT ON T.tmCdCCosto=CT.IdCCosto LEFT JOIN SubCentros AS SC ON T.tmCdSubCos=SC.IdSubCos
 WHERE tmNumero=@pmtmNumero
GO