[Home] [Help] [Dependency Information]
Object Name: | PSBBV_POSITION_ACCOUNTS |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PSB.PSBBV_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 | Position unique identifier |
BUDGET_REVISION_ID | NUMBER | (20) | Budget revision unique identifier | |
BUDGET_GROUP_ID | NUMBER | Yes | Budget group unique identifier | |
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 unique identifier |
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
, BUDGET_REVISION_ID
, BUDGET_GROUP_ID
, BASE_LINE_VERSION
, START_DATE
, END_DATE
, CODE_COMBINATION_ID
, CURRENCY_CODE
, AMOUNT
FROM APPS.PSBBV_POSITION_ACCOUNTS;
APPS.PSBBV_POSITION_ACCOUNTS is not referenced by any database object
|
|
|