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
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 |