PSB Allocation Rules Listing

Description

Categories
BI Publisher
Application
Public Sector Budgeting (Obsolete)
Source
Allocation Rules Listing (XML)
Short Name
PSBRPPAL_XML
DB package
PSB_PSBRPPAL_XMLP_PKG

SQL 10 lines

SELECT sob.name sob_name, bgp.short_name bgp_name, asv.name  as_name, asv.description set_desc
		 , asv.allocrule_set_id allocrule_set_id1
FROM gl_sets_of_books sob, psb_budget_groups bgp, psb_allocrule_sets_v asv 
WHERE sob.set_of_books_id = asv.set_of_books_id 
AND  bgp.budget_group_id = asv.budget_group_id 
AND  sob.set_of_books_id = NVL( :P_SOB_ID, sob.set_of_books_id)
AND  bgp.budget_group_id = NVL( :P_BGP_ID, bgp.budget_group_id)
AND  asv.allocrule_set_id = NVL(:P_SET_ID, asv.allocrule_set_id)
ORDER BY sob_name, bgp_name, asv.name

Parameters 3

ParameterTypeList of values SQL
LedgerLOV Oracle
Budget GroupsLOV Oracle
Allocation Rule SetsLOV Oracle