Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT xxx.*,
- orcreceita.o70_codigo
- FROM (SELECT k12_conta,
- k02_codrec,
- arrecada AS arrecada,
- estorna AS estorna,
- cgm_pago,
- cgm_estornado,
- cgm_recibo_avulso,
- k12_codcla,
- k12_histcor,
- k12_id,
- k12_autent,
- k12_numpre,
- k12_numpar
- FROM (SELECT k12_conta,
- k02_codrec,
- k12_histcor,
- (SELECT k00_numcgm
- FROM arrepaga
- WHERE k00_numpre = x.k12_numpre
- AND k00_numpar = x.k12_numpar
- LIMIT 1) AS cgm_pago,
- (SELECT k00_numcgm
- FROM arrecad
- WHERE k00_numpre = x.k12_numpre
- AND k00_numpar = x.k12_numpar
- LIMIT 1) AS cgm_estornado,
- (SELECT k00_numcgm
- FROM recibo
- WHERE k00_numpre = x.k12_numnov
- LIMIT 1) AS cgm_recibo_avulso,
- (SELECT k12_codcla
- FROM corcla
- WHERE k12_id = 14
- AND k12_data = '2016-07-01'
- AND k12_autent = 1
- LIMIT 1) AS k12_codcla,
- arrecada,
- estorna,
- k12_id,
- k12_autent,
- k12_numpre,
- k12_numpar
- FROM (SELECT corrente.k12_id,
- corrente.k12_autent,
- k12_conta,
- k02_codrec,
- Round (CASE
- WHEN corrente.k12_estorn = false THEN
- cornump.k12_valor
- ELSE 0 :: FLOAT8
- end, 2) AS arrecada,
- Round (CASE
- WHEN corrente.k12_estorn = true THEN
- cornump.k12_valor
- ELSE 0 :: FLOAT8
- end, 2) AS estorna,
- k12_histcor,
- cornump.k12_numnov,
- cornump.k12_numpre,
- cornump.k12_numpar
- FROM corrente
- INNER JOIN cornump
- ON corrente.k12_id = cornump.k12_id
- AND corrente.k12_data =
- cornump.k12_data
- AND corrente.k12_autent =
- cornump.k12_autent
- LEFT JOIN corhist
- ON corrente.k12_id = corhist.k12_id
- AND corrente.k12_data =
- corhist.k12_data
- AND corrente.k12_autent =
- corhist.k12_autent
- INNER JOIN tabrec
- ON k12_receit = tabrec.k02_codigo
- INNER JOIN taborc
- ON taborc.k02_codigo = tabrec.k02_codigo
- AND taborc.k02_anousu = 2016
- INNER JOIN orcreceita
- ON orcreceita.o70_codrec =
- taborc.k02_codrec
- AND orcreceita.o70_anousu =
- taborc.k02_anousu
- INNER JOIN orcfontes
- ON orcfontes.o57_codfon =
- orcreceita.o70_codfon
- AND orcfontes.o57_anousu =
- orcreceita.o70_anousu
- INNER JOIN conplanoorcamento
- ON conplanoorcamento.c60_codcon =
- orcfontes.o57_codfon
- AND conplanoorcamento.c60_anousu =
- orcfontes.o57_anousu
- INNER JOIN conplanoconplanoorcamento
- ON
- conplanoconplanoorcamento.c72_conplanoorcamento =
- conplanoorcamento.c60_codcon
- AND conplanoconplanoorcamento.c72_anousu =
- conplanoorcamento.c60_anousu
- INNER JOIN conplano
- ON conplano.c60_codcon =
- conplanoconplanoorcamento.c72_conplano
- AND conplano.c60_anousu =
- conplanoconplanoorcamento.c72_anousu
- INNER JOIN conplanoreduz
- ON conplano.c60_codcon =
- conplanoreduz.c61_codcon
- AND conplano.c60_anousu =
- conplanoreduz.c61_anousu
- INNER JOIN conplanoexe
- ON conplanoreduz.c61_reduz = c62_reduz
- AND c62_anousu = conplanoreduz.c61_anousu
- WHERE corrente.k12_id = 14
- AND corrente.k12_data = '2016-07-01'
- AND corrente.k12_autent = 1
- AND taborc.k02_anousu = 2016
- AND conplanoreduz.c61_instit = 1) AS x) AS xx) AS xxx
- INNER JOIN orcreceita
- ON o70_anousu = 2016
- AND o70_codrec = k02_codrec
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement