SELECT --c.nu_cnpj,
d.ted_rge_ruc, d.ted_per_refere, t.*
FROM usr_sat_ctacte.tab_efectuar_dec d
join USR_SAT_CTACTE.TAB_DEC_QDR_ITEM t
ON t.tdqi_ted_nro_dec = d.ted_nro_dec
--join usr_sat_ods.cad_contrib_ccicms c
--on c.nu_ie = trim(d.ted_rge_ruc)
WHERE d.ted_estado = 'A'
AND d.ted_per_refere = 201901
AND t. TDQI_ITEM IN (4010,5020)
AND (d.ted_rge_ruc=250092670
OR d.ted_rge_ruc=257266968
OR d.ted_rge_ruc=251260950
 OR d.ted_rge_ruc=253720362
    OR d.ted_rge_ruc=253646537) ;