PJC_XLA_WORKTYPE_REF_V

Details

• Schema: FUSION

• Object owner: PJC

• Object type: VIEW

Columns

Name
WORK_TYPE_ID WORKTYPE_ATTRIBUTE_CATEGORY WORKTYPE_ATTRIBUTE1 WORKTYPE_ATTRIBUTE2 WORKTYPE_ATTRIBUTE3 WORKTYPE_ATTRIBUTE4 WORKTYPE_ATTRIBUTE5 WORKTYPE_ATTRIBUTE6 WORKTYPE_ATTRIBUTE7 WORKTYPE_ATTRIBUTE8 WORKTYPE_ATTRIBUTE9 WORKTYPE_ATTRIBUTE10 WORKTYPE_ATTRIBUTE11 WORKTYPE_ATTRIBUTE12 WORKTYPE_ATTRIBUTE13 WORKTYPE_ATTRIBUTE14 WORKTYPE_ATTRIBUTE15 WORK_TYPE_BILLABLE_FLAG WORK_TYPE_TP_AMOUNT_TYPE

Query

SQL_Statement

SELECT WORK_TYPE_ID, ATTRIBUTE_CATEGORY WORKTYPE_ATTRIBUTE_CATEGORY, ATTRIBUTE1 WORKTYPE_ATTRIBUTE1, ATTRIBUTE2 WORKTYPE_ATTRIBUTE2, ATTRIBUTE3 WORKTYPE_ATTRIBUTE3, ATTRIBUTE4 WORKTYPE_ATTRIBUTE4, ATTRIBUTE5 WORKTYPE_ATTRIBUTE5, ATTRIBUTE6 WORKTYPE_ATTRIBUTE6, ATTRIBUTE7 WORKTYPE_ATTRIBUTE7, ATTRIBUTE8 WORKTYPE_ATTRIBUTE8, ATTRIBUTE9 WORKTYPE_ATTRIBUTE9, ATTRIBUTE10 WORKTYPE_ATTRIBUTE10, ATTRIBUTE11 WORKTYPE_ATTRIBUTE11, ATTRIBUTE12 WORKTYPE_ATTRIBUTE12, ATTRIBUTE13 WORKTYPE_ATTRIBUTE13, ATTRIBUTE14 WORKTYPE_ATTRIBUTE14, ATTRIBUTE15 WORKTYPE_ATTRIBUTE15, BILLABLE_CAPITALIZABLE_FLAG WORK_TYPE_BILLABLE_FLAG, TP_AMT_TYPE_CODE WORK_TYPE_TP_AMOUNT_TYPE FROM PJF_WORK_TYPES_B