Feb 28 2008
Script di Tengah Malam
Whuah… stress ngeliat Diky ngetik-ngetik script ini.. thh pikirku :))
CREATE OR REPLACE VIEW VW_AKTOPR
(KD_PINJ, KD_PELUNASAN, TGL_ANGSURAN, POKOKOPR, BUNGAOPR,
POKOK_AKT, BUNGA_AKT)
AS
select kd_pinj,kd_pelunasan, tgl_angsuran, pokokopr, bungaopr, pokok_akt, bunga_akt from
(
select subl2,no_pointer, sum(nvl(pokok_akt,0))pokok_akt, sum(nvl(bunga_akt,0)) bunga_akt from
(
select b.subl2,no_pointer,null pokok_akt, sum(nvl(kredit,0))- sum(nvl(debet,0)) bunga_akt from gl_ktvouc a,gl_trvouc b
where a.kd_ktr=b.kd_ktr and a.kd_bln=b.kd_bln and a.kd_bank = b.kd_bank and a.tgl_trans=b.tgl_trans
and a.kd_buku=b.kd_buku and a.kd_trans =b.kd_trans
and b.akun like ‘72%’
group by b.subl2,no_pointer
union all
select b.subl2,no_pointer, sum(nvl(kredit,0))- sum(nvl(debet,0))pokok_akt,null bunga_akt from gl_ktvouc a,gl_trvouc b
where a.kd_ktr=b.kd_ktr and a.kd_bln=b.kd_bln and a.kd_bank = b.kd_bank and a.tgl_trans=b.tgl_trans
and a.kd_buku=b.kd_buku and a.kd_trans =b.kd_trans
and b.akun like ‘12%’
group by b.subl2,no_pointer,a.cicilan
)
group by subl2,no_pointer
)a,
(
select kd_pinj,tgl_angsuran,kd_pelunasan ,sum(r_pokok)pokokopr,sum(r_bunga)bungaopr from admin_kbl.glo_pinjaman_acicilan
group by kd_pinj,kd_pelunasan,tgl_angsuran
)b
where
b.kd_pinj = a.subl2(+)
and b.kd_pelunasan=a.no_pointer(+)
/
oleh: Dicky di tengah malam
Tags: script, dicky, oracle, view
Popularity: 8% [?]
Posting yang berhubungan: (otomatis digenerate)
- Beli Buku dari Internet
- Postgresql: How to change column type
- Error of errno - errno’s Error
- Kiat Mengatasi Stress
Powered by FireStats
Waduh, ini apa yah????
Sepertinya kenal tp kho dah lupa yah?
Hehehe… :p
Hahaha Ibu Anas…
serius ni bu udah lupa???
itu kan mantra Bu….
hahaha