PSB Constraints Listing

Description
Categories: BI Publisher
Application: Public Sector Budgeting (Obsolete)
Source: Constraints Listing (XML)
Short Name: PSBRPCON_XML
DB package: PSB_PSBRPCON_XMLP_PKG
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
Constraint Sets
 
LOV Oracle
Budget Groups
 
LOV Oracle
Ledger
 
LOV Oracle