View: PJI_DIS_WORK_TYPES_V

Product:	PJI - Project Intelligence
Description:	Discoverer view of work type data.
Implementation/DBA Data:	APPS.PJI_DIS_WORK_TYPES_V

View Text

SELECT WT.BILLABLE_CAPITALIZABLE_FLAG
, WTTL.NAME WORKTYPE
, WT.ORG_UTIL_CATEGORY_ID
, WT.ORG_UTILIZATION_PERCENTAGE
, WT.REDUCE_CAPACITY_FLAG
, WT.RES_UTIL_CATEGORY_ID
, WT.RES_UTILIZATION_PERCENTAGE
, WT.TRAINING_FLAG
, WT.UNASSIGNED_FLAG
, WT.WORK_TYPE_ID
, UC1TL.NAME ORG_UTILIZATION_CATEGORY
, UC2TL.NAME RES_UTILIZATION_CATEGORY
FROM PA_WORK_TYPES_B WT
, PA_WORK_TYPES_TL WTTL
, PA_UTIL_CATEGORIES_B UC1
, PA_UTIL_CATEGORIES_TL UC1TL
, PA_UTIL_CATEGORIES_B UC2
, PA_UTIL_CATEGORIES_TL UC2TL
WHERE UC1.UTIL_CATEGORY_ID = WT.ORG_UTIL_CATEGORY_ID
AND UC2.UTIL_CATEGORY_ID = WT.RES_UTIL_CATEGORY_ID
AND WT.WORK_TYPE_ID = WTTL.WORK_TYPE_ID
AND UC1.UTIL_CATEGORY_ID = UC1TL.UTIL_CATEGORY_ID
AND UC2.UTIL_CATEGORY_ID = UC2TL.UTIL_CATEGORY_ID
AND WTTL.LANGUAGE = USERENV('LANG')
AND UC1TL.LANGUAGE = USERENV('LANG')
AND UC2TL.LANGUAGE = USERENV('LANG')

Columns