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
Source: Standard Budget Items Listing (XML)
Short Name: PSBRPSBI_XML
DB package: PSB_PSBRPSBI_XMLP_PKG
Run
PSB Standard Budget Items Listing and other Oracle EBS reports with Blitz Report™ on our demo environment
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 | |
---|---|---|---|
Ledger Name |
|
LOV Oracle | |
Item Name |
|
LOV Oracle |