GL Ledgers and Organizations

Description

Categories
Enginatics
Repository
GitHub
Master data report showing business group, ledger set, ledger, ledger category, currency, chart of accounts name, operating unit, organization code, country, legal entity, ledger id, chart of accounts code. It also includes support elements such as chart of accounts ID, operating unit ID, and organization ID.

SQL 60 lines

Parameters 6

ParameterTypeList of values SQL
Chart of AccountsLOV
fifsv.id_flex_structure_name=:chart_of_accounts
LedgerLOV
gl.name=:ledger
Operating UnitLOV
hou.name=:operating_unit
Organization CodeLOV
ood.organization_code=:organization_code
CountryLOV
ftv.territory_short_name=:country
Active Organizations onlyLOV
nvl(ood.disable_date,sysdate)>=sysdate and
nvl(hou.date_to,sysdate)>=sysdate