Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- query.append("SELECT com.oki.siac.xcash.entities.tesouraria.SuprimentoTO( s.dtHrInclusao,");
- query.append("s.valorSolicitado,");
- query.append("(SELECT SUM(mc.valorMalote) FROM MaloteColeta mc WHERE mc.idSuprimento = s.idSuprimento),");
- query.append("(SELECT c.numGTV FROM Coleta c MaloteColeta mc WHERE s.idSuprimento = mc.idSuprimento AND mc.idColeta = c.idColeta),");
- query.append("s.codStatusSuprimento) FROM Suprimento s WHERE s.dtHrInclusao BETWEEN :dataInicial AND :dataFinal");
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement