SELECT FAC.conFactura, FAC.mtoFactura, FAC.codMoneda,
CASE WHEN PGE.codigo = 'ESOP' THEN 'Preventivo'
			WHEN PGE.codigo = 'OCES' THEN 'Correctivo' END tipoMantenimiento															-- 15.Adicional (PENDIENTE)
		FROM dbo.Factura AS FAC
			LEFT OUTER JOIN dbo.ActaRecepcion AS AR ON (AR.conActaRecepcion = FAC.conActaRecepcion)
				LEFT OUTER JOIN dbo.FallaManoObra AS FMO ON (FMO.conActaRecepcion = AR.conActaRecepcion)
				LEFT OUTER JOIN dbo.FallaRepuesto AS FRP ON (FRP.conActaRecepcion = AR.conActaRecepcion)
				LEFT OUTER JOIN dbo.FallaCombustibleLubricante AS FCL ON (FCL.conActaRecepcion = AR.conActaRecepcion)
				INNER JOIN dbo.DiagnosticoFalla AS DGF ON ((DGF.conFalla = FMO.conFalla) OR (DGF.conFalla = FRP.conFalla) OR (DGF.conFalla = FCL.conFalla))
				INNER JOIN dbo.Diagnostico AS DG ON (DG.conDiagnostico = DGF.conDiagnostico)
			LEFT OUTER JOIN dbo.OrdenTrabajo AS OT ON (OT.numOrden = DG.numOrden)
			INNER JOIN ParametroGeneralDetalle PGD2 ON (PGD2.codigo = OT.estOrden)
			INNER JOIN ParametroGeneral PGE ON (PGE.codigo = PGD2.codigoPadre)
			INNER JOIN dbo.Vehiculo AS VH ON (VH.idVeh = OT.idVeh)
			INNER JOIN dbo.OrdenGira AS OG ON (OG.numOrden = OT.numOrden)
		WHERE OT.indActivo = 1 AND DG.indActivo = 1 AND FAC.codEstado = 'ESFA'