PSB Standard Budget Items Listing

SELECT i.short_name ishname, i.name iname, i.unit_of_measure, i.description, b.name bname, l.currency, l.concatenated_segments, l.rate, l.set_of_books_id bookid
FROM gl_sets_of_books b, psb_standard_budget_items i, psb_standard_budget_item_lines l
WHERE i.standard_budget_item_id = l.standard_budget_item_id
AND l.set_of_books_id = b.set_of_books_id
AND (:P_STANDARD_BUDGET_ITEM_ID IS NULL OR i.standard_budget_item_id = :P_STANDARD_BUDGET_ITEM_ID)
 and l.set_of_books_id=:set_of_books_id
ORDER BY ishname

SELECT i.short_name ishname, i.name iname, i.unit_of_measure, i.description, b.name bname, l.currency, l.concatenated_segments, l.rate, l.set_of_books_id bookid FROM gl_sets_of_books b, psb_standard_budget_items i, psb_standard_budget_item_lines l WHERE i.standard_budget_item_id = l.standard_budget_item_id AND l.set_of_books_id = b.set_of_books_id AND (:P_STANDARD_BUDGET_ITEM_ID IS NULL OR i.standard_budget_item_id = :P_STANDARD_BUDGET_ITEM_ID) and l.set_of_books_id=:set_of_books_id ORDER BY ishname