[Home] [Help] [Dependency Information]
Object Name: | PSB_BUDGET_REVISION_LINES |
---|---|
Object Type: | TABLE |
Owner: | PSB |
FND Design Data: | PSB.PSB_BUDGET_REVISION_LINES |
Subobject Name: | |
Status: | VALID |
PSB_BUDGET_REVISION_LINES stores the mapping of budget revision lines to budget revisions. It is the matrix table between PSB_BUDGET_REVISIONS and PSB_BUDGET_REVISION_ACCOUNTS. When a global budget revision is created, each transactional account line created is assigned to the budget revision. When a budget revision is distributed, a row is created in this table associating the budget revision and account lines based on the range of account definition for a budget group.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PSB_BUDGET_REVISION_LINES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
BUDGET_REVISION_ID
BUDGET_REVISION_ACCT_LINE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BUDGET_REVISION_ACCT_LINE_ID | NUMBER | (20) | Yes | Budget revision account line unique identifier |
BUDGET_REVISION_ID | NUMBER | (20) | Yes | Budget revision unique identifier |
FREEZE_FLAG | VARCHAR2 | (1) | Indicates if the budget revision account line is frozen | |
VIEW_LINE_FLAG | VARCHAR2 | (1) | Indicates if the budget revision account line can be viewed | |
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 BUDGET_REVISION_ACCT_LINE_ID
, BUDGET_REVISION_ID
, FREEZE_FLAG
, VIEW_LINE_FLAG
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
FROM PSB.PSB_BUDGET_REVISION_LINES;
PSB.PSB_BUDGET_REVISION_LINES does not reference any database object
PSB.PSB_BUDGET_REVISION_LINES is referenced by following:
|
|
|