XLA Account Analysis

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
Run XLA Account Analysis and other Oracle EBS reports with Blitz Report™ on our demo environment
  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 Name SQL text Validation
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