PSB Constraints Listing

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

Blitz Report™