GL Account Analysis - (132 Char)

Description
Categories: BI Publisher, Financials
Application: General Ledger
Source: Account Analysis - (132 Char) (XML)
Short Name: GLACTANL_XML
DB package: GL_GLRJED_XMLP_PKG
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
Parameter Name SQL text Validation
Page Size
 
LOV Oracle
Chart of Accounts ID
 
Number
Access Set ID
 
Number
Order By
 
LOV Oracle
Flexfield To
 
Flexfield From
 
Ending Period
 
LOV Oracle
Starting Period
 
LOV Oracle
Budget or Encumbrance Name
 
LOV Oracle
Balance Type
 
LOV Oracle
Type
 
LOV Oracle
Entered Currency
 
LOV Oracle
Currency Type
 
LOV Oracle
Ledger Currency
 
LOV Oracle
Ledger/Ledger Set
 
LOV Oracle