GL Ledger Sets

Description
Categories: Enginatics, Toolkit - Operations
Repository: Github Columns: Ledger Set, Short Name, Description, Chart Of Accounts, Calendar, Period Type, Default Ledger, Ledger, Object Type Code, Ledger Catgory ...
Master data report showing GL ledger sets and corresponding ledgers.
select
glsv.name ledger_set,
glsv.short_name,
glsv.description,
glsv.chart_of_accounts_name chart_of_accounts,
glsv.period_set_name calendar,
glsv.user_period_type period_type,
(select gl.name from gl_ledgers gl where glsv.default_ledger_id=gl.ledger_id) default_ledger,
gl.name ledger,
xxen_util.meaning(gl.object_type_code,'LEDGERS',101) object_type_code,
xxen_util.meaning(gl.ledger_category_code,'GL_ASF_LEDGER_CATEGORY',101) ledger_catgory,
gl.description ledger_description
from
gl_ledger_sets_v glsv,
gl_ledger_set_norm_assign glsna,
gl_ledgers gl
where
1=1 and
glsv.ledger_id=glsna.ledger_set_id and
nvl(glsna.status_code,'X')<>'D' and
glsna.ledger_id=gl.ledger_id
order by
glsv.name,
decode(gl.ledger_category_code,'PRIMARY',1,'SECONDARY',2,'ALC',3,'NONE',4),
gl.name
Parameter Name SQL text Validation
Chart of Accounts
glsv.chart_of_accounts_name=:chart_of_accounts
LOV
Ledger Set
glsv.name=:ledger_set
LOV