GL Budget - Hierarchy Listing

➜ Back to Library
XMLXML import file

Description

Categories
BI Publisher
Application
General Ledger
Source
Budget - Hierarchy Listing (XML)
Short Name
GLXRBDHR_XML
DB package
GL_GLXRBDHR_XMLP_PKG
Imported from BI Publisher
Budget Hierarchies Listing

SQL 11 lines

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

Parameters 1

ParameterTypeList of values SQL
LedgerLOV Oracle