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
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
| Parameter | Type | List of values SQL |
|---|---|---|
| Operating Unit | LOV | |
| Process Id | LOV Oracle |