PJC_XLA_TASK_WORKTYPE_REF_V

Details

• Schema: FUSION

• Object owner: PJC

• Object type: VIEW

Columns

Name

TASK_WORK_TYPE_BILLABLE_FLAG TASK_WORK_TYPE_ID TASK_WORK_TYPE_NAME TASK_WORKTYPE_ATTR_CATEGORY TASK_WORKTYPE_ATTRIBUTE1 TASK_WORKTYPE_ATTRIBUTE2 TASK_WORKTYPE_ATTRIBUTE3 TASK_WORKTYPE_ATTRIBUTE4 TASK_WORKTYPE_ATTRIBUTE5 TASK_WORKTYPE_ATTRIBUTE6 TASK_WORKTYPE_ATTRIBUTE7 TASK_WORKTYPE_ATTRIBUTE8 TASK_WORKTYPE_ATTRIBUTE9 TASK_WORKTYPE_ATTRIBUTE10 TASK_WORKTYPE_ATTRIBUTE11 TASK_WORKTYPE_ATTRIBUTE12 TASK_WORKTYPE_ATTRIBUTE13 TASK_WORKTYPE_ATTRIBUTE14 TASK_WORKTYPE_ATTRIBUTE15 TASK_WORK_TYPE_TP_AMOUNT_TYPE

Query

SQL_Statement

SELECT BILLABLE_CAPITALIZABLE_FLAG TASK_WORK_TYPE_BILLABLE_FLAG, WORK_TYPE_ID TASK_WORK_TYPE_ID, WORK_TYPE_ID TASK_WORK_TYPE_NAME, ATTRIBUTE_CATEGORY TASK_WORKTYPE_ATTR_CATEGORY, ATTRIBUTE1 TASK_WORKTYPE_ATTRIBUTE1, ATTRIBUTE2 TASK_WORKTYPE_ATTRIBUTE2, ATTRIBUTE3 TASK_WORKTYPE_ATTRIBUTE3, ATTRIBUTE4 TASK_WORKTYPE_ATTRIBUTE4, ATTRIBUTE5 TASK_WORKTYPE_ATTRIBUTE5, ATTRIBUTE6 TASK_WORKTYPE_ATTRIBUTE6, ATTRIBUTE7 TASK_WORKTYPE_ATTRIBUTE7, ATTRIBUTE8 TASK_WORKTYPE_ATTRIBUTE8, ATTRIBUTE9 TASK_WORKTYPE_ATTRIBUTE9, ATTRIBUTE10 TASK_WORKTYPE_ATTRIBUTE10, ATTRIBUTE11 TASK_WORKTYPE_ATTRIBUTE11, ATTRIBUTE12 TASK_WORKTYPE_ATTRIBUTE12, ATTRIBUTE13 TASK_WORKTYPE_ATTRIBUTE13, ATTRIBUTE14 TASK_WORKTYPE_ATTRIBUTE14, ATTRIBUTE15 TASK_WORKTYPE_ATTRIBUTE15, TP_AMT_TYPE_CODE TASK_WORK_TYPE_TP_AMOUNT_TYPE FROM PJF_WORK_TYPES_B