[Home] [Help] [Dependency Information]
Object Name: | PSBFV_POSITION_ACCOUNTS |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PSB.PSBFV_POSITION_ACCOUNTS |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
POSITION_ACCOUNT_LINE_ID | NUMBER | (15) | Yes | Unique identifier for Position Control account distributions |
POSITION_ID | NUMBER | (20) | Yes | |
_KF:POSITION_NAME | CHAR | (20) | Position Name. | |
BUDGET_REVISION_ID | NUMBER | (20) | Budget Revision Unique Identifier. | |
BUDGET_REVISION_JUSTIFICATION | VARCHAR2 | (240) | ||
BUDGET_GROUP_ID | NUMBER | Yes | ||
BUDGET_GROUP_SHORT_NAME | VARCHAR2 | (20) | Yes | Budget Group short name . |
BASE_LINE_VERSION | VARCHAR2 | (1) | Indicates if the values were originally posted in budget preparation phase or the current values from budget revisions. Valid values are 'O' - original and 'C' - current | |
START_DATE | DATE | Yes | Start date of the year for which the cost distribution is maintained | |
END_DATE | DATE | Yes | End date of the year for which the cost distribution is maintained | |
CODE_COMBINATION_ID | NUMBER | (20) | Yes | General ledger code combination identifier. |
_KF:GL_ACCOUNT | CHAR | (17) | ||
CURRENCY_CODE | VARCHAR2 | (15) | Yes | Currency of the position control distribution amount |
AMOUNT | NUMBER | Yes | Position Control annual distribution amount for the position for the account combination |
Cut, paste (and edit) the following text to query this object:
SELECT POSITION_ACCOUNT_LINE_ID
, POSITION_ID
, _KF:POSITION_NAME
, BUDGET_REVISION_ID
, BUDGET_REVISION_JUSTIFICATION
, BUDGET_GROUP_ID
, BUDGET_GROUP_SHORT_NAME
, BASE_LINE_VERSION
, START_DATE
, END_DATE
, CODE_COMBINATION_ID
, _KF:GL_ACCOUNT
, CURRENCY_CODE
, AMOUNT
FROM APPS.PSBFV_POSITION_ACCOUNTS;
APPS.PSBFV_POSITION_ACCOUNTS is not referenced by any database object
|
|
|