Search Results psb_service_packages_v

Overview

PSB_SERVICE_PACKAGES_V is a reporting view owned by the APPS schema in Oracle E-Business Suite, defined within the Public Sector Budgeting (PSB) product family. It presents service package records — logical groupings of budget services used during budget formulation — together with the name of the global worksheet to which each package is attached. The view is a denormalized read interface: it joins the transactional service package table to the worksheets table so that consumers (Oracle Forms LOVs, concurrent programs, Discoverer workbooks, and custom reports) can retrieve the human-readable worksheet name without performing the join themselves.

Because the view exposes the standard WHO columns and the DFF attribute columns, it remains valid for both 12.1.1 and 12.2.2. Its status is VALID and no multi-org policy is applied, so it is typically queried in a reporting context rather than used to drive transactional updates.

Underlying Base Objects

The view is defined over two tables in the APPS schema:

• PSB_SERVICE_PACKAGES (aliased SP) — the driving table, holding the service package definition, priority, descriptive attributes, descriptive flexfield segments, and the foreign key GLOBAL_WORKSHEET_ID.
• PSB_WORKSHEETS (aliased WS) — joined on SP.GLOBAL_WORKSHEET_ID = WS.WORKSHEET_ID to supply the global worksheet name and worksheet-level context.

The join is an equality (inner) join, so a service package row is returned only when a matching worksheet row exists. The view also selects SP.ROWID, enabling row-identified updateability for Forms-based maintenance. ETRM 12.2.2 documents no further referenced base objects, and no additional view-to-view lineage is published.

Key Columns

• SERVICE_PACKAGE_ID — primary key of the underlying service package row.
• SERVICE_PACKAGE_NAME / SERVICE_PACKAGE_SHORT_NAME — the display name and abbreviated name, surfaced from SP.NAME and SP.SHORT_NAME.
• GLOBAL_WORKSHEET_ID — foreign key linking the package to its global worksheet.
• GLOBAL_WORKSHEET_NAME — the worksheet name obtained from PSB_WORKSHEETS.NAME; this is the column most often targeted by ad hoc queries against this view.
• PRIORITY, DESCRIPTION, BASE_SERVICE_PACKAGE — ranking, descriptive text, and the base (template) package from which the record derives.
• ATTRIBUTE1–ATTRIBUTE10, CONTEXT — descriptive flexfield segments retained for reporting on client-specific attributes.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE — standard audit columns.
• ROW_ID — the row identifier required for optimistic locking in the associated maintenance form.

Common Use Cases and Queries

Typical scenarios include listing all service packages for a named global worksheet, auditing which worksheet owns a given package, and driving budget-entry LOVs that must display worksheet names alongside package names.

SELECT SERVICE_PACKAGE_ID,
       SERVICE_PACKAGE_NAME,
       GLOBAL_WORKSHEET_NAME,
       PRIORITY
FROM   APPS.PSB_SERVICE_PACKAGES_V
WHERE  GLOBAL_WORKSHEET_NAME = :p_worksheet_name
ORDER  BY PRIORITY;

A secondary pattern joins the view to budget line facts to reconcile packages consumed within a worksheet. Because the view is not org-stripped, no ORG_ID predicate is required, although implementers may still filter on the owning business group through related budgeting objects where multi-org budgeting is enabled.