PSB Parameter Listing

➜ Back to Library
Description
Categories: BI Publisher
Application: Public Sector Budgeting (Obsolete)
Source: Parameter Listing (XML)
Short Name: PSBRPPRM_XML
DB package: PSB_PSBRPPRM_XMLP_PKG
Run PSB Parameter Listing and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT sob.name sob_name, bgp.short_name bgp_name, ps.name  ps_name, ps.description set_desc, ps.parameter_set_id
FROM gl_sets_of_books sob, psb_budget_groups bgp, psb_parameter_sets_v ps 
WHERE sob.set_of_books_id = ps.set_of_books_id 
AND  bgp.budget_group_id = ps.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  ps.parameter_set_id = NVL(:P_SET_ID, ps.parameter_set_id)
ORDER BY sob_name, bgp_name, ps_name
Parameter Name SQL text Validation
Ledger 
 
 LOV Oracle
Budget Groups 
 
 LOV Oracle
Parameter Sets 
 
 LOV Oracle
Download
Related Blitz Reports
PSB Budget Revisions Transaction PSB Constraints Listing PSB Allocation Rules Listing PSB Budget Revisions Transaction Report By Responsibility 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: