JL Mexican Chart of Accounts - XML File

Description
Categories: BI Publisher
Columns: Rfc Number, Month, Year ...
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 Name SQL text Validation
Configuration Name
 
LOV Oracle
Chart of Accounts Version
 
Seal
 
Certificate Number
 
Certificate