XLA Account Analysis
Description
- Categories
- BI Publisher
- Application
- Subledger Accounting
- Source
- Account Analysis Report
- Short Name
- XLAAARPT
- DB package
- XLA_ACCT_ANALYSIS_RPT_PKG
Imported from BI Publisher
Standard Account Analysis Report
Standard Account Analysis Report
SQL 45 lines
SELECT &p_main_col_start &p_main_lgr_sgmt_col &p_main_le_col &p_je_source_period &p_main_col_end FROM ( &p_sla_col_start &p_party_columns &p_trx_identifiers_1 &p_trx_identifiers_2 &p_trx_identifiers_3 &p_trx_identifiers_4 &p_trx_identifiers_5 &p_gt_lgr_sgmt_col &p_gt_le_col &p_sla_col_end &p_sla_from WHERE &p_ledger_filters &p_sla_main_filter &p_sla_other_filter &p_sla_application_id_filter &p_union_all &p_gl_col_start &p_gt_lgr_sgmt_col &p_gt_le_col &p_gl_col_end &p_gl_from &p_gl_main_filter &p_gl_other_filter &p_gl_application_id_filter &p_union_all &p_gl_col_start &p_gt_lgr_sgmt_col &p_gt_le_col &p_gl_col_end &p_upg_gl_from &p_upg_gl_main_filter &p_gl_other_filter &p_gl_application_id_filter &p_begin_balance_union_all )TABLE1 WHERE :L_RUN_LONG_REPORT = 'Y' &p_order_by_clause |
Parameters 13
| Parameter | Type | List of values SQL |
|---|---|---|
| Ledger/Ledger Set | LOV Oracle | |
| Period From | LOV Oracle | |
| Period To | LOV Oracle | |
| Balance Type | LOV Oracle | |
| Budget Name | LOV Oracle | |
| Encumbrance Type | LOV Oracle | |
| Account Flexfield From | Char | |
| Account Flexfield To | Char | |
| Include Zero Amount Lines | LOV Oracle | |
| Include User Transaction Identifiers | LOV Oracle | |
| Include Statistical Amount Lines | LOV Oracle | |
| Include Accounts With No Activity | LOV Oracle | |
| Enable Long Report | LOV Oracle |