Oracle SQL, PLSQL, APEX How To's by Dr. S. Raghunathan - HTML preview

sum(nvl(credit,0)) from raak_trans_Detail where raak_trans_detail.ledger_name = balance_sheet.ledger_name);

update balance_sheet set asset = (select sum(nvl(debit,0))

from raak_trans_detail

where raak_trans_detail.ledger_name =

balance_sheet.ledger_name);

update balance_sheet set liability = (liability - asset), asset= null where liability > nvl(asset,0);

update balance_sheet set asset = (asset - liability), liability = null where asset > nvl(liability,0); select sum(asset) - sum(liability) into pl from balance_sheet;

if pl > 0 then

update balance_sheet set liability = pl where ledger_name like 'ACCUMULATED PROFIT';

else

update balance_sheet set ASSET = pl*-1 where ledger_name like 'ACCUMULATED LOSS';

end if;

delete from balance_sheet where nvl(liability,0) = 0 and nvl(asset,0) = 0;

delete from profit_loss;

insert into profit_loss (ledger_name) select ledger_name from raak_ledger_master

where report_type='PL';

update profit_loss set income = (select sum(nvl(credit,0))

from raak_trans_detail

where raak_trans_detail.ledger_name =

profit_loss.ledger_name);