Product: | PJI - Project Intelligence(Obsolete) |
---|---|
Description: | Discoverer view of work type data. |
Implementation/DBA Data: | Not implemented in this database |
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')