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
SQL 9 lines
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 |
Parameters 3
| Parameter | Type | List of values SQL |
|---|---|---|
| Ledger | LOV Oracle | |
| Budget Groups | LOV Oracle | |
| Constraint Sets | LOV Oracle |