ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDED679D2E0530100007F1FF2 GL Chart of Accounts (all) Y select fifsv.id_flex_structure_name value, fifsv.id_flex_structure_code description from fnd_id_flex_structures_vl fifsv where fifsv.id_flex_code='GL#' and fifsv.application_id=101 order by fifsv.id_flex_structure_name US All chart of accounts A068D9AB7A692D6AE0530100007F1E6C 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_v glsnav, gl_ledgers gl where 1=1 and glsv.ledger_id=glsnav.ledger_set_id and glsnav.ledger_id=gl.ledger_id order by glsv.name, decode(gl.ledger_category_code,'PRIMARY',1,'SECONDARY',2,'ALC',3,'NONE',4), gl.name Y US GL Ledger Sets Master data report showing GL ledger sets and included ledgers. Enginatics R12 only 1=1 1 10 1=1 glsv.name=:ledger_set LOV custom Y select glsv.name value, glsv.chart_of_accounts_name||nvl2(glsv.description,': '||glsv.description,null) description from gl_ledger_sets_v glsv order by glsv.name F Jeu de grands livres US Ledger Set 2 20 1=1 glsv.chart_of_accounts_name=:chart_of_accounts LOV GL Chart of Accounts (all) 8E2FF36EDED679D2E0530100007F1FF2 Y select fifsv.id_flex_structure_name value, fifsv.id_flex_structure_code description from fnd_id_flex_structures_vl fifsv where fifsv.id_flex_code='GL#' and fifsv.application_id=101 order by fifsv.id_flex_structure_name F Plan comptable US Chart of Accounts