Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.
create or replace view all_acc_bal as with p as ( select 2013 yr , 12 mn from dual ) select code_trans, -op_deb op_deb, -tr_deb tr_deb, -t_deb t_deb, -op_cr op_cr, -tr_cr tr_cr, -t_cr t_cr, -Bal bal, 'Alpha' Syst FROM h2002_acc_bal t join p on t.year = p.yr and t.period_no= p.mn union all select acc_no, op_deb, tr_deb , op_deb+ tr_deb t_deb , op_cr , tr_cr , op_cr+ tr_cr t_cr, (op_deb+tr_deb)-(op_cr+tr_cr) Bal , 'Intacc' FROM acc_bal f join p on f.year = p.yr and f.period_no= p.mn;
select code_trans , acct_type(code_trans), get_acc_name(code_trans) Acc_Name,sum(bal) Diff from all_acc_bal group by code_trans having sum(bal) > = 1 or sum(bal) < = -1 and code_trans not in('15000','15120','15550','20000','50000','11000') order by sum(bal) desc;
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.