[Home] [Help] [Dependency Information]
Object Name: | PSB_WS_LINES_POSITIONS |
---|---|
Object Type: | TABLE |
Owner: | PSB |
FND Design Data: | PSB.PSB_WS_LINES_POSITIONS |
Subobject Name: | |
Status: | VALID |
PSB_WS_LINES_POSITIONS stores the information about which position
lines belong to which worksheet. It is the matrix table between
PSB_WORKSHEETS and PSB_WS_POSITION_LINES. When a global worksheet is
created, each position line created is assigned to the worksheet. When
a worksheet is distributed, a row is created in this table associating
the worksheet and position lines based on the definition for a budget
group. The position line information is stored only once, and
PSB_WS_LINES_POSITIONS is used to share the position lines across
multiple worksheets.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PSB_WS_LINES_POS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
WORKSHEET_ID
POSITION_LINE_ID |
PSB_WS_LINES_POS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | POSITION_LINE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
WORKSHEET_ID | NUMBER | (20) | Yes | Worksheet unique identifier |
POSITION_LINE_ID | NUMBER | (20) | Yes | Position line unique identifier |
FREEZE_FLAG | VARCHAR2 | (1) | Indicates if the position instance is frozen in the worksheet | |
VIEW_LINE_FLAG | VARCHAR2 | (1) | Indicates if the position instance can be viewed in the worksheet | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | Yes | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
CREATION_DATE | DATE | Yes | Standard Who column |
Cut, paste (and edit) the following text to query this object:
SELECT WORKSHEET_ID
, POSITION_LINE_ID
, FREEZE_FLAG
, VIEW_LINE_FLAG
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
FROM PSB.PSB_WS_LINES_POSITIONS;
PSB.PSB_WS_LINES_POSITIONS does not reference any database object
PSB.PSB_WS_LINES_POSITIONS is referenced by following:
|
|
|