CST Journal Entries Report - Cost Management

➜ Back to Library
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
Run CST Journal Entries Report - Cost Management and other Oracle EBS reports with Blitz Report™ on our demo environment
          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
Download
Related Blitz Reports
COPY OF: AP Payables Posted Payment Register (old to replicate scheduling issue) XLA Account Analysis JG Global Subledger Detail Journal JG Global Journals and Third Party JG Global Journal Ledger JG Global Daily Journals JG Global GL and SLA Account by Journal Lines JG Global GL and SLA Account Analysis JE Italian Journal Ledger JE French Accounting Entries Audit File
Blitz Report™

Blitz Report™ provides multiple benefits: