I am currently working on oracle quality module 11i .
Today i have created one collection plan named 'OVERHEAD' and also defined some collection element in that collection plan.
GL Period : SELECT PERIOD_NAME, PERIOD_YEAR FROM GL_PERIODS ORDER BY PERIOD_YEAR ,PERIOD_NUM
Expense account : SELECT CODE_COMBINATION_ID , CONCATENATED_SEGMENTS,GL_ACCOUNT_TYPEFROM GL_CODE_COMBINATIONS_KFV WHERE GL_ACCOUNT_TYPE = 'E'
GL balances : Depending on GL Period and Expense account, How can we achive this ???
I have written sql validation statement for Gl Periods and Expense account.
GL Balances is ultimately dependent on GL Period and expense account.
When user Enters quality result of OVERHEAD collection plan then user is able to see the lov for GL Period and Expense account.
I want to know how can we write sql validation statement for GL balances which is depending on GL Period and Expense account.
Kindly guide me 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