JE Italian Journal Ledger

Description
Categories: BI Publisher
Application: European Localizations
Source: Italian Journal Ledger Report
Short Name: JEITJNLLG
DB package: JE_IT_JELINES_RPT_PKG
          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
P_CUSTOM_PARAMETER_18
 
P_CUSTOM_PARAMETER_17
 
P_CUSTOM_PARAMETER_16
 
P_CUSTOM_PARAMETER_14
 
P_CUSTOM_PARAMETER_13
 
P_CUSTOM_PARAMETER_12
 
Balance Type
 
XLA_SRS_YES_NO
 
LOV Oracle
P_COA_ID
 
LOV Oracle
P_JE_SOURCE_NAME
 
P_LEGAL_ENTITY
 
P_LEDGER
 
P_RESP_APPLICATION_ID
 
Include Zero Amount
 
LOV Oracle
First Page Number
 
Number
Summarize by Account
 
LOV Oracle
Show Natural Account Only
 
LOV Oracle
Third Report Sort
 
LOV Oracle
Second Report Sort
 
LOV Oracle
First Report Sort
 
LOV Oracle
Balance Type
 
LOV Oracle
Document Sequence Name
 
LOV Oracle
Include Year to Date Carried Forward
 
LOV Oracle
Accounting Period Type
 
LOV Oracle
Posting Status
 
LOV Oracle
End Date
 
Date
Start Date
 
Date
Period To
 
LOV Oracle
Period From
 
LOV Oracle
Accounting Flexfield To
 
Accounting Flexfield From
 
Journal Entry Source
 
LOV Oracle
Legal Entity
 
LOV Oracle
Ledger
 
LOV Oracle