PSB Parameter Listing
Description
Categories: BI Publisher
Application: Public Sector Budgeting (Obsolete)
Source: Parameter Listing (XML)
Short Name: PSBRPPRM_XML
DB package: PSB_PSBRPPRM_XMLP_PKG
Source: Parameter Listing (XML)
Short Name: PSBRPPRM_XML
DB package: PSB_PSBRPPRM_XMLP_PKG
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 |