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 = 201905
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) ;