PSB Standard Budget Items Listing

Description
Categories: BI Publisher
Application: Public Sector Budgeting (Obsolete)
Source: Standard Budget Items Listing (XML)
Short Name: PSBRPSBI_XML
DB package: PSB_PSBRPSBI_XMLP_PKG
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
Parameter Name SQL text Validation
Item Name
 
LOV Oracle
Ledger Name
 
LOV Oracle