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

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

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