select /*+ index(sys_C007096 acnt)*/
acnt.acntcode,
acnt.acntname,
decode(acnt.remainderpos,'D',befo.dbsum - befo.crsum,befo.crsum - befo.dbsum) befrem,
decode(acnt.remainderpos,'D',daily.dbsum - daily.crsum,daily.crsum - daily.dbsum) dayrem,
acnt.remainderpos
from a_code_acnt acnt,
(select acntcode,
sum(dbamt) dbsum,
sum(cramt) crsum
from a_slip_main
where account_date < '2011.08.23'
and account_date <> to_date('1900.01.01')
and slipcomp = '11'
and acntcode in ('1110100','1110300','1110501','1110588','1111101')
group by acntcode) befo,
(select acntcode,
sum(dbamt) dbsum,
sum(cramt) crsum
from a_slip_main
where account_date = '2011.08.23'
and account_date <> to_date('1900.01.01')
and slipcomp = '11'
and acntcode in ('1110100','1110300','1110501','1110588','1111101')
group by acntcode) daily
where acnt.acntcode = befo.acntcode(+)
and acnt.acntcode = daily.acntcode(+)
and acnt.acntcode in ('1110100','1110300','1110501','1110588','1111101') |