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_ORGVW_GE_V
Product: PA - Projects
Description: PA_REP_UTIL_ORGVW_GE_V is a view to provide Capacity and Total Hours values for organizations across Global Week. This information is used by Disco Workbooks.
Implementation/DBA Data:
APPS.PA_REP_UTIL_ORGVW_GE_V
View Text
SELECT PAOBJ.EXPENDITURE_ORGANIZATION_ID AS EXPENDITURE_ORGANIZATION_ID , HRORGTL.NAME AS EXPENDITURE_ORGANIZATION_NAME , SUMMBAL.GLOBAL_EXP_PERIOD_END_DATE AS EXP_END_DATE , SUMMBAL.QUARTER_OR_MONTH_NUMBER AS PERIOD_MONTH , SUMMBAL.PERIOD_YEAR AS PERIOD_YEAR , LKUPB.MEANING AS BALANCE_TYPE_NAME , PAOBJ.BALANCE_TYPE_CODE AS BALANCE_TYPE_CODE , MAX(CASE WHEN SUMMBAL.AMOUNT_TYPE_ID = 31 THEN NVL(SUMMBAL.PERIOD_BALANCE , 0) ELSE 0 END) AS TOTAL_HOURS , DECODE( SIGN( MAX(CASE WHEN SUMMBAL.AMOUNT_TYPE_ID = 37 THEN NVL(SUMMBAL.PERIOD_BALANCE , 0) ELSE 0 END) - MAX(CASE WHEN SUMMBAL.AMOUNT_TYPE_ID = 38 THEN NVL(SUMMBAL.PERIOD_BALANCE , 0) ELSE 0 END)) , 1 , MAX(CASE WHEN SUMMBAL.AMOUNT_TYPE_ID = 37 THEN NVL(SUMMBAL.PERIOD_BALANCE , 0) ELSE 0 END) - MAX(CASE WHEN SUMMBAL.AMOUNT_TYPE_ID = 38 THEN NVL(SUMMBAL.PERIOD_BALANCE , 0) ELSE 0 END) , +0) AS CAPACITY FROM PA_SUMM_BALANCES SUMMBAL , PA_LOOKUPS LKUPB , PA_OBJECTS PAOBJ , HR_ALL_ORGANIZATION_UNITS_TL HRORGTL , HR_ORG_UNITS_NO_JOIN HRORGNJ WHERE LKUPB.LOOKUP_TYPE = 'PA_BALANCE_TYPES' AND LKUPB.LOOKUP_CODE IN (PA_REP_UTIL_GLOB.GETBALTYPEACTUALS , PA_REP_UTIL_GLOB.GETBALTYPEFORECAST) AND HRORGNJ.ORGANIZATION_ID(+) = PAOBJ.EXPENDITURE_ORGANIZATION_ID AND HRORGNJ.ORGANIZATION_ID = HRORGTL.ORGANIZATION_ID(+) AND DECODE(HRORGTL.ORGANIZATION_ID , NULL , '1' , HRORGTL.LANGUAGE) = DECODE(HRORGTL.ORGANIZATION_ID , NULL , '1' , USERENV('LANG')) AND SUMMBAL.PERIOD_TYPE = PA_REP_UTIL_GLOB.GETPERIODTYPEGE AND SUMMBAL.OBJECT_TYPE_CODE = PA_REP_UTIL_GLOB.GETOBJECTTYPEORG AND SUMMBAL.AMOUNT_TYPE_ID IN ( 31 /* G_ORG_TOT_HRS_C */ , 37 /* G_ORG_TOT_CAP_C */ , 38 /* G_ORG_TOT_REDUCEDCAP_C */ ) AND SUMMBAL.PERIOD_SET_NAME = PA_REP_UTIL_GLOB.GETDUMMY AND SUMMBAL.VERSION_ID = -1 AND SUMMBAL.OBJECT_TYPE_CODE = PAOBJ.OBJECT_TYPE_CODE AND PAOBJ.OBJECT_ID = SUMMBAL.OBJECT_ID AND PAOBJ.OBJECT_TYPE_CODE = SUMMBAL.OBJECT_TYPE_CODE AND PAOBJ.BALANCE_TYPE_CODE = LKUPB.LOOKUP_CODE AND PAOBJ.PROJECT_ORG_ID = -1 AND PAOBJ.PROJECT_ORGANIZATION_ID = -1 AND PAOBJ.PROJECT_ID = -1 AND PAOBJ.TASK_ID = -1 AND NVL(PAOBJ.EXPENDITURE_ORG_ID , NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO') , 1 , 1) , ' ' , NULL , SUBSTRB(USERENV('CLIENT_INFO') , 1 , 10))) , -99) ) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO') , 1 , 1) , ' ' , NULL , SUBSTRB(USERENV('CLIENT_INFO') , 1 , 10))) , -99) AND PAOBJ.PERSON_ID = -1 AND PAOBJ.WORK_TYPE_ID = -1 AND PAOBJ.ORG_UTIL_CATEGORY_ID = -1 AND PAOBJ.RES_UTIL_CATEGORY_ID = -1 GROUP BY PAOBJ.EXPENDITURE_ORGANIZATION_ID , HRORGTL.NAME , SUMMBAL.GLOBAL_EXP_PERIOD_END_DATE , SUMMBAL.QUARTER_OR_MONTH_NUMBER , SUMMBAL.PERIOD_YEAR , LKUPB.MEANING , PAOBJ.BALANCE_TYPE_CODE
Columns
Name
EXPENDITURE_ORGANIZATION_ID
EXPENDITURE_ORGANIZATION_NAME
EXP_END_DATE
PERIOD_MONTH
PERIOD_YEAR
BALANCE_TYPE_NAME
BALANCE_TYPE_CODE
TOTAL_HOURS
CAPACITY