ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F17E3869E053B46B63588994Y 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 JL JLMXCOAF_XMLP US JL Mexican Chart of Accounts - XML File Application: Latin America Localizations Source: Mexican Chart of Accounts - XML File Short Name: JLMXCOAF_XMLP DB package: JL_MX_COA_ENTRIES_PKG BI Publisher :g_debug_flag :p_certificate :p_certificate_num :p_coa_version :p_config_id :p_seal 1 10 :p_config_id LOV Oracle JLMX_CONFIGURATIONS Y select config_id id, config_name value, null description from jl_mx_gl_configs order by config_name Y US Configuration Name 2 20 :p_coa_version Char 1.3 Y US Chart of Accounts Version 3 30 :p_seal Char US Seal 4 40 :p_certificate_num Char US Certificate Number 5 50 :p_certificate Char US Certificate