[Home] [Help]
View: PA_TASK_DET_EARNED_VALUES
| Product: | PA - Projects |
|---|
| Description: | |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT PPV.PROJECT_ID
, PPV.ELEMENT_VERSION_ID
, PPV.PROJ_ELEMENT_ID
, PPV.OBJECT_TYPE
, PPV.PARENT_STRUCTURE_VERSION_ID
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_DATE(NULL)
, PL.MEANING
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, PPA.PROJECT_CURRENCY_CODE
, TO_CHAR(NULL)
FROM PA_PROJECTS_ALL PPA
, PA_PROJ_ELEMENT_VERSIONS PPV
, PA_LOOKUPS PL
WHERE PPA.PROJECT_ID = PPV.PROJECT_ID
AND PL.LOOKUP_TYPE = 'UNIT'
AND PL.LOOKUP_CODE = 'HOURS'
Columns
| Name |
| PROJECT_ID |
| ELEMENT_VERSION_ID |
| PROJ_ELEMENT_ID |
| OBJECT_TYPE |
| PARENT_STRUCTURE_VERSION_ID |
| PERCENT_COMPLETE_ID |
| BUDGETED_COST_OF_WORK_SCHEDULE |
| SCHEDULE_PERFORMANCE_INDEX |
| ESTIMATE_AT_COMPLETION |
| PHYSICAL_PERCENT_COMPLETE |
| EARNED_VALUE |
| COST_PERFORMANCE_INDEX |
| SCHEDULE_AT_COMPLETION |
| HOURS |
| SCHEDULE_VARIANCE |
| COST_VARIANCE |
| PROJECT_CURRENCY_CODE |
| PROGRESS_ROLLUP_METHOD |