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

Copy

	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

Download

Related Blitz Reports

CST Journal Entries Report - Cost Management 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 AP Payables Posted Payment Register AP Payables Posted Invoice Register XLA Account Analysis XLA Journal Entries