JL Mexican Accounts Auxiliary Report - XML File

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