Histórico da Página

...

        AND TRX_TPMULT = 'TRANSITO'
        AND TRX.D_E_L_E_T_ = ' '
      GROUP BY TRX_NOME
      ORDER BY TRX_NOME

cod 02
SELECT COUNT(*) AS QTDE_FROTAS
      FROM xEmp('FQ4') FQ4
      INNER JOIN xEmp('FQD') FQD
        ON FQD_FILIAL = ' '
        AND FQD_STAREN = '20'
        AND FQ4_STATUS = FQD_STATQY
        AND FQD.D_E_L_E_T_ = ' '
      INNER JOIN xEmp('FP0') FP0
        ON FP0_FILIAL = xFilial('FP0')
        AND FQ4_PROJET = FP0_PROJET
        AND FP0.D_E_L_E_T_ = ' '
        AND FP0_CLI = '${CLIENT_ID}'
        AND FP0_LOJA = '${CLIENT_LOJA}'
      INNER JOIN xEmp('ST9') ST9
        ON T9_CODBEM = FQ4_CODBEM
        AND ST9DA4_COD,DA4_NOME,DA4_CGC,DA4_NUMCNH 
FROM "+RETSQLNAME("DA4")+" DA4 " 
WHERE DA4_FILIAL = '" + xFilial('DA4') + "' "
AND DA4_CODCLI  = '"+cCli+"' "
AND DA4_LOJCLI = '"+cLoja+"' "  
AND DA4.D_E_L_E_T_ = ' '
      WHERE FQ4.D_E_L_E_T_ = ' '"

cod03
SELECT COUNT(*) AS QTDE_NOTIFICACOES_MULTAS
      FROM xEmp('TRX') TRX
      INNER JOIN xEmp('FP0') FP0
        ON FP0_FILIAL = xFilial('FP0')
        AND FP0.D_E_L_E_T_ = ' '
        AND FP0_CLI = '${CLIENT_ID}'
        AND FP0_LOJA = '${CLIENT_LOJA}'
      INNER JOIN xEmp('FPA') FPA
        ON FPA_FILIAL = xFilial('FPA')
        AND FPA_PROJET = FP0_PROJET
        AND FPA.D_E_L_E_T_ = ' '
        AND FPA_AS <> ''

...