VIEW: APPS.PA_WORK_TYPES_V

Source

View Text - Preformatted

SELECT w.work_type_id, w.billable_capitalizable_flag, w.reduce_capacity_flag, w.res_utilization_percentage, w.org_utilization_percentage, w.start_date_active, w.end_date_active, w.res_util_category_id, w.org_util_category_id, w.creation_date, w.created_by, w.last_update_date, w.last_updated_by, w.last_update_login, w.attribute_category, w.attribute1, w.attribute2, w.attribute3, w.attribute4, w.attribute5, w.attribute6, w.attribute7, w.attribute8, w.attribute9, w.attribute10, w.attribute11, w.attribute12, w.attribute13, w.attribute14, w.attribute15, w.name, w.description, w.training_flag, w.tp_amt_type_code, w.unassigned_flag FROM PA_WORK_TYPES_VL w

View Text - HTML Formatted

SELECT W.WORK_TYPE_ID
, W.BILLABLE_CAPITALIZABLE_FLAG
, W.REDUCE_CAPACITY_FLAG
, W.RES_UTILIZATION_PERCENTAGE
, W.ORG_UTILIZATION_PERCENTAGE
, W.START_DATE_ACTIVE
, W.END_DATE_ACTIVE
, W.RES_UTIL_CATEGORY_ID
, W.ORG_UTIL_CATEGORY_ID
, W.CREATION_DATE
, W.CREATED_BY
, W.LAST_UPDATE_DATE
, W.LAST_UPDATED_BY
, W.LAST_UPDATE_LOGIN
, W.ATTRIBUTE_CATEGORY
, W.ATTRIBUTE1
, W.ATTRIBUTE2
, W.ATTRIBUTE3
, W.ATTRIBUTE4
, W.ATTRIBUTE5
, W.ATTRIBUTE6
, W.ATTRIBUTE7
, W.ATTRIBUTE8
, W.ATTRIBUTE9
, W.ATTRIBUTE10
, W.ATTRIBUTE11
, W.ATTRIBUTE12
, W.ATTRIBUTE13
, W.ATTRIBUTE14
, W.ATTRIBUTE15
, W.NAME
, W.DESCRIPTION
, W.TRAINING_FLAG
, W.TP_AMT_TYPE_CODE
, W.UNASSIGNED_FLAG
FROM PA_WORK_TYPES_VL W