SELECT CONC.Numero AS ContratoId,
       DocumentoRecursos.Clave AS PTEId,
       Concepto.OID OIDConcepto,
       DetalleExpConcepto.OID OIDRecurso,
       CPAD.Clave AS Anexo,
       LTRIM(RTRIM(Concepto.Clave)) AS Partida,
       Recurso.Clave AS Recurso,
       Recurso.Descripcion AS Descripcion,
       VCANT.Inicia,
       VCANT.Termina,
       seccionhij.SeccionSistema,
       unidadpad.Siglas AS UnidadPU,
       Unidad.Siglas AS Unidad,
       VCANT.Valor AS Cantidad,
       CASE
           WHEN VMN.OID IS NULL
           THEN 0
           ELSE VMN.Valor
       END AS ImporteMXN,
       CASE
           WHEN VME.OID IS NULL
           THEN 0
           ELSE VME.Valor
       END AS ImporteUSD
FROM DocumentoRecursos
     INNER JOIN Presupuesto ON DocumentoRecursos.OID = Presupuesto.Documento
     INNER JOIN Concepto ON Presupuesto.OID = Concepto.PresuProgPadre
     INNER JOIN Concepto AS CPAD ON CPAD.OID = Concepto.ConceptoPadre
     INNER JOIN DetalleExpConcepto ON Concepto.OID = DetalleExpConcepto.ConceptoPadre
     INNER JOIN Recurso AS recpadre ON Concepto.Recurso = recpadre.OID
     INNER JOIN Recurso ON DetalleExpConcepto.RecursoHijo = Recurso.OID
     INNER JOIN DistPeriodos PCANT ON DetalleExpConcepto.PeriodosCant = PCANT.OID
     INNER JOIN PeriodoValor VCANT ON PCANT.OID = VCANT.DistriPadre
     INNER JOIN Unidad AS unidadpad ON recpadre.Unidad = unidadpad.OID
     LEFT JOIN Unidad ON Recurso.Unidad = Unidad.OID
     LEFT JOIN DistPeriodos PMN ON DetalleExpConcepto.PeriodosMN = PMN.OID
     LEFT JOIN DistPeriodos PME ON DetalleExpConcepto.PeriodosME = PME.OID
     LEFT JOIN PeriodoValor VMN ON VMN.DistriPadre = PMN.OID
                                   AND VMN.Inicia = VCANT.Inicia
     LEFT JOIN PeriodoValor VME ON VME.DistriPadre = PME.OID
                                   AND VME.Inicia = VCANT.Inicia
     INNER JOIN Concurso CONC ON CONC.OID = DocumentoRecursos.Concurso
     INNER JOIN Seccion AS seccionhij ON seccionhij.OID = Recurso.Seccion
WHERE DocumentoRecursos.Clave = ''
      AND CONC.Numero = ''