View: PA_REP_UTIL_ACT_RUCR_PA_V

Product:	PA - Projects
Description:	PA_REP_UTIL_ACT_RUCR_PA_V is a view to provide Total Actual Hours value s for Person Resources by utilization category across PA Periods. This informat ion is used by OA Screens.
Implementation/DBA Data:	APPS.PA_REP_UTIL_ACT_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 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.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 */ )
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