GL Other - Ledger Set Listing
Description
Categories: BI Publisher
Columns: Ledger Name, Ledger Type, Description ...
Columns: Ledger Name, Ledger Type, Description ...
Application: General Ledger
Source: Other - Ledger Set Listing (XML)
Short Name: GLXLSLST_XML
DB package: GL_GLXLSLST_XMLP_PKG
Source: Other - Ledger Set Listing (XML)
Short Name: GLXLSLST_XML
DB package: GL_GLXLSLST_XMLP_PKG
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 |
| Parameter Name | SQL text | Validation | |
|---|---|---|---|
| Ledger Set |
|
LOV Oracle |
