[Home] [Help] [Dependency Information]
Object Name: | PSBFV_POSITION_COSTS |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PSB.PSBFV_POSITION_COSTS |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
POSITION_ELEMENT_LINE_ID | NUMBER | (20) | Yes | Position element cost unique identifier |
POSITION_ID | NUMBER | (20) | Yes | |
_KF:POSITION_NAME | CHAR | (20) | Position Name. | |
PAY_ELEMENT_ID | NUMBER | (20) | Yes | |
PAY_ELEMENT_NAME | VARCHAR2 | (30) | Yes | |
BUDGET_REVISION_ID | NUMBER | (20) | Budget Revision Unique identifier. | |
BUDGET_REVISION_JUSTIFICATION | VARCHAR2 | (240) | ||
BASE_LINE_REVISION | 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 | |
CURRENCY_CODE | VARCHAR2 | (15) | Yes | Currency Code |
START_DATE | DATE | Yes | Start date of the year for which the element cost is maintained | |
END_DATE | DATE | Yes | End date of the year for which the element cost is maintained | |
ELEMENT_COST | NUMBER | Yes | Cost of the Position Control elemen |
Cut, paste (and edit) the following text to query this object:
SELECT POSITION_ELEMENT_LINE_ID
, POSITION_ID
, _KF:POSITION_NAME
, PAY_ELEMENT_ID
, PAY_ELEMENT_NAME
, BUDGET_REVISION_ID
, BUDGET_REVISION_JUSTIFICATION
, BASE_LINE_REVISION
, CURRENCY_CODE
, START_DATE
, END_DATE
, ELEMENT_COST
FROM APPS.PSBFV_POSITION_COSTS;
APPS.PSBFV_POSITION_COSTS is not referenced by any database object
|
|
|