Please enable JavaScript.
Coggle requires JavaScript to display documents.
"AP_FIN"."FACT_DEPO_V" (ap_fin.fact_deposit_t left…
"AP_FIN"."FACT_DEPO_V"
ap_fin.fact_deposit_t
left join ap_fin.t_ev_dep_cube_mob_period
insert from
ap_fin.t_pk_depo_filtered_dwh d
owner_dwh.cl_term_deposit_period
ap_fin.t_ev_depo_cube_cptl
owner_dwh.dc_salesroom
owner_dwh.dc_gl_account
ap_fin.f_realized_transaction_tt
Review MOB (month of period). Период жизни продукта работает некорректно, исправить, чтобы работал по аналогии как в карточном кубе.
ap_fin.t_ev_dep_cube_mob_period
ap_fin.fact_deposit_t
Данные в таблице
ID_DEPOSIT NUMBER
ID_SALESROOM NUMBER
RATE_INTEREST FLOAT
ID_TRANSACTION NUMBER
GL1 VARCHAR2
GL2 VARCHAR2
DATE_TRANSACTION DATE
ID_TRANSACTION_TYPE NUMBER
AMT_ADDITION FLOAT
AMT_WITHDRAWAL FLOAT
AMT_CAPIT FLOAT
AMT_INTEREST FLOAT
AMT_ADDITION_KZT FLOAT
AMT_WITHDRAWAL_KZT FLOAT
AMT_CAPIT_KZT FLOAT
AMT_INTEREST_KZT FLOAT
ID_ACCOUNT_BANK NUMBER
ID_EMPLOYEE NUMBER
DATE_OPEN DATE
DATE_CLOSE DATE
DATE_FIRST_ADD DATE
DATE_OPEN_KEY NUMBER
DATE_CLOSE_KEY NUMBER
DATE_FIRST_ADD_KEY NUMBER
DATE_TRANSACTION_KEY NUMBER
ID_DEPO_STATUS NUMBER
ID_CURRENCY NUMBER
ID_CHANNEL NUMBER
ID_DEPO_TYPE NUMBER
ID_PRODUCT NUMBER
ID_FLAG_CAPIT NUMBER
ID_DEPO_PERIOD VARCHAR2
ap_fin.t_pk_depo_filtered_dwh
ap_fin.t_pk_depo_filtered_pre
owner_dwh.f_term_deposit_ad dep
LEFT JOIN ap_fin.t_ev_depo_acc_gl acc
ON acc.skp_account_bank = dep.skp_account_bank
LEFT JOIN ap_fin.t_depo_exchange_emp ex
ON ex.skp_term_deposit = dep.skp_term_deposit
AND dep.dtime_valid_from BETWEEN ex.date_from AND
nvl(ex.date_to, trunc(SYSDATE))
LEFT JOIN empo emb
ON emb.skp_employee_bank = dep.skp_employee_bank_inserted
LEFT JOIN ap_fin.t_ev_depo_filt_obs_cln cln
ON cln.skp_client = dep.skp_client_bank
LEFT JOIN owner_dwh.cl_currency_obs cur
ON cur.skp_currency_obs = dep.skp_currency_obs
LEFT JOIN ap_fin.t_ev_depo_filt_ufo_req ufo
ON ufo.param_value = substr(dep.text_term_deposit_number, 1, 10)
LEFT JOIN ap_fin.t_ev_depo_filt_ufo_contr ufo1
ON ufo1.text_term_deposit_number = dep.text_term_deposit_number
LEFT JOIN ap_fin.t_deposit_without_tt aps
ON aps.skp_term_deposit = dep.skp_term_deposit
LEFT JOIN owner_dwh.dc_product_bank pr
ON pr.skp_product_bank = dep.skp_product_bank
AND pr.flag_deleted = 'N'
LEFT JOIN ap_fin.t_ev_depo_filt_hs_emp emph
ON emph.code_employee = TRIM(ufo.code_homer)
LEFT JOIN ap_fin.t_employee_move mov
ON regexp_substr(TRIM(mov.iin), '[0-9]{12}') =
regexp_substr(nvl(emb.iin, emph.text_ident_doc_number),
'[0-9]{12}')
AND dep.dtime_valid_from BETWEEN mov.dt_b AND mov.dt_e
LEFT JOIN hcode
-- VEm 01-08-2017
ON regexp_substr(upper(hcode.text_ident_doc_number), '[0-9]{12}') =
regexp_substr(nvl(TRIM(emb.iin),
TRIM(emph.text_ident_doc_number)),
'[0-9]{12}')
AND hcode.code_status = 'a'
LEFT JOIN ap_fin.t_premium_clients prem
ON lower(TRIM(prem.code)) = lower(TRIM(mov.code_stp))
LEFT JOIN ctt
ON ctt.skp_term_deposit = dep.skp_term_deposit
LEFT JOIN ap_fin.t_depo_first_last_date_dwh fld
ON fld.skp_term_deposit = dep.skp_term_deposit
LEFT JOIN owner_dwh.f_currency_rate_td ra
ON ra.skp_currency_obs_source = dep.skp_currency_obs
AND dep.dtime_valid_from + 1 BETWEEN ra.dtime_rate_valid_from AND
ra.dtime_rate_valid_to
AND ra.skp_currency_rate_status = 4
LEFT JOIN owner_dwh.cl_term_deposit_status ds
ON ds.skp_term_deposit_status = dep.skp_term_deposit_status
LEFT JOIN owner_dwh.cl_bank_account_analytic_att att
ON att.skp_bank_account_analytic_att =
acc.skp_bank_account_analytic_att