I’ve 3 categories to show data from loan master,
1. Date opening loan range 3 until 5 years
2. Date opening loan range 5 until 10 years
3. Date opening loan > 10 years
This is the script to show all data:
select 'PRODUK 604 range 3 s/d 5 tahun' KATEGORI, kd_kntr, kd_produk, kd_sub_produk, kd_val,no_rek, nm_nas, sld_akhir, sisa_bunga, tgl_akad_kredit
from ln_master
where kd_produk=6 and kd_sub_produk=4 and kd_val=0 and tgl_akad_kredit < trunc(add_months(sysdate,-(3*12))) and tgl_akad_kredit =trunc(add_months(sysdate,-(5*12)))
union
select 'PRODUK 604 range 5 s/d 10 tahun' KATEGORI, kd_kntr, kd_produk, kd_sub_produk, kd_val,no_rek, nm_nas, sld_akhir, sisa_bunga, tgl_akad_kredit
from ln_master
where kd_produk=6 and kd_sub_produk=4 and kd_val=0 and tgl_akad_kredit < trunc(add_months(sysdate,-(5*12))) and tgl_akad_kredit =trunc(add_months(sysdate,-(10*12)))
union
select 'PRODUK 604 range > 10 tahun' KATEGORI, kd_kntr, kd_produk, kd_sub_produk, kd_val, no_rek, nm_nas, sld_akhir, sisa_bunga, tgl_akad_kredit
from ln_master
where kd_produk=6 and kd_sub_produk=4 and kd_val=0
and tgl_akad_kredit < trunc(add_months(sysdate,-(10*12)));