ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F42A3869E053B46B63588994 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 Y PSB PSBRPSBI_XML US PSB Standard Budget Items Listing Application: Public Sector Budgeting (Obsolete) Source: Standard Budget Items Listing (XML) Short Name: PSBRPSBI_XML DB package: PSB_PSBRPSBI_XMLP_PKG BI Publisher :p_standard_budget_item_id :set_of_books_id 1 10 :p_set_of_books_id LOV Oracle PSB_SRS_BOOKS Y select set_of_books_id id, name value, description description from gl_sets_of_books order by name US Ledger Name 2 20 :p_standard_budget_item_id LOV Oracle PSB_SRS_ITEMS Y select standard_budget_item_id id, name value, description description from psb_standard_budget_items order by name US Item Name