XLA Account Analysis

Description
Categories: BI Publisher
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 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
 
Account Flexfield To
 
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
XLA_SRS_SUBLEDGERS
 
LOV Oracle
P_LEDGER
 
P_COA_ID
 
LOV Oracle
P_LEGAL_ENTITY
 
GL Date From
 
Date
GL Date To
 
Date
P_JE_SOURCE_NAME
 
P_BALANCE_TYPE
 
XLA_SRS_NO_VALIDATION
 
P_BUDGET_NAME
 
XLA_SRS_NO_VALIDATION
 
P_ENCUMBRANCE_TYPE
 
P_BALANCE_SIDE
 
P_INCLUDE_ZERO_AMT_LINES
 
P_INCLUDE_USER_TRX_ID
 
Inclue Tax Details
 
LOV Oracle
P_INCLUDE_TAX_DETAILS
 
Include Legal Entity Informations
 
LOV Oracle
P_INCLUDE_LEGAL_ENTITY
 
P_INCLUDE_STAT_AMT_LINES
 
P_INC_ACCT_WITH_NO_ACT
 
Enable Scalable Flag
 
LOV Oracle