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

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

  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
Download
 
Related Blitz Reports
COPY OF: AP Payables Posted Payment Register (old to replicate scheduling issue) XLA Journal Entries 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 JE Italian Journal Ledger
Blitz Report™

Blitz Report™ provides multiple benefits: