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.

VIEW: APPS.PA_REP_UTIL_OWTVW_PA_V

Source

View Text - Preformatted


SELECT paobj.expenditure_organization_id AS expenditure_organization_id , paobj.org_util_category_id AS org_util_category_id , ucatg.name AS org_util_category_name , ucatg.reporting_order AS org_reporting_order , paobj.work_type_id AS work_type_id , uwkty.name AS work_type_name , summbal.period_name AS period_name , summbal.period_num AS period_num , glprd.start_date AS period_start_date , glprd.end_date AS period_end_date , summbal.quarter_or_month_number AS period_quarter , summbal.period_year AS period_year , 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 , max(case when summbal.amount_type_id = 32 then NVL(summbal.period_balance,0) else 0 end) AS total_weighted_hours from PA_SUMM_BALANCES summbal , gl_periods glprd , PA_Util_Categories_V ucatg , PA_Work_Types_TL uwkty , PA_Objects paobj WHERE uwkty.language = userenv('LANG') AND glprd.period_set_name = summbal.period_set_name AND glprd.period_name = summbal.period_name AND summbal.period_type = PA_REP_UTIL_GLOB.GetPeriodTypePa AND summbal.object_type_code = PA_REP_UTIL_GLOB.GetObjectTypeOrgWt AND summbal.amount_type_id in ( 31 /* G_ORG_TOT_HRS_C */ , 32 /* G_ORG_TOT_WTDHRS_ORG_C */ ) AND summbal.period_set_name = PA_REP_UTIL_GLOB.GetPeriodSetName AND summbal.version_id = -1 AND paobj.object_id = summbal.object_id AND paobj.object_type_code = summbal.object_type_code AND paobj.balance_type_code in (PA_REP_UTIL_GLOB.GetBalTypeActuals,PA_REP_UTIL_GLOB.GetBalTypeForecast) 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 = uwkty.work_type_id AND paobj.org_util_category_id = ucatg.util_category_id AND paobj.res_util_category_id = -1 group by paobj.expenditure_organization_id , paobj.org_util_category_id , ucatg.name , ucatg.reporting_order , paobj.work_type_id , uwkty.name , summbal.period_name , summbal.period_num , glprd.start_date , glprd.end_date , summbal.quarter_or_month_number , summbal.period_year , paobj.balance_type_code

View Text - HTML Formatted

SELECT PAOBJ.EXPENDITURE_ORGANIZATION_ID AS EXPENDITURE_ORGANIZATION_ID
, PAOBJ.ORG_UTIL_CATEGORY_ID AS ORG_UTIL_CATEGORY_ID
, UCATG.NAME AS ORG_UTIL_CATEGORY_NAME
, UCATG.REPORTING_ORDER AS ORG_REPORTING_ORDER
, PAOBJ.WORK_TYPE_ID AS WORK_TYPE_ID
, UWKTY.NAME AS WORK_TYPE_NAME
, SUMMBAL.PERIOD_NAME AS PERIOD_NAME
, SUMMBAL.PERIOD_NUM AS PERIOD_NUM
, GLPRD.START_DATE AS PERIOD_START_DATE
, GLPRD.END_DATE AS PERIOD_END_DATE
, SUMMBAL.QUARTER_OR_MONTH_NUMBER AS PERIOD_QUARTER
, SUMMBAL.PERIOD_YEAR AS PERIOD_YEAR
, 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
, MAX(CASE WHEN SUMMBAL.AMOUNT_TYPE_ID = 32 THEN NVL(SUMMBAL.PERIOD_BALANCE
, 0) ELSE 0 END) AS TOTAL_WEIGHTED_HOURS
FROM PA_SUMM_BALANCES SUMMBAL
, GL_PERIODS GLPRD
, PA_UTIL_CATEGORIES_V UCATG
, PA_WORK_TYPES_TL UWKTY
, PA_OBJECTS PAOBJ
WHERE UWKTY.LANGUAGE = USERENV('LANG')
AND GLPRD.PERIOD_SET_NAME = SUMMBAL.PERIOD_SET_NAME
AND GLPRD.PERIOD_NAME = SUMMBAL.PERIOD_NAME
AND SUMMBAL.PERIOD_TYPE = PA_REP_UTIL_GLOB.GETPERIODTYPEPA
AND SUMMBAL.OBJECT_TYPE_CODE = PA_REP_UTIL_GLOB.GETOBJECTTYPEORGWT
AND SUMMBAL.AMOUNT_TYPE_ID IN ( 31 /* G_ORG_TOT_HRS_C */
, 32 /* G_ORG_TOT_WTDHRS_ORG_C */ )
AND SUMMBAL.PERIOD_SET_NAME = PA_REP_UTIL_GLOB.GETPERIODSETNAME
AND SUMMBAL.VERSION_ID = -1
AND PAOBJ.OBJECT_ID = SUMMBAL.OBJECT_ID
AND PAOBJ.OBJECT_TYPE_CODE = SUMMBAL.OBJECT_TYPE_CODE
AND PAOBJ.BALANCE_TYPE_CODE IN (PA_REP_UTIL_GLOB.GETBALTYPEACTUALS
, PA_REP_UTIL_GLOB.GETBALTYPEFORECAST)
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 = UWKTY.WORK_TYPE_ID
AND PAOBJ.ORG_UTIL_CATEGORY_ID = UCATG.UTIL_CATEGORY_ID
AND PAOBJ.RES_UTIL_CATEGORY_ID = -1 GROUP BY PAOBJ.EXPENDITURE_ORGANIZATION_ID
, PAOBJ.ORG_UTIL_CATEGORY_ID
, UCATG.NAME
, UCATG.REPORTING_ORDER
, PAOBJ.WORK_TYPE_ID
, UWKTY.NAME
, SUMMBAL.PERIOD_NAME
, SUMMBAL.PERIOD_NUM
, GLPRD.START_DATE
, GLPRD.END_DATE
, SUMMBAL.QUARTER_OR_MONTH_NUMBER
, SUMMBAL.PERIOD_YEAR
, PAOBJ.BALANCE_TYPE_CODE