JL Mexican Trial Balance - XML File

➜ Back to Library
Description
Categories: BI Publisher
Application: Latin America Localizations
Source: Mexican Trial Balance - XML File
Short Name: JLMXTBAL_XMLP
DB package: JL_MX_TBAL_PKG
Run JL Mexican Trial Balance - XML File and other Oracle EBS reports with Blitz Report™ on our demo environment
 SELECT natural_account
					  || ' '
					  || subaccount account, 
					  TRIM(TO_CHAR(ROUND(NVL(BEGIN_BALANCE,0), :G_PRECISION),'9999999999999999999990.00')) begin_balance,
  					  TRIM(TO_CHAR(ROUND(NVL(PERIOD_NET_DR,0), :G_PRECISION),'9999999999999999999990.00')) period_net_dr,
					  TRIM(TO_CHAR(ROUND(NVL(PERIOD_NET_CR,0), :G_PRECISION),'9999999999999999999990.00')) period_net_cr,
					  TRIM(TO_CHAR(ROUND(NVL(END_BALANCE,0), :G_PRECISION),'9999999999999999999990.00')) end_balance					   
					FROM (Select * 
                                              From jl_mx_gl_accounts_t
					      Order By natural_account, subaccount) jl_mx_gl_accounts_t
					WHERE Sat_account IS NOT NULL
					  AND ( NVL(BEGIN_BALANCE,0)   <> 0
  					       Or NVL(PERIOD_NET_DR,0) <> 0
					       Or NVL(PERIOD_NET_CR,0) <> 0
					       Or NVL(END_BALANCE,0)   <> 0)					   
					  CONNECT BY parent_account  = Prior natural_account
					  START WITH parent_account IS NULL
Parameter Name SQL text Validation
Configuration Name 
 
 LOV Oracle
Trial Balance Version 
 
 Char
Period 
 
 LOV Oracle
Adjustment Period 
 
 LOV Oracle
Remittance Type 
 
 LOV Oracle
Trial Balance Modified Date 
 
 Date
Seal 
 
 Char
Certificate Number 
 
 Char
Certificate 
 
 Char
Include Statistical Balances 
 
 LOV Oracle
Download
Related Blitz Reports
JL Mexican Accounts Auxiliary Report - XML File JL Mexican Journal Entries - XML File JL Mexican Chart of Accounts - XML File JL Mexican Fixed Assets IMPAC - draft JL Colombian Third Party / Account Report- Not Supported: Reserved For Future Use JL Colombian Fixed Assets Inflation Adjusted Drill Down - draft JL Brazilian Payables Cancelled Consolidated Invoice Register - draft JL Colombian Payables Withholding Report- Not Supported: Reserved For Future Use JL Chilean General Ledger Cash Ledger- Not Supported: Reserved For Future Use
Blitz Report™

Blitz Report™ provides multiple benefits: