Results for “psb_ws_lines_pos_u1”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PSB.PSB_WS_LINES_POSITIONS is a PSB (Public Sector Budgeting) schema table in Oracle E-Business Suite 12.1.1 and 12.2.2. It functions as the association, or matrix, table between PSB_WORKSHEETS and PSB_WS_POSITION_LINES, storing which position lines belong to which budget worksheet. When a global worksheet is created, each position line is assigned to that worksheet. When a worksheet is distributed, a row is inserted into this table associating the worksheet and position lines according to the budget group definition. Position line information is stored only once, and PSB_WS_LINES_POSITIONS enables sharing of those position lines across multiple worksheets without duplication.

The table resides in the APPS_TS_TX_DATA tablespace with a PCTFREE of 10. From a data modeling perspective, the metadata suggests this object is best treated as a link table: it resolves the many-to-many relationship between worksheets and position lines and contains no independent descriptive hierarchy of its own. The operational columns FREEZE_FLAG and VIEW_LINE_FLAG are attributes of the association itself rather than of either parent entity, which is consistent with a link classification.

Key Information Stored

The table contains nine documented columns. The two principal foreign key columns form both the business key and the physical primary key:

• WORKSHEET_ID (NUMBER(20), mandatory) — unique identifier of the worksheet; foreign key to PSB_WORKSHEETS.
• POSITION_LINE_ID (NUMBER(20), mandatory) — unique identifier of the position line; foreign key to PSB_WS_POSITION_LINES.
• FREEZE_FLAG (VARCHAR2) — indicates whether the position instance is frozen within the worksheet, preventing update during worksheet processing.
• VIEW_LINE_FLAG (VARCHAR2) — indicates whether the position instance can be viewed in the worksheet.
• LAST_UPDATE_DATE (DATE) — standard Who column recording the last modification timestamp.
• LAST_UPDATED_BY (NUMBER) — standard Who column identifying the last updating user.
• LAST_UPDATE_LOGIN (NUMBER) — standard Who column capturing the login session of the last update.
• CREATED_BY (NUMBER(15)) — standard Who column identifying the creating user.
• CREATION_DATE (DATE) — standard Who column recording row creation time.

The composite primary key is PSB_WS_LINES1_PK on (WORKSHEET_ID, POSITION_LINE_ID). The unique index PSB_WS_LINES_POS_U1 covers the same two columns in APPS_TS_TX_IDX and is the documented business-key candidate that enforces one association per worksheet/position-line pair. A second, non-unique index PSB_WS_LINES_POS_N1 on POSITION_LINE_ID supports lookups that start from the position line side of the relationship.

Common Use Cases and Queries

Typical scenarios include reporting which position lines appear on a given worksheet, auditing worksheet distribution results, and identifying frozen or hidden position instances. A standard reporting pattern joins to both parents:

• List position lines for a given worksheet: SELECT WORKSHEET_ID, POSITION_LINE_ID, FREEZE_FLAG, VIEW_LINE_FLAG FROM PSB.PSB_WS_LINES_POSITIONS WHERE WORKSHEET_ID = :p_worksheet_id;
• Find all worksheets sharing a position line: SELECT WORKSHEET_ID FROM PSB.PSB_WS_LINES_POSITIONS WHERE POSITION_LINE_ID = :p_position_line_id; — this query is served efficiently by PSB_WS_LINES_POS_N1.
• Detect frozen instances: filter on FREEZE_FLAG = 'Y' to identify position instances that should not be modified.
• Distribution audit: join to PSB_WORKSHEETS and PSB_WS_POSITION_LINES to confirm that distributed worksheets received the expected position lines based on budget group definitions.

Related Objects

The following objects are the most significant relationships for this table, based on documented foreign key and dependency metadata:

• PSB.PSB_WORKSHEETS — referenced through WORKSHEET_ID; the parent worksheet definition.
• PSB.PSB_WS_POSITION_LINES — referenced through POSITION_LINE_ID; the parent position line definition that is shared across worksheets.
• APPS — the table is referenced by the APPS schema objects (views and PL/SQL packages) that surface budgeting worksheet data.
• PSB budget group definitions — drive the rows created during worksheet distribution, indirectly linking this table to the distribution process.

Because position lines are stored once and shared, this table is central to any inquiry that reconciles worksheet membership against the underlying position line records in Public Sector Budgeting.