GL Budget - Hierarchy Listing

Description
Categories: BI Publisher, Financials
Application: General Ledger
Source: Budget - Hierarchy Listing (XML)
Short Name: GLXRBDHR_XML
DB package: GL_GLXRBDHR_XMLP_PKG
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
Access Set Id
 
Number
Ledger
 
LOV Oracle