JL Mexican Accounts Auxiliary Report - XML File

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Application: Latin America Localizations
Source: Mexican Accounts Auxiliary Report - XML File
Short Name: JLMXAAUX_XMLP
DB package: JL_MX_JOURNAL_ENTRIES_PKG
Run JL Mexican Accounts Auxiliary Report - XML File and other Oracle EBS reports with Blitz Report™ on our demo environment
Select to_char(jml.journal_date,'YYYY-MM-DD') journal_date,
                                        substr(gl_je_name,1,(50 - (length(to_char(je_header_id))+1))) || ' ' || to_char(je_header_id) journal_name,
					substr(jml.line_description,1,200) line_description,
					trim(TO_CHAR(ROUND(NVL(jml.ACCOUNTED_DR,0), :G_PRECISION),'9999999999999999999990.00')) accounted_dr,
					trim(TO_CHAR(ROUND(NVL(jml.ACCOUNTED_CR,0), :G_PRECISION),'9999999999999999999990.00')) accounted_cr,
					jma.natural_account || ' ' || jma.subaccount account,
					substr(jma.natural_account_desc || ' ' || jma.subaccount_desc, 1 ,100) description,
					trim(TO_CHAR(ROUND(NVL(jma.BEGIN_BALANCE,0), :G_PRECISION),'9999999999999999999990.00')) begin_balance,
					trim(TO_CHAR(ROUND(NVL(jma.END_BALANCE,0), :G_PRECISION),'9999999999999999999990.00')) end_balance
					From jl_mx_je_lines_t jml,
						 jl_mx_gl_accounts_t jma
					Where jml.request_id = :g_con_request_id
					  and jma.config_id = :P_CONFIG_ID
					  and decode(jma.company_bsv,'T','1', jma.company_bsv) = decode(jma.company_bsv,'T','1', jml.addit_info_1)
					  and jma.natural_account = jml.addit_info_2
					  And nvl(Decode(Jma.Subaccount,'T','1', Jma.Subaccount),'1') = nvl(Decode(Jma.Subaccount,'T','1', Jml.Subaccount),'1')
					  -- and Jma.Sat_account is not null
					order by  jma.natural_account,jml.journal_date, jml.gl_je_name, jml.je_header_id
Parameter Name SQL text Validation
Configuration Name 
 
 LOV Oracle
Auxiliary Report Version 
 
 Char
Journal Entry Source 
 
 LOV Oracle
Accounting Flexfield From 
 
 Char
Accounting Flexfield To 
 
 Char
Show Adjustment Periods 
 
 LOV Oracle
Period 
 
 LOV Oracle
Include Zero Amount 
 
 LOV Oracle
Request Type 
 
 LOV Oracle
Audit Request Number 
 
 Char
Audit Process Number 
 
 Char
Seal 
 
 Char
Certificate Number 
 
 Char
Certificate 
 
 Char
Download
Related Blitz Reports
JL Mexican Journal Entries - XML File JL Mexican Trial Balance - XML File JL Mexican Chart of Accounts - XML File JL Mexican Fixed Assets IMPAC - draft JL Chilean General Ledger Cash Ledger- Not Supported: Reserved For Future Use JL Colombian Inflation Adjusted Fixed Assets Report- Not Supported: Reserved For Future Use JL Colombian Fixed Assets Inflation Adjusted Account Drill Down Report- Not Supported: Reserved For Future Use JL Colombian Fixed Assets Inflation Adjusted Drill Down - draft JL Colombian Third Party / Account Report- Not Supported: Reserved For Future Use
Blitz Report™

Blitz Report™ provides multiple benefits: