[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 |