CST Journal Entries Report - Cost Management

Description
Categories: BI Publisher
Imported from BI Publisher
Description: Subledger Accounting Journal Entries Report for Cost Management
Application: Bills of Material
Source: Journal Entries Report - Cost Management
Short Name: CSTJELINESRPT
DB package: XLA_JELINES_RPT_PKG

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

          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
 
Char
Transaction Date To
 
Char
Journal Entry Status
 
LOV Oracle
Process Category
 
LOV Oracle
Include Zero Amount Lines
 
LOV Oracle
Include User Transaction Identifiers
 
LOV Oracle