GL Other - Ledger Set Listing

➜ Back to Library

Description
Categories: BI Publisher, Financials Application: General Ledger Source: Other - Ledger Set Listing (XML) Short Name: GLXLSLST_XML DB package: GL_GLXLSLST_XMLP_PKG more less

Copy

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

Download

Related Blitz Reports
GL Other - Data Access Set Listing JA Third Party Detail Trial Balance with Contra Accounts GL FSG - Content Set Detail Listing PA Project Subledger: Detail by Project PA Project Subledger: Detail by Expenditure Type AR Customer Statement JG Global Third Party Detail and Balances JG Global Third Party Balances Summary JG Global Third Party Account Balance