XLA Account Analysis

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Standard Account Analysis Report
Application: Subledger Accounting
Source: Account Analysis Report
Short Name: XLAAARPT
DB package: XLA_ACCT_ANALYSIS_RPT_PKG
  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
Parameter NameSQL textValidation
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
Download
Related Blitz Reports
JE Italian Journal Ledger APL: AP Posted Invoice Register AP Posted Invoice Register(GST) JG Global Subledger Detail Journal JG Global Journals and Third Party JG Global Journal Ledger JG Global Daily Journals JG Global GL and SLA Account by Journal Lines JG Global GL and SLA Account Analysis
Blitz Report™