[Home] [Help]
View: PA_WORK_TYPES_V
Product: | PA - Projects |
Description: | Displays information on implementation-defined types of work being carried out in Projects |
Implementation/DBA Data: |
APPS.PA_WORK_TYPES_V
|
View Text
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
Columns
Name |
WORK_TYPE_ID |
BILLABLE_CAPITALIZABLE_FLAG |
REDUCE_CAPACITY_FLAG |
RES_UTILIZATION_PERCENTAGE |
ORG_UTILIZATION_PERCENTAGE |
START_DATE_ACTIVE |
END_DATE_ACTIVE |
RES_UTIL_CATEGORY_ID |
ORG_UTIL_CATEGORY_ID |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_LOGIN |
ATTRIBUTE_CATEGORY |
ATTRIBUTE1 |
ATTRIBUTE2 |
ATTRIBUTE3 |
ATTRIBUTE4 |
ATTRIBUTE5 |
ATTRIBUTE6 |
ATTRIBUTE7 |
ATTRIBUTE8 |
ATTRIBUTE9 |
ATTRIBUTE10 |
ATTRIBUTE11 |
ATTRIBUTE12 |
ATTRIBUTE13 |
ATTRIBUTE14 |
ATTRIBUTE15 |
NAME |
DESCRIPTION |
TRAINING_FLAG |
TP_AMT_TYPE_CODE |
UNASSIGNED_FLAG |