GL Ledgers and Organizations

Description
Categories: Enginatics, Toolkit - Setup & Support
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.
Run GL Ledgers and Organizations and other Oracle EBS reports with Blitz Report™ on our demo environment
select
haouv.name business_group,
&ledger_set_column
gl.name ledger,
xxen_util.meaning(gl.ledger_category_code,'GL_ASF_LEDGER_CATEGORY',101) ledger_category,
gl.currency_code currency,
fifsv.id_flex_structure_name chart_of_accounts_name,
hou.name operating_unit,
ood.organization_code,
ood.organization_name organization,
ftv.territory_short_name country,
&legal_entity_column
gl.ledger_id,
fifsv.id_flex_structure_code chart_of_accounts_code,
gl.chart_of_accounts_id,
ood.operating_unit operating_unit_id,
ood.organization_id
from
gl_ledgers gl,
fnd_id_flex_structures_vl fifsv,
hr_operating_units hou,
hr_all_organization_units_vl haouv,
org_organization_definitions ood,
hr_all_organization_units haou,
hr_locations_all hla,
fnd_territories_vl ftv
&legal_entity_table
where
nvl(ood.disable_date,sysdate)>=sysdate and
nvl(hou.date_to,sysdate)>=sysdate and
1=1 and
gl.object_type_code='L' and
gl.chart_of_accounts_id=fifsv.id_flex_num and
fifsv.application_id=101 and
fifsv.id_flex_code='GL#' and
gl.ledger_id=hou.set_of_books_id(+) and
hou.business_group_id=haouv.organization_id(+) and
hou.organization_id=ood.operating_unit(+) and
ood.organization_id=haou.organization_id(+) and
haou.location_id=hla.location_id(+) and
hla.country=ftv.territory_code(+) 
&legal_entity_join
order by
chart_of_accounts_name,
&ledger_set_order_by
business_group,
ledger,
currency,
operating_unit,
country,
organization_code
Parameter Name SQL text Validation
Chart of Accounts
fifsv.id_flex_structure_name=:chart_of_accounts
LOV
Ledger
gl.name=:ledger
LOV
Country
ftv.territory_short_name=:country
LOV
Active Organizations only
nvl(ood.disable_date,sysdate)>=sysdate and
nvl(hou.date_to,sysdate)>=sysdate
LOV