Please enable JavaScript.

Coggle requires JavaScript to display documents.

d$loan_details_analyt$p5 - Coggle Diagram

- - - - l_rep_date + i as date_vnb,
      - ss.f_get_dwh_id(2, o.rbo_contract_id, 1) as DWH_ID,
      - sum(o.saldo) saldo,
      - l_rep_date + i
        
        from F$LOAN_OPER$B o
      - where td_id in (
        
        select td.id
        
        from s02.Z#VID_DEBT vd
        
        join s02.Z#TAKE_IN_DEBT td
        
        on vd.id = td.c_debt
        
        where vd.id in (
        
        9953231420,
        
        9953231422,
        
        9953231424,
        
        9953231426,
        
        9953231428,
        
        9953231430,
        
        9953231432,
        
        9953231434,
        
        9953231436
        
        )
        
        )
        
        and c_doc_date = l_rep_date + i
      - group by ss.f_get_dwh_id(2, o.rbo_contract_id, 1);