ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F42F3869E053B46B63588994 SELECT bg.budget_group_id budget_group_id1, bg.name Top_Budget_Group, sob.name set_of_books_name, rul.distribution_rule_id Rule_ID, rul.name Rule_Name, PSB_PSBRPWDS_XMLP_PKG.cf_distribution_rule_idformula(rul.distribution_rule_id) CF_DISTRIBUTION_RULE_ID, PSB_PSBRPWDS_XMLP_PKG.CP_DISTRIBUTION_RULE_ID_p CP_DISTRIBUTION_RULE_ID FROM psb_budget_groups bg, psb_budget_groups topbg, gl_sets_of_books sob, psb_ws_distribution_rules rul WHERE topbg.set_of_books_id = NVL(:p_set_of_books_id, topbg.set_of_books_id) AND bg.budget_group_id = NVL(:p_budget_group_id, bg.budget_group_id) AND rul.distribution_rule_id = NVL(:p_distribution_rule_id, rul.distribution_rule_id) AND bg.budget_group_type = 'R' AND ( (:p_budget_group_id IS NULL AND bg.root_budget_group = 'Y') OR (:p_budget_group_id IS NOT NULL) ) AND topbg.budget_group_id = decode(bg.root_budget_group,'Y',bg.budget_group_id,bg.root_budget_group_id) AND sob.set_of_books_id = topbg.set_of_books_id AND bg.budget_group_id = rul.budget_group_id ORDER BY sob.name,bg.budget_group_id Y PSB PSBRPWDS_XML US PSB Distribution Rule Listing Application: Public Sector Budgeting (Obsolete) Source: Distribution Rule Listing (XML) Short Name: PSBRPWDS_XML DB package: PSB_PSBRPWDS_XMLP_PKG BI Publisher :p_budget_group_id :p_distribution_rule_id :p_set_of_books_id 1 10 :p_set_of_books_id LOV Oracle PSB_SET_OF_BOOKS Y select set_of_books_id id, name value, null description from gl_sets_of_books order by name US Ledger 2 20 :p_budget_group_id LOV Oracle PSB_BUDGET_GROUP_BY_SOB Y select budget_group_id id, name value, null description from psb_budget_groups_v where budget_group_type='R' and (root_set_of_books_id=:$flex$.psb_set_of_books or set_of_books_id=:$flex$.psb_set_of_books) order by name US Budget Group Name 3 30 :p_distribution_rule_id LOV Oracle PSB_WS_DISTRIBUTION_BY_BG Y select distribution_rule_id id, name value, null description from psb_ws_distribution_rules where budget_group_id=:$flex$.psb_budget_group_by_sob order by name Y US Distribution Rule Name :$flex$.psb_budget_group_by_sob Budget Group Name Distribution Rule Name :$flex$.psb_set_of_books Ledger Budget Group Name