[Home] [Help] [Dependency Information]
Object Name: | FIIBV_PROJ_TOP_TASK_LCV |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | FII.FIIBV_PROJ_TOP_TASK_LCV |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
FIIBV_PROJ_TOP_TASK_LCV is the Project Top Task Level base view for Project
dimension in EDW.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TOP_TASK_PK | VARCHAR2 | (78) | The unique identifier for the top task | |
NAME | VARCHAR2 | (47) | Top task name | |
TOP_TASK | VARCHAR2 | (30) | Top task name | |
TASK_NUMBER | VARCHAR2 | (25) | Task Number | |
PROJECT_FK | VARCHAR2 | (74) | Foreign key to the project 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 completes | ||
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 | |
LAST_UPDATE_DATE | DATE | Standard Who column - date when a user last updated this row. | ||
_DF:TSK:_EDW | VARCHAR2 | (34) | This column is for internal use only |
Cut, paste (and edit) the following text to query this object:
SELECT TOP_TASK_PK
, NAME
, TOP_TASK
, TASK_NUMBER
, PROJECT_FK
, INSTANCE
, TASK_START_DATE
, TASK_END_DATE
, SERVICE_TYPE_CODE
, LABOR_COST_MULT
, LAST_UPDATE_DATE
, _DF:TSK:_EDW
FROM APPS.FIIBV_PROJ_TOP_TASK_LCV;
|
|
|