XLA Journal Entries

Description
Categories: BI Publisher
Application: Subledger Accounting
Source: Journal Entries Report
Short Name: XLAJELINESRPT
DB package: XLA_JELINES_RPT_PKG
          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
Parameter Name SQL text Validation
Ledger/Ledger Set
 
LOV Oracle
Period From
 
LOV Oracle
Period To
 
LOV Oracle
Journal Entry Status
 
LOV Oracle
Transfer or Posting Status
 
LOV Oracle
Journal Source
 
LOV Oracle
Journal Category
 
LOV Oracle
Include Zero Amount Lines
 
LOV Oracle
Include User Transaction Identifiers
 
LOV Oracle
Display legal information
 
LOV Oracle
Enable Long Report
 
LOV Oracle
XLA_SRS_SUBLEDGERS
 
LOV Oracle
Ledger Name
 
P_COA_ID
 
LOV Oracle
P_GL_DATE_FROM
 
Date
P_GL_DATE_TO
 
Date
P_JE_STATUS
 
P_POSTING_STATUS
 
P_JE_SOURCE_NAME
 
P_PROCESS_CATEGORY
 
XLA_SRS_NO_VALIDATION
 
P_EVENT_CLASS
 
P_JE_CATEGORY_NAME
 
Balance Type
 
LOV Oracle
P_INCLUDE_ZERO_AMOUNT_LINES
 
P_INCLUDE_USER_TRX_IDENTIFIERS
 
P_INCLUDE_TAX_DETAILS_FLAG
 
LOV Oracle
P_INCLUDE_LE_INFO_FLAG
 
LOV Oracle
Fetch from GL
 
Doc Sequence Name
 
Enable Scalable Flag
 
LOV Oracle