eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[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

Name
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