JE French Accounting Entries Audit File

Description
Categories: BI Publisher
Application: European Localizations
Source: French Accounting Entries Audit File
Short Name: JEFRAEAF
DB package: JE_FR_JELINES_RPT_PKG
	SELECT  &p_select_clause
         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_where_clause
          ORDER BY 
		  &p_orderby_clause
Parameter Name SQL text Validation
P_GL_DATE_TO
 
Date
P_GL_DATE_FROM
 
Date
P_COA_ID
 
LOV Oracle
P_JE_SOURCE_NAME
 
P_LEGAL_ENTITY
 
Ledger
 
Additional Information
 
LOV Oracle
Include Zero Amount
 
LOV Oracle
Sort By
 
LOV Oracle
Document Sequence Name
 
LOV Oracle
Accounting Period Type
 
LOV Oracle
Posting Status
 
LOV Oracle
Period To
 
LOV Oracle
Period From
 
LOV Oracle
Show Adjustment Periods
 
LOV Oracle
Accounting Flexfield To
 
Accounting Flexfield From
 
Journal Entry Source
 
LOV Oracle
Legal Entity
 
LOV Oracle
Ledger/Ledger Set
 
LOV Oracle