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

ParameterTypeList of values SQL
Ledger SetLOV Oracle