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

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

Ask a question

Download

Related Blitz Reports

GL Other - Data Access Set Listing FND Access Control GL Data Access Sets GL Balance by Account Hierarchy FA Asset Book Details JA Third Party Detail Trial Balance with Contra Accounts PA Project Subledger: Detail by Expenditure Type PA Project Subledger: Detail by Project AR Customer Statement