JG Global Journals and Third Party

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Application: Regional Localizations
Source: Global Journals and Third Party Report
Short Name: JGSLAJNLTP
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 Name SQL text Validation
Ledger 
 
 LOV Oracle
Legal Entity 
 
 LOV Oracle
Journal Entry Source 
 
 LOV Oracle
Show Adjustment Periods 
 
 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
Process Category 
 
 LOV Oracle
Event Class 
 
 LOV Oracle
Document Sequence Name 
 
 LOV Oracle
Accounting Sequence Name 
 
 LOV Oracle
Posting Status 
 
 LOV Oracle
Accounting Period Type 
 
 LOV Oracle
Include Year to Date Carried Forward 
 
 LOV Oracle
Journal Entry Status 
 
 LOV Oracle
Reporting Sequence Name 
 
 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
Fourth Report Sort 
 
 LOV Oracle
Fifth Report Sort 
 
 LOV Oracle
Sixth Report Sort 
 
 LOV Oracle
Seventh Report Sort 
 
 LOV Oracle
Created by User Name 
 
 Char
Group by Period 
 
 LOV Oracle
Batch Name 
 
 Char
Accounting Sequence Number From 
 
 Char
Accounting Sequence Number To 
 
 Char
Document Sequence Number From 
 
 Char
Document Sequence Number To 
 
 Char
Creation Date From 
 
 Char
Creation Date To 
 
 Char
Entered Currency 
 
 LOV Oracle
Download
Related Blitz Reports
COPY OF: AP Payables Posted Payment Register (old to replicate scheduling issue) XLA Account Analysis JG Global Subledger Detail Journal 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 JE French Accounting Entries Audit File
Blitz Report™

Blitz Report™ provides multiple benefits: