SELECT DISTINCT T_VIA.*,
                          T_TVI.*,
                          T_ECO.*,
                          T_ESI.*,
                          T_NUC.*,
                          TRM_PNU,
                          TRM_PLE,
                          TRM_ULN,
                          TRM_ULL
            FROM T_VIA
                 LEFT JOIN T_TRM
                 ON (    VIA_PAI = TRM_PAI
                     AND VIA_PRV = TRM_PRV
                     AND VIA_MUN = TRM_MUN
                     AND VIA_COD = TRM_VIA)
                 LEFT JOIN T_NUC
                 ON (    TRM_NPA = NUC_PAI
                     AND TRM_NPR = NUC_PRV
                     AND TRM_NMU = NUC_MUN
                     AND TRM_NES = NUC_ESI
                     AND TRM_NUC = NUC_COD)
                 LEFT JOIN T_ESI
                 ON (    NUC_PAI = ESI_PAI
                     AND NUC_PRV = ESI_PRV
                     AND NUC_MUN = ESI_MUN
                     AND NUC_ESI = ESI_COD)
                 LEFT JOIN T_ECO
                 ON (ESI_PRV = ECO_PRV AND ESI_MUN = ECO_MUN AND ESI_ECO = ECO_COD)
                 LEFT JOIN T_TVI
                 ON (VIA_TVI = TVI_COD)
           WHERE     VIA_SIT = 'A'
                 AND VIA_PAI = 108
                 AND VIA_PRV LIKE (5)
                 AND VIA_MUN LIKE (30)
                 AND ( (VIA_NOM LIKE '%%' ESCAPE '·'))
                 AND ('A' = TRM_SIT)
        ORDER BY VIA_NOM, ESI_NOM, NUC_NOM