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
Run JL Mexican Chart of Accounts - XML File and other Oracle EBS reports with Blitz Report™ on our demo environment
 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 Name SQL text Validation
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 JE Italian Withholding Yearly JE Italian Annual Customer and Supplier Listing JE Italian Annual Customer and Supplier Electronic Format GL Ledgers and Legal Entities IBY Payment Process Request Details JE Belgian VAT Sales Journal
Blitz Report™

Blitz Report™ provides multiple benefits: