PSB Allocation Rules Listing

➜ Back to Library
Description
Categories: BI Publisher
Application: Public Sector Budgeting (Obsolete)
Source: Allocation Rules Listing (XML)
Short Name: PSBRPPAL_XML
DB package: PSB_PSBRPPAL_XMLP_PKG
Run PSB Allocation Rules Listing and other Oracle EBS reports with Blitz Report™ on our demo environment
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
Parameter Name SQL text Validation
Ledger 
 
 LOV Oracle
Budget Groups 
 
 LOV Oracle
Allocation Rule Sets 
 
 LOV Oracle
Download
Related Blitz Reports
PSB Budget Revisions Transaction PSB Constraints Listing PSB Budget Revisions Transaction Report By Responsibility PSB Parameter Listing PSB Budget Group Hierarchy Listing PSB Distribution Rule Listing PSB Stage Variance Report for Account by Responsibility PSB Stage Variance Report for Account PSB Stage Variance Report for Position
Blitz Report™

Blitz Report™ provides multiple benefits: