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_FCT_RUCR_PA_V
Product: PA - Projects
Description: PA_REP_UTIL_FCT_RUCR_PA_V is a view to provide Forecast Capacity and Total Forecast Hours values for Person Resources by utilization category across PA Periods. This information is used by OA Screens.
Implementation/DBA Data:
APPS.PA_REP_UTIL_FCT_RUCR_PA_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 PROVISIONAL_HOURS */ , SUM( DECODE(SUMMBAL.AMOUNT_TYPE_ID , 4 , NVL(SUMMBAL.PERIOD_BALANCE , 0) , +0)) AS PROVISIONAL_HOURS /* * FIELD BELOW IS FOR CONFIRMED_HOURS */ , SUM( DECODE(SUMMBAL.AMOUNT_TYPE_ID , 1 , NVL(SUMMBAL.PERIOD_BALANCE , 0) , +0)) -SUM( DECODE(SUMMBAL.AMOUNT_TYPE_ID , 4 , NVL(SUMMBAL.PERIOD_BALANCE , 0) , +0)) AS CONFIRMED_HOURS /* * FIELD BELOW IS FOR UTILIZATION */ , ROUND(NVL( (SUM( DECODE(SUMMBAL.AMOUNT_TYPE_ID , 3 , NVL(SUMMBAL.PERIOD_BALANCE , 0) , +0)) -SUM( DECODE(SUMMBAL.AMOUNT_TYPE_ID , 6 , NVL(SUMMBAL.PERIOD_BALANCE , 0) , +0)))*100/ PA_REP_UTIL_SCREEN.CALCULATE_CAPACITY( PA_REP_UTIL_GLOB.GETORGID , PA_REP_UTIL_GLOB.GETBALTYPEFORECAST , 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.GETPERIODTYPEPA 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 */ , 4 /* G_RES_PRVHRS */ , 6 /* G_RES_PRVWTDHRS_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.GETBALTYPEFORECAST 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
PROVISIONAL_HOURS
CONFIRMED_HOURS
UTILIZATION
REPORTING_ORDER