GL Ledger Sets

Description
Categories: Enginatics, Financials
GL ledger sets and included 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