GL Budget - Hierarchy Listing

Description
Categories: BI Publisher
Imported from BI Publisher
Description: Budget Hierarchies Listing
Application: General Ledger
Source: Budget - Hierarchy Listing (XML)
Short Name: GLXRBDHR_XML
DB package: GL_GLXRBDHR_XMLP_PKG
Run GL Budget - Hierarchy Listing and other Oracle EBS reports with Blitz Report™ on our demo environment
select control.budget_name control_budget,
       dependent.budget_name dependent_budget
from gl_budget_versions control,
       gl_budget_versions dependent,
       gl_budgets glb
 where control.budget_version_id =
       dependent.control_budget_version_id
   and control.budget_name = glb.budget_name
   and glb.ledger_id = :P_LEDGER_ID
order by control.budget_name, dependent.budget_name
Parameter Name SQL text Validation
Ledger
 
LOV Oracle