Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT c.efd_cod_cnpj "CNPJ_Declarante", c.efd_dt_refer "PA", re110.vl_total_debitos, re110.vl_total_creditos, re110.*
- FROM usr_sat_sped.efd_controle c
- join usr_sat_sped.efd_re110_apuracao_icms re110
- ON c.efd_nro_arquivo=re110.id_arquivo
- WHERE NVL(c.efd_sit_substituto_novo,0) = 1 --Situacao do aquivo quando a substituicao: 1- Ativo, 2- Substituido.
- AND c.efd_dt_refer = 201901;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement