PSB Distribution Rule Listing

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