[Home] [Help] [Dependency Information]
Object Name: | PSBFV_BUDGET_REVISION_ACCOUNTS |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PSB.PSBFV_BUDGET_REVISION_ACCOUNTS |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BUDGET_REVISION_ID | NUMBER | (20) | Yes | |
BUDGET_REVISION_JUSTIFICATION | VARCHAR2 | (240) | ||
BUDGET_REVISION_ACCT_LINE_ID | NUMBER | (20) | Yes | |
CODE_COMBINATION_ID | NUMBER | (20) | Yes | |
_KF:GL_ACCOUNT | CHAR | (17) | ||
BUDGET_GROUP_ID | NUMBER | (20) | Yes | |
BUDGET_GROUP_SHORT_NAME | VARCHAR2 | (20) | Yes | |
GL_PERIOD_NAME | VARCHAR2 | (15) | Yes | |
GL_BUDGET_VERSION_ID | NUMBER | (20) | ||
GL_BUDGET_NAME | VARCHAR2 | (15) | Yes | |
CURRENCY_CODE | VARCHAR2 | (15) | ||
_LA:ACCOUNT_TYPE | CHAR | (53) | ||
BUDGET_BALANCE | NUMBER | |||
ACTUAL_BALANCE | NUMBER | |||
ENCUMBRANCE_BALANCE | NUMBER | |||
REVISION_TYPE | VARCHAR2 | (1) | ||
REVISION_VALUE_TYPE | VARCHAR2 | (1) | ||
REVISION_AMOUNT | NUMBER | |||
FUNDS_CONTROL_STATUS_CODE | VARCHAR2 | (1) | ||
FUNDS_CONTROL_RESULTS_CODE | VARCHAR2 | (3) | ||
FUNDS_CONTROL_TIMESTAMP | DATE | |||
FREEZE_FLAG | VARCHAR2 | (1) | ||
NOTE_ID | NUMBER | |||
NOTE | VARCHAR2 | (4000) |
Cut, paste (and edit) the following text to query this object:
SELECT BUDGET_REVISION_ID
, BUDGET_REVISION_JUSTIFICATION
, BUDGET_REVISION_ACCT_LINE_ID
, CODE_COMBINATION_ID
, _KF:GL_ACCOUNT
, BUDGET_GROUP_ID
, BUDGET_GROUP_SHORT_NAME
, GL_PERIOD_NAME
, GL_BUDGET_VERSION_ID
, GL_BUDGET_NAME
, CURRENCY_CODE
, _LA:ACCOUNT_TYPE
, BUDGET_BALANCE
, ACTUAL_BALANCE
, ENCUMBRANCE_BALANCE
, REVISION_TYPE
, REVISION_VALUE_TYPE
, REVISION_AMOUNT
, FUNDS_CONTROL_STATUS_CODE
, FUNDS_CONTROL_RESULTS_CODE
, FUNDS_CONTROL_TIMESTAMP
, FREEZE_FLAG
, NOTE_ID
, NOTE
FROM APPS.PSBFV_BUDGET_REVISION_ACCOUNTS;
APPS.PSBFV_BUDGET_REVISION_ACCOUNTS is not referenced by any database object
|
|
|