JL Colombian Third Party Balances Error - draft

Description
Categories: BI Publisher
Columns: E Conc Id, Error, Je Header Id, Je Line Num, Identifier, Jsource, Jname ...
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
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
Parameter Name SQL text Validation
Process Id
 
LOV Oracle
Ledger Id
 
Number