[Home] [Help] [Dependency Information]
Object Name: | PSB_WS_LINES |
---|---|
Object Type: | TABLE |
Owner: | PSB |
FND Design Data: | PSB.PSB_WS_LINES |
Subobject Name: | |
Status: | VALID |
PSB_WS_LINES stores the information about which account lines belong
to which worksheet. It is the matrix table between PSB_WORKSHEETS and
PSB_WS_ACCOUNT_LINES. When a global worksheet is created, each account
line created is assigned to the worksheet. When a worksheet is
distributed, a row is created in this table associating the worksheet
and account lines based on the range of account definition for a
budget group. The account line information is stored only once, and
PSB_WS_LINES is used to share the account lines across multiple
worksheets.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PSB_WS_LINES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
WORKSHEET_ID
ACCOUNT_LINE_ID |
PSB_WS_LINES_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ACCOUNT_LINE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
WORKSHEET_ID | NUMBER | (20) | Yes | Worksheet unique identifier |
ACCOUNT_LINE_ID | NUMBER | (20) | Yes | Account line unique identifier |
FREEZE_FLAG | VARCHAR2 | (1) | Indicates if the account line is frozen in the worksheet | |
VIEW_LINE_FLAG | VARCHAR2 | (1) | Indicates if the account line can be viewed in the worksheet | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | 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
, ACCOUNT_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;
PSB.PSB_WS_LINES does not reference any database object
PSB.PSB_WS_LINES is referenced by following:
|
|
|