JL Mexican Accounts Auxiliary Report - XML File

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
Blitz Report™