JG Global Daily Journals
Description
- Categories
- BI Publisher
- Application
- Regional Localizations
- Source
- Global Daily Journals Report
- Short Name
- JGSLADJNL
- DB package
- XLA_JELINES_RPT_PKG
Imported from BI Publisher
SQL 54 lines
SELECT &p_main_col_start &p_party_details_col &p_segment_col &p_uti_col &p_le_col &p_main_col_end 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 &p_other_from WHERE 1 = 1 and :L_RUN_SHORT_REPORT = 'Y' &p_trx_id_filter &p_le_join &p_other_join &p_order_by_clause |
Parameters 30
| Parameter | Type | List of values SQL |
|---|---|---|
| Ledger | LOV Oracle | |
| Legal Entity | LOV Oracle | |
| Journal Entry Source | LOV Oracle | |
| Entered Currency | LOV Oracle | |
| Accounting Flexfield From | Char | |
| Accounting Flexfield To | Char | |
| Period From | LOV Oracle | |
| Period To | LOV Oracle | |
| GL Date From | Date | |
| GL Date To | Date | |
| Document Sequence Name | LOV Oracle | |
| Accounting Sequence Name | LOV Oracle | |
| GL Batch Name | Char | |
| Posting Status | LOV Oracle | |
| Journal Entry Status | LOV Oracle | |
| Third Party Type | LOV Oracle | |
| Third Party Name | LOV Oracle | |
| Third Party Number From | LOV Oracle | |
| Third Party Number To | LOV Oracle | |
| First Flexfield Segment Used | LOV Oracle | |
| Second Flexfield Segment Used | LOV Oracle | |
| Third Flexfield Segment Used | LOV Oracle | |
| First Report Sort | LOV Oracle | |
| Second Report Sort | LOV Oracle | |
| Third Report Sort | LOV Oracle | |
| Fourth Report Sort | LOV Oracle | |
| Fifth Report Sort | LOV Oracle | |
| Report Mode | LOV Oracle | |
| Show Account Recapitulation | LOV Oracle | |
| Journal Category | LOV Oracle |