VIEW: APPS.PJI_DIS_WORK_TYPES_V

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')