JE Italian Journal Ledger

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Application: European Localizations
Source: Italian Journal Ledger Report
Short Name: JEITJNLLG
DB package: JE_IT_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
	      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
          WHERE
               1 = 1
              &p_trx_id_filter
	       &p_le_join
	       &p_groupby_clause
		  ORDER BY  &P_CUSTOM_PARAMETER_4,
		   &P_CUSTOM_PARAMETER_5,
		   &P_CUSTOM_PARAMETER_6
		   &p_orderby_clause
Parameter Name SQL text Validation
Ledger 
 
 LOV Oracle
Legal Entity 
 
 LOV Oracle
Journal Entry Source 
 
 LOV Oracle
Accounting Flexfield From 
 
 Char
Accounting Flexfield To 
 
 Char
Period From 
 
 LOV Oracle
Period To 
 
 LOV Oracle
Start Date 
 
 Date
End Date 
 
 Date
Posting Status 
 
 LOV Oracle
Accounting Period Type 
 
 LOV Oracle
Include Year to Date Carried Forward 
 
 LOV Oracle
Document Sequence Name 
 
 LOV Oracle
Balance Type 
 
 LOV Oracle
First Report Sort 
 
 LOV Oracle
Second Report Sort 
 
 LOV Oracle
Third Report Sort 
 
 LOV Oracle
Show Natural Account Only 
 
 LOV Oracle
Summarize by Account 
 
 LOV Oracle
First Page Number 
 
 Number
Include Zero Amount 
 
 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 Journals and Third Party 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 French Accounting Entries Audit File
Blitz Report™

Blitz Report™ provides multiple benefits: