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_GL_V
Product: PA - Projects
Description: PA_REP_UTIL_ACT_RUCR_GL_V is a view to provide Total Actual Hours values for Person Resources by utilization category across GL Periods. This information is used by OA Screens.
Implementation/DBA Data:
APPS.PA_REP_UTIL_ACT_RUCR_GL_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 /* * FIELD BELOW IS FOR WORKED_HOURS */ , SUM( DECODE(SUMMBAL.AMOUNT_TYPE_ID , 1 , NVL(SUMMBAL.PERIOD_BALANCE , 0) , +0)) AS WORKED_HOURS /* * FIELD BELOW IS FOR UTILIZATION */ , 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) /* FINISHED NVL */ , 0) AS UTILIZATION /* FINISHED ROUNDING AND CONCATENATION */ , 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.GETPERIODTYPEGL AND SUMMBAL.PERIOD_SET_NAME = PA_REP_UTIL_GLOB.GETPERIODSETNAME AND SUMMBAL.PERIOD_NAME = PA_REP_UTIL_GLOB.GETU3PERIODNAME AND SUMMBAL.GLOBAL_EXP_PERIOD_END_DATE = PA_REP_UTIL_GLOB.GETDUMMYDATE AND SUMMBAL.AMOUNT_TYPE_ID IN ( 1 /* G_RES_HRS_C */ , 3 /* G_RES_WTDHRS_PEOPLE_C */ ) 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