JG Global Journals and Third Party

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
Run JG Global Journals and Third Party and other Oracle EBS reports with Blitz Report™ on our demo environment
          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
Blitz Report™