JG Global GL and SLA Account by Journal Lines

Description
Categories: BI Publisher
Imported from BI Publisher
Application: Regional Localizations
Source: Global GL and SLA Account by Journal Lines Report
Short Name: JGSLAAJNL
DB package: XLA_JELINES_RPT_PKG

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

          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
Entered Currency
 
LOV Oracle
Accounting Flexfield From
 
Char
Accounting Flexfield To
 
Char
Period From
 
LOV Oracle
Period To
 
LOV Oracle
GL Date From
 
Date
GL Date To
 
Date
Accounting Sequence Name
 
LOV Oracle
GL Batch Name
 
Char
Posting Status
 
LOV Oracle
Journal Entry Status
 
LOV Oracle
Third Party Type
 
LOV Oracle
Third Party Name
 
LOV Oracle
Third Party Number From
 
LOV Oracle
Third Party Number To
 
LOV Oracle
Journal Category
 
LOV Oracle