[Home] [Help] [Dependency Information]
Object Name: | PSB_BUDGET_ACCOUNTS |
---|---|
Object Type: | TABLE |
Owner: | PSB |
FND Design Data: | PSB.PSB_BUDGET_ACCOUNTS |
Subobject Name: | |
Status: | VALID |
PSB_BUDGET_ACCOUNTS contains a list of General
Ledger CODE_COMBINATION_IDs that
belong to an account set. This list is maintained for performance
reasons. Instead of dynamically building this list every time it is
needed, this list is created and kept up-to-date using a concurrent
process.
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PSB_BUDGET_ACCOUNTS_U1 | NORMAL | UNIQUE | APPS_TS_SUMMARY |
CODE_COMBINATION_ID
ACCOUNT_POSITION_SET_ID |
PSB_BUDGET_ACCOUNTS_N1 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | ACCOUNT_POSITION_SET_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ACCOUNT_POSITION_SET_ID | NUMBER | (15) | Yes | Account position set unique identifier |
CODE_COMBINATION_ID | NUMBER | (15) | Yes | General Ledger code combination identifier |
SET_OF_BOOKS_ID | NUMBER | (15) | Yes | General Ledger Set of Books identifier |
LAST_UPDATE_DATE | DATE | Standard Who column | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Standard Who column | |
CREATED_BY | NUMBER | (15) | Standard Who column | |
CREATION_DATE | DATE | Standard Who column |
Cut, paste (and edit) the following text to query this object:
SELECT ACCOUNT_POSITION_SET_ID
, CODE_COMBINATION_ID
, SET_OF_BOOKS_ID
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, LAST_UPDATED_BY
, CREATED_BY
, CREATION_DATE
FROM PSB.PSB_BUDGET_ACCOUNTS;
PSB.PSB_BUDGET_ACCOUNTS does not reference any database object
PSB.PSB_BUDGET_ACCOUNTS is referenced by following:
|
|
|