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
  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
 
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
 
Accounting Flexfield To
 
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
 
First Page Number
 
Number
Assign Zero Beginning Balances
 
LOV Oracle
Include Statistical Amount Lines
 
LOV Oracle
Include Accounts With No Activity
 
LOV Oracle
P_RESP_APPLICATION_ID
 
P_LEDGER
 
P_LEGAL_ENTITY
 
P_COA_ID
 
LOV Oracle
P_BALANCE_TYPE_CODE
 
LOV Oracle
P_INCLUDE_TAX_DETAILS
 
P_INCLUDE_LEGAL_ENTITY
 
P_CUSTOM_PARAMETER_12
 
P_CUSTOM_PARAMETER_13
 
P_CUSTOM_PARAMETER_14
 
P_INCLUDE_STAT_AMT_LINES
 
P_CUSTOM_PARAMETER_16
 
P_CUSTOM_PARAMETER_17
 
P_CUSTOM_PARAMETER_18
 
P_INC_ACCT_WITH_NO_ACT