PSB Standard Budget Items Listing

➜ Back to Library
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
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
Download
Related Blitz Reports
GL Account Analysis (Distributions) PSB Budget Group Hierarchy Listing PSB Distribution Rule Listing PSB Constraints Listing PSB Allocation Rules Listing PSB Budget Revisions Transaction Report By Responsibility PSB Parameter Listing PSB Budget Revisions Transaction PSB Stage Variance Report for Account by Responsibility
Blitz Report™

Blitz Report™ provides multiple benefits: