GL Other - Ledger Set Listing

Description
Categories: BI Publisher, Financials
Application: General Ledger
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
Ask a question