[Home] [Help] [Dependency Information]
Object Name: | PSBBV_POSITION_COSTS |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PSB.PSBBV_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 | Position Unique identifier. |
PAY_ELEMENT_ID | NUMBER | (20) | Yes | Pay element unique identifier |
BUDGET_REVISION_ID | NUMBER | (20) | Budget revision 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 | |
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 element |
Cut, paste (and edit) the following text to query this object:
SELECT POSITION_ELEMENT_LINE_ID
, POSITION_ID
, PAY_ELEMENT_ID
, BUDGET_REVISION_ID
, BASE_LINE_VERSION
, CURRENCY_CODE
, START_DATE
, END_DATE
, ELEMENT_COST
FROM APPS.PSBBV_POSITION_COSTS;
APPS.PSBBV_POSITION_COSTS is not referenced by any database object
|
|
|