JL Colombian Third Party Balances Error Report- Not Supported: Reserved For Future Use

Description

Categories
BI Publisher
Application
Latin America Localizations
Source
Colombian Third Party Balances Error Report (XML) - Not Supported: Reserved For Future Use
Short Name
JLCOGLNE_XML
DB package
JL_JLCOGLNE_XMLP_PKG
Imported from BI Publisher
Colombian Third Party Balances Error Report

SQL 9 lines

SELECT e.process_id e_conc_id, e.message_text error, e.je_header_id, e.je_line_num,
              e.identifier,  gs.user_je_source_name jsource, gh.name jname
FROM    GL_JE_SOURCES gs, JL_CO_GL_CONC_ERRS e, GL_JE_HEADERS gh
WHERE  e.process_id = :P_CONC_ID
AND      e.je_header_id   = gh.je_header_id
AND      gs.je_source_name = gh.je_source 
 and e.process_id=:m_conc_id
ORDER BY 3, 4

Parameters 2

ParameterTypeList of values SQL
Operating UnitLOV
Process IdLOV Oracle