fdw_inm_dash_sample.sql 310 Bytes
-- MUESTRA DE FORMATOS CON GUIONES (Solo 'INM')
SELECT 
    'INM - CON GUIONES' as categoria,
    inm_ctacatastral,
    REPLACE(inm_ctacatastral, '-', '') as limpia,
    inm_ficha,
    trb_total_deuda
FROM fdw_505.v_liq_entidad_totalxobjeto 
WHERE trb_tributo = 'INM' AND inm_ctacatastral LIKE '%-%'
LIMIT 10;
GitLab Appliance - Powered by TurnKey Linux