DROP VIEW IF EXISTS public.vw_lotes_morosidad_703;
CREATE OR REPLACE VIEW public.vw_lotes_morosidad_703 AS 
SELECT 
    lot.*, 
    liq.inm_ficha, 
    liq.inm_ctacatastral, 
    liq.trb_total_deuda, 
    liq.trb_total_pago, 
    liq.ultimo_pago 
FROM public.e703_lotes_activos lot
LEFT JOIN fdw_703.v_liq_entidad_totalxobjeto liq ON lot.snc_cuenta = REPLACE(liq.inm_ctacatastral, '-', '');