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
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 |