This content has been marked as final. Show 4 replies
Apologize for same thread.
If you give me any help on this question i would really appreciate.
If anyone has implemented this solution before, pls share it..
Or else give me any workaround or document for the same
After Making lot of R & D i have found out a solution which i m sharing with you all.
Just look into in below query.
select sum(PERIOD_NET_DR) , PERIOD_NAME
from gl_balances gl
where gl.PERIOD_NAME = :q_res.display5
and gl.CODE_COMBINATION_ID = :q_res.display3
group by PERIOD_NAME