CST Journal Entries Report - Cost Management

          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