JG Global GL and SLA Account by Journal Lines

Description
Categories: BI Publisher
Application: Regional Localizations
Source: Global GL and SLA Account by Journal Lines Report
Short Name: JGSLAAJNL
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
P_PARTY_TYPE_CODE
 
Show Account Recapitulation
 
LOV Oracle
P_CUSTOM_PARAMETER_14
 
P_CUSTOM_PARAMETER_13
 
P_CUSTOM_PARAMETER_12
 
P_INCLUDE_LEGAL_ENTITY_INFO
 
P_INCLUDE_LE_INFO_FLAG
 
LOV Oracle
P_INCLUDE_TAX_DETAILS
 
P_INCLUDE_TAX_DETAILS_FLAG
 
LOV Oracle
P_DUMMY_PARTY
 
P_PARTY_NAME
 
P_JE_STATUS
 
P_POSTING_STATUS
 
Accounting Sequence Name
 
P_COA_ID
 
LOV Oracle
P_JE_SOURCE_NAME
 
P_LEGAL_ENTITY
 
P_LEDGER
 
P_RESP_APPLICATION_ID
 
Journal Category
 
LOV Oracle
Third Party Number To
 
LOV Oracle
Third Party Number From
 
LOV Oracle
Third Party Name
 
LOV Oracle
Third Party Type
 
LOV Oracle
Journal Entry Status
 
LOV Oracle
Posting Status
 
LOV Oracle
GL Batch Name
 
Accounting Sequence Name
 
LOV Oracle
GL Date To
 
Date
GL Date From
 
Date
Period To
 
LOV Oracle
Period From
 
LOV Oracle
Accounting Flexfield To
 
Accounting Flexfield From
 
Entered Currency
 
LOV Oracle
Journal Entry Source
 
LOV Oracle
Legal Entity
 
LOV Oracle
Ledger
 
LOV Oracle