[Home] [Help]
View: PA_TASK_DET_EFFORT_COST
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
, PA_PLANNING_TRANSACTION_UTILS.GET_EFFORT( PPV.ELEMENT_VERSION_ID
, PPV.PARENT_STRUCTURE_VERSION_ID
, 'PLANNED'
, 'PEOPLE'
, 'EFFORT' )
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, PL.MEANING
, PPA.PROJECT_CURRENCY_CODE
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
PROJECT_ID |
ELEMENT_VERSION_ID |
PROJ_ELEMENT_ID |
OBJECT_TYPE |
PARENT_STRUCTURE_VERSION_ID |
PLANNED_EFFORT |
ACTUAL_EFFORT_TO_DATE |
PERCENT_COMPLETE_EFFORT |
PERCENT_SPENT_EFFORT |
ETC_EFFORT |
EAC_EFFORT |
PLANNED_COST |
ACTUAL_COST_TO_DATE |
PERCENT_COMPLETE_COST |
PERCENT_SPENT_COST |
ETC_COST |
EAC_COST |
HOURS |
PROJECT_CURRENCY_CODE |
Name |