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
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 | |
---|---|---|---|
Ledger/Ledger Set | LOV Oracle | ||
Legal Entity | LOV Oracle | ||
Journal Entry Source | LOV Oracle | ||
Accounting Flexfield From | |||
Accounting Flexfield To | |||
Show Adjustment Periods | LOV Oracle | ||
Period From | LOV Oracle | ||
Period To | LOV Oracle | ||
Posting Status | LOV Oracle | ||
Accounting Period Type | LOV Oracle | ||
Document Sequence Name | LOV Oracle | ||
Sort By | LOV Oracle | ||
Include Zero Amount | LOV Oracle | ||
Additional Information | LOV Oracle | ||
Ledger | |||
P_LEGAL_ENTITY | |||
P_JE_SOURCE_NAME | |||
P_COA_ID | LOV Oracle | ||
P_GL_DATE_FROM | Date | ||
P_GL_DATE_TO | Date |