JL Mexican Accounts Auxiliary Report - XML File

Description
Categories: BI Publisher
Application: Latin America Localizations
Source: Mexican Accounts Auxiliary Report - XML File
Short Name: JLMXAAUX_XMLP
DB package: JL_MX_JOURNAL_ENTRIES_PKG
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
Request Type Dummy1
 
Number
Request Type Dummy
 
Number
Posting Status
 
LOV Oracle
End Date
 
Date
Start Date
 
Date
Period To
 
LOV Oracle
Subaccount Segment Name
 
LOV Oracle
JGSLA_CHART_OF_ACCOUNTS
 
LOV Oracle
Journal Entry Source Name
 
Legal Entity Name
 
Legal Entity
 
LOV Oracle
Ledger Name
 
JGSLA_JELINES_LEDGERS
 
LOV Oracle
Certificate
 
Certificate Number
 
Seal
 
Audit Process Number
 
Audit Request Number
 
Request Type
 
LOV Oracle
Include Zero Amount
 
LOV Oracle
Period
 
LOV Oracle
Show Adjustment Periods
 
LOV Oracle
Accounting Flexfield To
 
Accounting Flexfield From
 
Journal Entry Source
 
LOV Oracle
Auxiliary Report Version
 
Configuration Name
 
LOV Oracle