JL Mexican Chart of Accounts - XML File
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
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 | Char | ||
Seal | Char | ||
Certificate Number | Char | ||
Certificate | Char |