GL Budget - Hierarchy Listing

➜ Back to Library
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
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 NameSQL textValidation
Ledger
 
LOV Oracle
Download
Related Blitz Reports
GL Budget Amounts Upload GL Account Analysis SAM: GL Account Analysis (Drilldown) (with inventory and WIP) GL Budget - Frozen Budgets Accounts Listing GL Account Analysis (Drilldown) (with inventory and WIP) TB GL Account Analysis (Drilldown)v3 TB GL Account Analysis (Drilldown)v2 GL Summary Account Upload PSB Budget Journal Edit
Blitz Report™