GL Account Analysis - (132 Char)

select  
       l2.name LEDGER_NAME,
       l2.ledger_id LEDGER_ID,
       max(bal.period_name) PERIOD_NAME,
       &SELECT_BEGIN_DR BEGIN_DR,
       &SELECT_BEGIN_CR BEGIN_CR,
       &SELECT_END_DR END_DR,
       &SELECT_END_CR END_CR, 
	GL_GLRJED_XMLP_PKG.begin_balformula(sum ( nvl ( bal.begin_balance_dr , 0 ) ), sum ( nvl ( bal.begin_balance_cr , 0 ) )) BEGIN_BAL, 
	GL_GLRJED_XMLP_PKG.begin_bal_dr_crformula(sum ( nvl ( bal.begin_balance_dr , 0 ) ), sum ( nvl ( bal.begin_balance_cr , 0 ) )) BEGIN_BAL_DR_CR, 
	GL_GLRJED_XMLP_PKG.end_balformula(sum ( nvl ( bal.begin_balance_dr , 0 ) + nvl ( bal.period_net_dr , 0 ) ), sum ( nvl ( bal.begin_balance_cr , 0 ) + nvl ( bal.period_net_cr , 0 ) )) END_BAL, 
	GL_GLRJED_XMLP_PKG.end_bal_dr_crformula(sum ( nvl ( bal.begin_balance_dr , 0 ) + nvl ( bal.period_net_dr , 0 ) ), sum ( nvl ( bal.begin_balance_cr , 0 ) + nvl ( bal.period_net_cr , 0 ) )) END_BAL_DR_CR
FROM  gl_ledgers l,
            gl_ledger_set_assignments ls,
            gl_ledgers l2,
            gl_period_statuses per,
            gl_code_combinations cc,
            gl_balances bal
WHERE &WHERE_FLEX 
AND   cc.chart_of_accounts_id = :STRUCT_NUM
AND   l.ledger_id = :P_LEDGER_ID
AND   ls.ledger_set_id (+) = l.ledger_id
AND   l2.ledger_id = nvl(ls.ledger_id, l.ledger_id)
AND   l2.currency_code = :P_LEDGER_CURRENCY
&WHERE_DAS_BAL
AND   per.application_id = 101
AND   per.ledger_id = l2.ledger_id
AND   per.effective_period_num 
              BETWEEN :START_EFFECTIVE_PERIOD_NUM
              AND :END_EFFECTIVE_PERIOD_NUM
AND   bal.code_combination_id = cc.code_combination_id
AND   bal.period_name = per.period_name 
AND   bal.actual_flag = :P_ACTUAL_FLAG
AND   &WHERE_ACTUAL_TYPE
AND   bal.currency_code = :RESULTING_CURRENCY
AND   &WHERE_CURRENCY_BAL
AND   bal.ledger_id = l2.ledger_id
AND   bal.template_id is null
&SECURITY_FILTER_STR
GROUP BY l2.name, l2.ledger_id, per.period_year, per.period_num
ORDER BY l2.name, per.period_year, per.period_num