[Home] [Help] [Dependency Information]
Object Name: | FIIBV_PROJ_TASK_LCV |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | FII.FIIBV_PROJ_TASK_LCV |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
FIIBV_PROJ_TASK_LCV is the Project Task level base view for the Project dimension in EDW
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TASK_PK | VARCHAR2 | (78) | The unique identifier for the task | |
NAME | VARCHAR2 | (47) | Task name | |
TASK | VARCHAR2 | (30) | Task name | |
TASK_NUMBER | VARCHAR2 | (25) | Task Number | |
TOP_TASK_FK | VARCHAR2 | (78) | Foreign key to the top task level | |
INSTANCE | VARCHAR2 | (30) | Instance identifier | |
TASK_START_DATE | DATE | The date on which the task starts | ||
TASK_END_DATE | DATE | The date on which the task is completed | ||
SERVICE_TYPE_CODE | VARCHAR2 | (30) | The type of work performed on the task | |
LABOR_COST_MULT | VARCHAR2 | (20) | The labor cost multiplier defined for the task of a premium project | |
DENORM_TASK_ORG_FK | VARCHAR2 | (71) | This column is used internally | |
LAST_UPDATE_DATE | DATE | Standard Who column - date when a user last updated this row. | ||
_DF:TSK:_EDW | VARCHAR2 | (35) | This column is for internal use only |
Cut, paste (and edit) the following text to query this object:
SELECT TASK_PK
, NAME
, TASK
, TASK_NUMBER
, TOP_TASK_FK
, INSTANCE
, TASK_START_DATE
, TASK_END_DATE
, SERVICE_TYPE_CODE
, LABOR_COST_MULT
, DENORM_TASK_ORG_FK
, LAST_UPDATE_DATE
, _DF:TSK:_EDW
FROM APPS.FIIBV_PROJ_TASK_LCV;
|
|
|