GL Account Analysis - (180 Char)

Description
Categories: BI Publisher
Imported from BI Publisher
Description: Account Analysis Report
Application: General Ledger
Source: Account Analysis - (180 Char) (XML)
Short Name: GLACTANL2_XML
DB package: GL_GLRJED_XMLP_PKG
Run GL Account Analysis - (180 Char) and other Oracle EBS reports with Blitz Report™ on our demo environment
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
Ledger/Ledger Set
 
LOV Oracle
Ledger Currency
 
LOV Oracle
Currency Type
 
LOV Oracle
Entered Currency
 
LOV Oracle
Type
 
LOV Oracle
Balance Type
 
LOV Oracle
Budget or Encumbrance Name
 
LOV Oracle
Starting Period
 
LOV Oracle
Ending Period
 
LOV Oracle
Flexfield From
 
Char
Flexfield To
 
Char
Order By
 
LOV Oracle
Blitz Report™