SELECT brt.realizationdate,
 CASE interface_type
   WHEN 'APP_CNP' THEN
    'LH'
   ELSE
    'CNP'
 END channel,
 CASE ticc.type_
   WHEN 1 THEN
    'LOAN'
   WHEN 2 THEN
    'DEPOSIT'
   WHEN 3 THEN
    'CARD'
 END target,
 brt.amount,
 tiu.phone_number,
 tiu.cuid,
 tba.prod_dispatch_note_num
  FROM ap_it.t_ib_tbl_ib_card_cnp_transfer ticc
  JOIN ap_it.t_ib_tbl_ib_bank_account tba
    ON tba.id = ticc.target_acc_id
  JOIN owner_int.vh_obs_bc_realizedtransaction brt
    ON brt.idrequiredtransaction = ticc.cbs_req_tran_id
  JOIN owner_int.vh_obs_bc_bankaccount bba
    ON bba.idbankaccount = brt.idbankaccountcredit
  JOIN owner_int.vh_obs_bc_person bpe
    ON bpe.idperson = bba.idperson
  JOIN ap_it.t_ib_tbl_ib_user tiu
    ON tiu.cuid = bpe.personextid;

select count(1) from ap_it.t_ib_tbl_ib_card_cnp_transfer t; -- 89 333
select count(1) from ap_it.t_ib_tbl_ib_bank_account t; -- 97 458
select count(1) from owner_int.vh_obs_bc_realizedtransaction t; -- 1 423 789 583
select count(1) from owner_int.vh_obs_bc_bankaccount t;  -- 86 080 300
select count(1) from owner_int.vh_obs_bc_person t; -- 4 670 722
select count(1) from ap_it.t_ib_tbl_ib_user t; -- 3 902 449