API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Aug 31st, 2015
68
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 7.54 KB | None | 0 0
raw download clone embed print report
  1. "SELECT" +
  2. "t0.id, t0.conta, t0.descricao, t1.CONTA, t1.descricao, t0.dt_inclusao_alteracao_sped, t0.analitica, " +
  3. "t2.config_geral_resultado_exercicio, sI.valor, " +
  4. "sad01.valor, sac01.valor, sad02.valor, sac02.valor, sad03.valor, sac03.valor, sad04.valor, sac04.valor, sad05.valor, sac05.valor, sad06.valor, sac06.valor, " +
  5. "sad07.valor, sac07.valor, sad08.valor, sac08.valor, sad09.valor, sac09.valor, sad10.valor, sac10.valor, sad11.valor, sac11.valor, sad12.valor, sac12.valor " +
  6. "FROM ger_plano_conta t0 " +
  7. "LEFT OUTER JOIN mcg_plano_conta t2 ON (t2.id_ger_plano_conta = t0.ID) " +
  8. "LEFT OUTER JOIN mcg_plano_conta_referencial t1 ON (t1.ID = t2.id_mcg_plano_conta_referencial_ecf) " +
  9. "LEFT OUTER JOIN mcg_saldo_anterior sI ON (sI.id_ger_plano_conta = t0.ID) " +
  10. "LEFT OUTER JOIN ( SELECT COALESCE(SUM(valor),0) as valor, id_ger_plano_conta_debito FROM mcg_lancamento WHERE id_ger_empresa = ? AND dt_lancamento < ? GROUP BY id_ger_plano_conta_debito ) as sad01 ON (sad01.id_ger_plano_conta_debito = t0.ID) " +
  11. "LEFT OUTER JOIN ( SELECT COALESCE(SUM(valor),0) as valor, id_ger_plano_conta_credito FROM mcg_lancamento WHERE id_ger_empresa = ? AND dt_lancamento < ? GROUP BY id_ger_plano_conta_credito) as sac01 ON (sac01.id_ger_plano_conta_credito = t0.ID) " +
  12. "LEFT OUTER JOIN ( SELECT COALESCE(SUM(valor),0) as valor, id_ger_plano_conta_debito FROM mcg_lancamento WHERE id_ger_empresa = ? AND dt_lancamento < ? GROUP BY id_ger_plano_conta_debito ) as sad02 ON (sad02.id_ger_plano_conta_debito = t0.ID) " +
  13. "LEFT OUTER JOIN ( SELECT COALESCE(SUM(valor),0) as valor, id_ger_plano_conta_credito FROM mcg_lancamento WHERE id_ger_empresa = ? AND dt_lancamento < ? GROUP BY id_ger_plano_conta_credito) as sac02 ON (sac02.id_ger_plano_conta_credito = t0.ID) " +
  14. "LEFT OUTER JOIN ( SELECT COALESCE(SUM(valor),0) as valor, id_ger_plano_conta_debito FROM mcg_lancamento WHERE id_ger_empresa = ? AND dt_lancamento < ? GROUP BY id_ger_plano_conta_debito ) as sad03 ON (sad03.id_ger_plano_conta_debito = t0.ID) " +
  15. "LEFT OUTER JOIN ( SELECT COALESCE(SUM(valor),0) as valor, id_ger_plano_conta_credito FROM mcg_lancamento WHERE id_ger_empresa = ? AND dt_lancamento < ? GROUP BY id_ger_plano_conta_credito) as sac03 ON (sac03.id_ger_plano_conta_credito = t0.ID) " +
  16. "LEFT OUTER JOIN ( SELECT COALESCE(SUM(valor),0) as valor, id_ger_plano_conta_debito FROM mcg_lancamento WHERE id_ger_empresa = ? AND dt_lancamento < ? GROUP BY id_ger_plano_conta_debito ) as sad04 ON (sad04.id_ger_plano_conta_debito = t0.ID) " +
  17. "LEFT OUTER JOIN ( SELECT COALESCE(SUM(valor),0) as valor, id_ger_plano_conta_credito FROM mcg_lancamento WHERE id_ger_empresa = ? AND dt_lancamento < ? GROUP BY id_ger_plano_conta_credito) as sac04 ON (sac04.id_ger_plano_conta_credito = t0.ID) " +
  18. "LEFT OUTER JOIN ( SELECT COALESCE(SUM(valor),0) as valor, id_ger_plano_conta_debito FROM mcg_lancamento WHERE id_ger_empresa = ? AND dt_lancamento < ? GROUP BY id_ger_plano_conta_debito ) as sad05 ON (sad05.id_ger_plano_conta_debito = t0.ID) " +
  19. "LEFT OUTER JOIN ( SELECT COALESCE(SUM(valor),0) as valor, id_ger_plano_conta_credito FROM mcg_lancamento WHERE id_ger_empresa = ? AND dt_lancamento < ? GROUP BY id_ger_plano_conta_credito) as sac05 ON (sac05.id_ger_plano_conta_credito = t0.ID) " +
  20. "LEFT OUTER JOIN ( SELECT COALESCE(SUM(valor),0) as valor, id_ger_plano_conta_debito FROM mcg_lancamento WHERE id_ger_empresa = ? AND dt_lancamento < ? GROUP BY id_ger_plano_conta_debito ) as sad06 ON (sad06.id_ger_plano_conta_debito = t0.ID) " +
  21. "LEFT OUTER JOIN ( SELECT COALESCE(SUM(valor),0) as valor, id_ger_plano_conta_credito FROM mcg_lancamento WHERE id_ger_empresa = ? AND dt_lancamento < ? GROUP BY id_ger_plano_conta_credito) as sac06 ON (sac06.id_ger_plano_conta_credito = t0.ID) " +
  22. "LEFT OUTER JOIN ( SELECT COALESCE(SUM(valor),0) as valor, id_ger_plano_conta_debito FROM mcg_lancamento WHERE id_ger_empresa = ? AND dt_lancamento < ? GROUP BY id_ger_plano_conta_debito ) as sad07 ON (sad07.id_ger_plano_conta_debito = t0.ID) " +
  23. "LEFT OUTER JOIN ( SELECT COALESCE(SUM(valor),0) as valor, id_ger_plano_conta_credito FROM mcg_lancamento WHERE id_ger_empresa = ? AND dt_lancamento < ? GROUP BY id_ger_plano_conta_credito) as sac07 ON (sac07.id_ger_plano_conta_credito = t0.ID) " +
  24. "LEFT OUTER JOIN ( SELECT COALESCE(SUM(valor),0) as valor, id_ger_plano_conta_debito FROM mcg_lancamento WHERE id_ger_empresa = ? AND dt_lancamento < ? GROUP BY id_ger_plano_conta_debito ) as sad08 ON (sad08.id_ger_plano_conta_debito = t0.ID) " +
  25. "LEFT OUTER JOIN ( SELECT COALESCE(SUM(valor),0) as valor, id_ger_plano_conta_credito FROM mcg_lancamento WHERE id_ger_empresa = ? AND dt_lancamento < ? GROUP BY id_ger_plano_conta_credito) as sac08 ON (sac08.id_ger_plano_conta_credito = t0.ID) " +
  26. "LEFT OUTER JOIN ( SELECT COALESCE(SUM(valor),0) as valor, id_ger_plano_conta_debito FROM mcg_lancamento WHERE id_ger_empresa = ? AND dt_lancamento < ? GROUP BY id_ger_plano_conta_debito ) as sad09 ON (sad09.id_ger_plano_conta_debito = t0.ID) " +
  27. "LEFT OUTER JOIN ( SELECT COALESCE(SUM(valor),0) as valor, id_ger_plano_conta_credito FROM mcg_lancamento WHERE id_ger_empresa = ? AND dt_lancamento < ? GROUP BY id_ger_plano_conta_credito) as sac09 ON (sac09.id_ger_plano_conta_credito = t0.ID) " +
  28. "LEFT OUTER JOIN ( SELECT COALESCE(SUM(valor),0) as valor, id_ger_plano_conta_debito FROM mcg_lancamento WHERE id_ger_empresa = ? AND dt_lancamento < ? GROUP BY id_ger_plano_conta_debito ) as sad10 ON (sad10.id_ger_plano_conta_debito = t0.ID) " +
  29. "LEFT OUTER JOIN ( SELECT COALESCE(SUM(valor),0) as valor, id_ger_plano_conta_credito FROM mcg_lancamento WHERE id_ger_empresa = ? AND dt_lancamento < ? GROUP BY id_ger_plano_conta_credito) as sac10 ON (sac10.id_ger_plano_conta_credito = t0.ID) " +
  30. "LEFT OUTER JOIN ( SELECT COALESCE(SUM(valor),0) as valor, id_ger_plano_conta_debito FROM mcg_lancamento WHERE id_ger_empresa = ? AND dt_lancamento < ? GROUP BY id_ger_plano_conta_debito ) as sad11 ON (sad11.id_ger_plano_conta_debito = t0.ID) " +
  31. "LEFT OUTER JOIN ( SELECT COALESCE(SUM(valor),0) as valor, id_ger_plano_conta_credito FROM mcg_lancamento WHERE id_ger_empresa = ? AND dt_lancamento < ? GROUP BY id_ger_plano_conta_credito) as sac11 ON (sac11.id_ger_plano_conta_credito = t0.ID) " +
  32. "LEFT OUTER JOIN ( SELECT COALESCE(SUM(valor),0) as valor, id_ger_plano_conta_debito FROM mcg_lancamento WHERE id_ger_empresa = ? AND dt_lancamento < ? GROUP BY id_ger_plano_conta_debito ) as sad12 ON (sad12.id_ger_plano_conta_debito = t0.ID) " +
  33. "LEFT OUTER JOIN ( SELECT COALESCE(SUM(valor),0) as valor, id_ger_plano_conta_credito FROM mcg_lancamento WHERE id_ger_empresa = ? AND dt_lancamento < ? GROUP BY id_ger_plano_conta_credito) as sac12 ON (sac12.id_ger_plano_conta_credito = t0.ID) " +
  34. "WHERE t0.id_ger_grupo_plano_conta = ? AND t0.dt_inclusao_alteracao_sped <= ? ORDER BY t0.conta "
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!