JG Global GL and SLA Account Analysis

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Application: Regional Localizations
Source: Global GL and SLA Account Analysis Report
Short Name: JGSLAAAR
DB package: XLA_ACCT_ANALYSIS_RPT_PKG
Run JG Global GL and SLA 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 
 
 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 
 
 Char
Accounting Flexfield To 
 
 Char
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 
 
 Char
First Page Number 
 
 Number
Assign Zero Beginning Balances 
 
 LOV Oracle
Include Statistical Amount Lines 
 
 LOV Oracle
Include Accounts With No Activity 
 
 LOV Oracle
Download
Related Blitz Reports
COPY OF: AP Payables Posted Payment Register (old to replicate scheduling issue) XLA Journal Entries XLA Account Analysis 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 JE Italian Journal Ledger
Blitz Report™

Blitz Report™ provides multiple benefits: