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_REP_UTIL_ACT_RUCR_GE_V
Product: PA - Projects
Description: PA_REP_UTIL_ACT_RUCR_GE_V is a view to provide Total Actual Hours values for Person Resources by utilization category across Global Week. This information is used by OA Screens.
Implementation/DBA Data:
APPS.PA_REP_UTIL_ACT_RUCR_GE_V
View Text
SELECT PAUTL.NAME AS UTILIZATION_CATEGORY_NAME , PAOBJ.RES_UTIL_CATEGORY_ID AS UTILIZATION_CATEGORY_ID , PAOBJ.PERSON_ID AS PERSON_ID , SUM( DECODE(SUMMBAL.AMOUNT_TYPE_ID , 1 , NVL(SUMMBAL.PERIOD_BALANCE , 0) , +0)) AS WORKED_HOURS , ROUND(NVL( SUM( DECODE(SUMMBAL.AMOUNT_TYPE_ID , 3 , NVL(SUMMBAL.PERIOD_BALANCE , 0) , +0))*100/ PA_REP_UTIL_SCREEN.CALCULATE_CAPACITY( PA_REP_UTIL_GLOB.GETORGID , PA_REP_UTIL_GLOB.GETBALTYPEACTUALS , MAX(PAOBJ.PERSON_ID) , MAX(SUMMBAL.VERSION_ID) , MAX(SUMMBAL.PERIOD_TYPE) , MAX(SUMMBAL.PERIOD_SET_NAME) , MAX(SUMMBAL.PERIOD_NAME) , MAX(SUMMBAL.GLOBAL_EXP_PERIOD_END_DATE) , 1 , 9 , 10 , PA_REP_UTIL_GLOB.GETUTILCALCMETHOD) , -9999) , 0) AS UTILIZATION , PAUTL.REPORTING_ORDER AS REPORTING_ORDER FROM PA_SUMM_BALANCES SUMMBAL , PA_OBJECTS PAOBJ , PA_UTIL_CATEGORIES_V PAUTL WHERE PAUTL.UTIL_CATEGORY_ID = PAOBJ.RES_UTIL_CATEGORY_ID AND SUMMBAL.OBJECT_ID = PAOBJ.OBJECT_ID AND SUMMBAL.VERSION_ID = -1 AND SUMMBAL.PERIOD_TYPE = PA_REP_UTIL_GLOB.GETPERIODTYPEGE AND SUMMBAL.PERIOD_SET_NAME = PA_REP_UTIL_GLOB.GETDUMMY AND SUMMBAL.PERIOD_NAME = PA_REP_UTIL_GLOB.GETDUMMY AND SUMMBAL.GLOBAL_EXP_PERIOD_END_DATE = TO_DATE(PA_REP_UTIL_GLOB.GETU3GEENDDATE , 'MM/DD/YYYY') AND SUMMBAL.AMOUNT_TYPE_ID IN ( 1 , 3 ) AND SUMMBAL.OBJECT_TYPE_CODE = PA_REP_UTIL_GLOB.GETOBJECTTYPERESUCR AND PAOBJ.OBJECT_TYPE_CODE = PA_REP_UTIL_GLOB.GETOBJECTTYPERESUCR AND PAOBJ.EXPENDITURE_ORG_ID = PA_REP_UTIL_GLOB.GETORGID AND PAOBJ.PROJECT_ORG_ID = -1 AND PAOBJ.PROJECT_ORGANIZATION_ID = -1 AND PAOBJ.PROJECT_ID = -1 AND PAOBJ.TASK_ID = -1 AND PAOBJ.ASSIGNMENT_ID = -1 AND PAOBJ.WORK_TYPE_ID = -1 AND PAOBJ.ORG_UTIL_CATEGORY_ID = -1 AND PAOBJ.BALANCE_TYPE_CODE = PA_REP_UTIL_GLOB.GETBALTYPEACTUALS GROUP BY PAUTL.REPORTING_ORDER , PAOBJ.PERSON_ID , PAUTL.NAME , PAOBJ.RES_UTIL_CATEGORY_ID
Columns
Name
UTILIZATION_CATEGORY_NAME
UTILIZATION_CATEGORY_ID
PERSON_ID
WORKED_HOURS
UTILIZATION
REPORTING_ORDER