Search Results psb_ws_lines_positions




Overview
Explore in AI Chat

Overview

The PSB_WS_LINES_POSITIONS table is a junction table within the Oracle E-Business Suite (EBS) Public Sector Budgeting (PSB) module, which is noted as obsolete in the provided metadata. Its core function is to establish and manage a many-to-many relationship between two primary entities: budget worksheets and position lines. It acts as a matrix or association table, enabling a single budget worksheet to be linked to multiple position lines and vice versa. This structure is fundamental for complex budgeting scenarios where personnel costs, defined by positions, need to be allocated and tracked across various budget worksheets or planning exercises.

Key Information Stored

The table's structure is minimal and focused on maintaining the association. Its two critical columns form a composite primary key, ensuring each relationship is unique. The WORKSHEET_ID column stores the foreign key reference to a specific record in the PSB_WORKSHEETS table, identifying the budget worksheet involved in the association. The POSITION_LINE_ID column stores the foreign key reference to a specific record in the PSB_WS_POSITION_LINES table, identifying the detailed position budget line item. No other columns are indicated in the provided metadata, suggesting the table's sole purpose is to maintain this core relationship integrity.

Common Use Cases and Queries

The primary use case is to retrieve all position lines associated with a given budget worksheet for reporting, validation, or data aggregation. Conversely, it can identify all worksheets that reference a specific position line, which is useful for impact analysis. A typical query would join this table to its parent tables to produce a comprehensive dataset. For example, to list all position lines for a specific worksheet, a developer might use:

  • SELECT pl.* FROM psb_ws_lines_positions wlp, psb_ws_position_lines pl WHERE wlp.position_line_id = pl.position_line_id AND wlp.worksheet_id = :p_worksheet_id;

Given the module's obsolete status, direct interaction with this table is likely confined to legacy data migration, archival reporting, or supporting customizations in upgraded environments where the PSB data model remains.

Related Objects

This table is centrally connected to two core PSB tables via foreign key constraints, as documented in the ETRM metadata.

  • PSB_WORKSHEETS: The table is referenced via the column PSB_WS_LINES_POSITIONS.WORKSHEET_ID. This join connects the association to the master budget worksheet entity.
  • PSB_WS_POSITION_LINES: The table is referenced via the column PSB_WS_LINES_POSITIONS.POSITION_LINE_ID. This join connects the association to the detailed position budget line items.

The primary key constraint PSB_WS_LINES1_PK on the combination of WORKSHEET_ID and POSITION_LINE_ID enforces the uniqueness of each worksheet-to-position-line relationship.