Search Results base_service_package

Overview

APPS.PSB_WS_SERVICE_PACKAGES_V is a valid Oracle E-Business Suite view in the APPS schema, registered under FND Design Data as PSB.PSB_WS_SERVICE_PACKAGES_V. It belongs to the Oracle Enterprise Technical Reference Model (ETRM) family of database objects associated with the Grants and Budgeting (PSB) product modules. The view is classified as a supplementary view used to simplify Forms coding, which is a common pattern in EBS where a view is created specifically to support an Oracle Forms block by joining base tables and exposing a flattened, denormalized result set rather than requiring the form to query multiple tables directly.

Oracle explicitly warns that this view is not intended for direct querying or data manipulation by customers or integrators. Because it exists to serve Forms logic, its structure may change significantly between minor or major releases without notice. Despite this warning, the view is routinely referenced by reporting tools, custom concurrent programs, and integration interfaces that need to retrieve service package and worksheet information correlated to budget periods and year types.

The view is not documented as being referenced by any other database object, meaning it acts as a terminal read-only source rather than a dependency for other views or packages.

Underlying Base Objects

The view is defined over a set of PSB base tables. The documented dependencies are:

• APPS.PSB_SERVICE_PACKAGES — the master service package definition table
• APPS.PSB_WORKSHEETS — the worksheet header table within the budgeting module
• APPS.PSB_WS_LINES — worksheet line entries
• APPS.PSB_WS_ACCOUNT_LINES — account-level worksheet lines
• APPS.PSB_BUDGET_PERIODS — budget period definitions
• APPS.PSB_BUDGET_YEAR_TYPES — budget year type lookup table

Because the view joins these objects, it effectively provides a consolidated view linking a worksheet and its service packages to budget period and year type context. The ETRM metadata does not document exact join conditions, but the presence of WORKSHEET_ID and SERVICE_PACKAGE_ID as exposed columns indicates that the view reconciles worksheet-level and service-package-level records.

Key Columns

The view exposes the following columns:

• ROW_ID (ROWID) — the unique row identifier, useful as a surrogate for Forms block row selection.
• WORKSHEET_ID (NUMBER) — foreign key to PSB_WORKSHEETS, identifying the worksheet context.
• SERVICE_PACKAGE_ID (NUMBER) — primary identifier of the service package.
• SERVICE_PACKAGE_NAME (VARCHAR2(30)) — the descriptive name of the service package.
• SERVICE_PACKAGE_SHORT_NAME (VARCHAR2(15)) — the abbreviated name or code for the service package. This is typically the user-facing identifier used in lookup and search interfaces.
• BASE_SERVICE_PACKAGE (VARCHAR2) — indicates whether the record is a base or derived service package.
• PRIORITY (NUMBER) — ordering or ranking of the service package within its worksheet.
• DESCRIPTION (VARCHAR2(2000)) — free-text description of the service package.

Common Use Cases and Queries

A frequent reporting scenario is locating a service package by its short name, which is the identifier users recognize. A typical query is:

SELECT worksheet_id, service_package_id, service_package_name, service_package_short_name, priority FROM apps.psb_ws_service_packages_v WHERE service_package_short_name = :p_short_name;

Other use cases include reconciling worksheet line details against service packages for budget validation, exporting service package definitions to an integration staging table, and driving a Forms LOV. While the view is read-only for practical purposes, it can be joined to PSB_SERVICE_PACKAGES using SERVICE_PACKAGE_ID to obtain additional attributes not exposed here. Given Oracle's cautionary note, developers should treat the view as a convenience object and consider querying the underlying base tables directly when long-term stability is required.