JG Global GL and SLA Account Analysis
Description
- Categories
- BI Publisher
- Application
- Regional Localizations
- Source
- Global GL and SLA Account Analysis Report
- Short Name
- JGSLAAAR
- DB package
- XLA_ACCT_ANALYSIS_RPT_PKG
Imported from BI Publisher
SQL 46 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 22
| Parameter | Type | List of values SQL |
|---|---|---|
| Ledger | LOV Oracle | |
| Legal Entity | LOV Oracle | |
| Period From | LOV Oracle | |
| Period To | LOV Oracle | |
| GL Date From | Date | |
| GL Date To | Date | |
| Accounting Flexfield From | Char | |
| Accounting Flexfield To | Char | |
| Display VAT Code | LOV Oracle | |
| Document Sequence Name | LOV Oracle | |
| Include Legal Entity Information | LOV Oracle | |
| First Flexfield Segment Used | LOV Oracle | |
| Second Flexfield Segment Used | LOV Oracle | |
| Third Flexfield Segment Used | LOV Oracle | |
| First Report Sort | LOV Oracle | |
| Second Report Sort | LOV Oracle | |
| Third Report Sort | LOV Oracle | |
| Report Sequence Number | Char | |
| First Page Number | Number | |
| Assign Zero Beginning Balances | LOV Oracle | |
| Include Statistical Amount Lines | LOV Oracle | |
| Include Accounts With No Activity | LOV Oracle |