JG Global Journal Ledger

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Application: Regional Localizations
Source: Global Journal Ledger Report
Short Name: JGSLAJNLLG
DB package: XLA_JELINES_RPT_PKG
          SELECT
              &p_main_col_start
	      &p_party_details_col
	      &p_segment_col
              &p_uti_col
              &p_le_col
              &p_main_col_end
          FROM
              (&p_sla_col_1
               &p_gl_columns
               &p_sla_col_2
               &p_party_details
               &p_sla_qualifier_segment
               &p_sla_col_3
               &p_trx_identifiers_1
               &p_trx_identifiers_2   
               &p_trx_identifiers_3   
               &p_trx_identifiers_4   
               &p_trx_identifiers_5 
               &p_sla_legal_ent_col
               &p_sla_from
               &p_sla_seg_desc_from
               &p_gl_view
               &p_sla_legal_ent_from
               &p_party_from
               &p_sla_join
               &p_sla_seg_desc_join
               &p_other_param_filter
               &p_gl_join
               &p_sla_legal_ent_join
               &p_party_join
               &p_union_all
               &p_gl_col_1
               &p_gl_party_details
               &p_gl_qualifier_segment
               &p_gl_col_2
               &p_gl_legal_ent_col
               &p_gl_from
               &p_gl_seg_desc_from
               &p_gl_legal_ent_from
               &p_gl_where
               &p_gl_seg_desc_join
	       &p_gl_legal_ent_join
	       &p_other_union) TABLE1
	       &p_le_from
	       &p_other_from
          WHERE
               1 = 1
                and :L_RUN_SHORT_REPORT = 'Y'
               &p_trx_id_filter
	       &p_le_join
	       &p_other_join
	       &p_order_by_clause
Parameter NameSQL textValidation
Ledger
 
LOV Oracle
Legal Entity
 
LOV Oracle
Journal Entry Source
 
LOV Oracle
Accounting Flexfield From
 
Char
Accounting Flexfield To
 
Char
Show Adjustment Periods
 
LOV Oracle
Period From
 
LOV Oracle
Period To
 
LOV Oracle
Posting Status
 
LOV Oracle
Accounting Period Type
 
LOV Oracle
Include Legal Entity Information
 
LOV Oracle
Include Year to Date Carried Forward
 
LOV Oracle
Document Sequence Name
 
LOV Oracle
Balance Type
 
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
Show Running Totals
 
LOV Oracle
First Page Number
 
Number
Summarize by Account
 
LOV Oracle
Audit Information Required
 
LOV Oracle
Include Zero Amount
 
LOV Oracle
Download
Related Blitz Reports
JE French Accounting Entries Audit File AP Posted Invoice Register(GST) XLA Account Analysis JG Global Subledger Detail Journal JG Global Journals and Third Party 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™