[Home] [Help]
View: FII_PROJ_TOP_TASK_LCV
| Product: | FII - Financial Intelligence |
| Description: | FII_PROJ_TOP_TASK_LCV is the Project Top Task level source view for the Project dimension in EDW |
| Implementation/DBA Data: |
APPS.FII_PROJ_TOP_TASK_LCV
|
View Text
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
, NULL
, NULL
, NULL
, NULL
, NULL
FROM FIIBV_PROJ_TOP_TASK_LCV
Columns
| Name |
| 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 |
| USER_ATTRIBUTE1 |
| USER_ATTRIBUTE2 |
| USER_ATTRIBUTE3 |
| USER_ATTRIBUTE4 |
| USER_ATTRIBUTE5 |