[Home] [Help] [Dependency Information]
Object Name: | PSB_GL_BUDGETS |
---|---|
Object Type: | TABLE |
Owner: | PSB |
FND Design Data: | PSB.PSB_GL_BUDGETS |
Subobject Name: | |
Status: | VALID |
PSB_GL_BUDGETS stores the name of the General Ledger funding budget which belongs to a budget set. Each General Ledger funding budget is used to extract the budget balances from General Ledger during worksheet creation or to post worksheet estimates during budget journal creation. Each funding budget is mapped to account sets that specify the set of account combinations for which the funding budget is to be used.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PSB_GL_BUDGETS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | GL_BUDGET_ID |
PSB_GL_BUDGETS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | GL_BUDGET_SET_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
GL_BUDGET_ID | NUMBER | (15) | Yes | Budget identifier |
GL_BUDGET_SET_ID | NUMBER | (15) | Yes | Budget set identifier |
GL_BUDGET_VERSION_ID | NUMBER | (15) | Yes | General Ledger Budget identifier |
START_PERIOD | VARCHAR2 | (15) | Yes | General Ledger start period name |
END_PERIOD | VARCHAR2 | (15) | General Ledger end period name | |
START_DATE | DATE | Yes | Effective start date for the General Ledger budget | |
END_DATE | DATE | Effective end date for the General Ledger budget | ||
DUAL_POSTING_TYPE | VARCHAR2 | (1) | Dual posting type | |
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 GL_BUDGET_ID
, GL_BUDGET_SET_ID
, GL_BUDGET_VERSION_ID
, START_PERIOD
, END_PERIOD
, START_DATE
, END_DATE
, DUAL_POSTING_TYPE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
FROM PSB.PSB_GL_BUDGETS;
PSB.PSB_GL_BUDGETS does not reference any database object
PSB.PSB_GL_BUDGETS is referenced by following:
|
|
|