JL Mexican Chart of Accounts - XML File

➜ Back to Library
Description
Categories: BI Publisher
Application: Latin America Localizations
Source: Mexican Chart of Accounts - XML File
Short Name: JLMXCOAF_XMLP
DB package: JL_MX_COA_ENTRIES_PKG
 SELECT  SUBSTR(reg.registration_number,1,13) rfc_number,
                            to_char(sysdate,'MM') month,
                            to_char(sysdate,'RRRR') year
                      FROM  xle_registrations reg,
                            xle_jurisdictions_vl jur
                     WHERE  reg.source_id       =  (Select legal_entity_id
                                                    From jl_mx_gl_configs 
                                                    Where config_id = :p_config_id)
                       AND  reg.source_table    = 'XLE_ENTITY_PROFILES'
                       AND  reg.jurisdiction_id = jur.jurisdiction_id
                       AND  jur.registration_code_le   = 'RFC'
                       AND  sysdate between nvl(reg.effective_from,sysdate) and Nvl(reg.effective_to,sysdate)
                       AND  rownum=1
Parameter NameSQL textValidation
Configuration Name
 
LOV Oracle
Chart of Accounts Version
 
Char
Seal
 
Char
Certificate Number
 
Char
Certificate
 
Char
Download
Related Blitz Reports
XLE Legal Entities ZX Party Tax Profiles JL Colombian Payables Withholding Certificate - draft AR European Sales Listing JE Italian Withholding Yearly JE Italian Annual Customer and Supplier Listing JE Italian Annual Customer and Supplier Electronic Format GL Ledgers and Legal Entities JE Belgian VAT Sales Journal
Blitz Report™