GL Other - Ledger Set Listing
Description
- Categories
- BI Publisher
- Application
- General Ledger
- Source
- Other - Ledger Set Listing (XML)
- Short Name
- GLXLSLST_XML
- DB package
- GL_GLXLSLST_XMLP_PKG
SQL 8 lines
select g.name LEDGER_NAME, lp.meaning LEDGER_TYPE, g.description DESCRIPTION from gl_ledger_set_norm_assign s, gl_ledgers g, gl_lookups lp where s.ledger_set_id = :P_LEDGER_ID and g.ledger_id = s.ledger_id and lp.lookup_code = g.object_type_code and lp.lookup_type = 'LEDGERS' order by 1,2,3 |
Parameters 1
| Parameter | Type | List of values SQL |
|---|---|---|
| Ledger Set | LOV Oracle |