CST Journal Entries Report - Cost Management

Description
Categories: BI Publisher
Application: Bills of Material
Source: Journal Entries Report - Cost Management
Short Name: CSTJELINESRPT
DB package: XLA_JELINES_RPT_PKG
          SELECT
		    (NVL(TABLE1.accounted_dr,0) - NVL(TABLE1.accounted_cr,0)) TOTAL,
              &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 TABLE1.ACCOUNTING_CLASS_CODE IN ('RECEIVING_INSPECTION','INVENTORY_VALUATION','INTRANSIT_VALUATION','WIP_VALUATION')
			and TABLE1.application_id = 707
            &p_trx_id_filter
	       &p_le_join
	       &p_other_join
	       order by TABLE1.LEDGER_ID,USER_TRX_IDENTIFIER_VALUE_2,TABLE1.ACCOUNTING_CLASS_CODE,TABLE1.ACCOUNTING_CODE_COMBINATION
Parameter Name SQL text Validation
Ledger/Ledger Set
 
LOV Oracle
Period From
 
LOV Oracle
Period To
 
LOV Oracle
Transaction Date From
 
Transaction Date To
 
Journal Entry Status
 
LOV Oracle
Process Category
 
LOV Oracle
Include Zero Amount Lines
 
LOV Oracle
Include User Transaction Identifiers
 
LOV Oracle
XLA_SRS_SUBLEDGERS
 
LOV Oracle
P_GL_DATE_FROM
 
Date
P_GL_DATE_TO
 
Date
Journal Source
 
LOV Oracle
XLA_SRS_NO_VALIDATION
 
Balance Type
 
LOV Oracle
P_SECURITY_ID_INT_1
 
Include Analytical Criterion
 
LOV Oracle
P_INCLUDE_TAX_DETAILS_FLAG
 
LOV Oracle
P_INCLUDE_LE_INFO_FLAG
 
LOV Oracle
Fetch from GL