JE French Accounting Entries Audit File

➜ Back to Library

Description
Categories: BI Publisher Application: European Localizations Source: French Accounting Entries Audit File Short Name: JEFRAEAF DB package: JE_FR_JELINES_RPT_PKG more less

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
JG Global Journal Ledger CST Journal Entries Report - Cost Management JG Global Journals and Third Party JG Global Daily Journals JE Italian Journal Ledger JG Global GL and SLA Account by Journal Lines AR Sales Journal by GL Account XLA Account Analysis JG Global Subledger Detail Journal