1. Tables and Views for Project Management
  2. PJF_PROJECT_TYPES_B_V

PJF_PROJECT_TYPES_B_V

Details

  • Schema: FUSION

  • Object owner: PJF

  • Object type: VIEW

Columns

Name

PROJECT_TYPE_ID

SET_ID

START_DATE_ACTIVE

END_DATE_ACTIVE

WORK_TYPE_ID

ENABLE_BILLING_FLAG

ENABLE_CAPITALIZATION_FLAG

ATTRIBUTE_CATEGORY

ATTRIBUTE1

ATTRIBUTE2

ATTRIBUTE3

ATTRIBUTE4

ATTRIBUTE5

ATTRIBUTE6

ATTRIBUTE7

ATTRIBUTE8

ATTRIBUTE9

ATTRIBUTE10

BURDEN_COST_FLAG

COST_IND_RATE_SCH_ID

COST_SCH_OVERRIDE_FLAG

BURDEN_AMT_DISPLAY_METHOD

BURDEN_ACCOUNT_FLAG

BURDEN_SUM_DEST_PROJECT_ID

BURDEN_SUM_DEST_TASK_ID

BURDEN_COST_JOURNAL_FLAG

TOTAL_BURDENED_JOURNAL_FLAG

CAPITAL_COST_TYPE_CODE

INTERFACE_COMPLETE_ASSET_FLAG

OVERRIDE_ASSET_ASSIGNMENT_FLAG

ASSET_ALLOCATION_METHOD

CAPITAL_EVENT_PROCESSING

CIP_GROUPING_METHOD_CODE

VENDOR_INVOICE_GROUPING_CODE

CINT_RATE_SCH_ID

CINT_SCH_OVERRIDE_FLAG

INTERFACE_ASSET_COST_CODE

LAST_UPDATE_DATE

LAST_UPDATED_BY

CREATION_DATE

CREATED_BY

LAST_UPDATE_LOGIN

OBJECT_VERSION_NUMBER

SPONSORED_FLAG

Query

SQL_Statement

SELECT

PJF_PROJECT_TYPES_B.PROJECT_TYPE_ID PROJECT_TYPE_ID,

PJF_PROJECT_TYPES_B.SET_ID SET_ID,

PJF_PROJECT_TYPES_B.START_DATE_ACTIVE START_DATE_ACTIVE,

PJF_PROJECT_TYPES_B.END_DATE_ACTIVE END_DATE_ACTIVE,

PJF_PROJECT_TYPES_B.WORK_TYPE_ID WORK_TYPE_ID,

PJF_PROJECT_TYPES_B.ENABLE_BILLING_FLAG ENABLE_BILLING_FLAG,

PJF_PROJECT_TYPES_B.ENABLE_CAPITALIZATION_FLAG ENABLE_CAPITALIZATION_FLAG,

PJF_PROJECT_TYPES_B.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY,

PJF_PROJECT_TYPES_B.ATTRIBUTE1 ATTRIBUTE1,

PJF_PROJECT_TYPES_B.ATTRIBUTE2 ATTRIBUTE2,

PJF_PROJECT_TYPES_B.ATTRIBUTE3 ATTRIBUTE3,

PJF_PROJECT_TYPES_B.ATTRIBUTE4 ATTRIBUTE4,

PJF_PROJECT_TYPES_B.ATTRIBUTE5 ATTRIBUTE5,

PJF_PROJECT_TYPES_B.ATTRIBUTE6 ATTRIBUTE6,

PJF_PROJECT_TYPES_B.ATTRIBUTE7 ATTRIBUTE7,

PJF_PROJECT_TYPES_B.ATTRIBUTE8 ATTRIBUTE8,

PJF_PROJECT_TYPES_B.ATTRIBUTE9 ATTRIBUTE9,

PJF_PROJECT_TYPES_B.ATTRIBUTE10 ATTRIBUTE10,

PJF_PROJECT_TYPES_B.BURDEN_COST_FLAG BURDEN_COST_FLAG,

PJF_PROJECT_TYPES_B.COST_IND_RATE_SCH_ID COST_IND_RATE_SCH_ID,

PJF_PROJECT_TYPES_B.COST_SCH_OVERRIDE_FLAG COST_SCH_OVERRIDE_FLAG,

PJF_PROJECT_TYPES_B.BURDEN_AMT_DISPLAY_METHOD BURDEN_AMT_DISPLAY_METHOD,

PJF_PROJECT_TYPES_B.BURDEN_ACCOUNT_FLAG BURDEN_ACCOUNT_FLAG,

PJF_PROJECT_TYPES_B.BURDEN_SUM_DEST_PROJECT_ID BURDEN_SUM_DEST_PROJECT_ID,

PJF_PROJECT_TYPES_B.BURDEN_SUM_DEST_TASK_ID BURDEN_SUM_DEST_TASK_ID,

PJF_PROJECT_TYPES_B.BURDEN_COST_JOURNAL_FLAG BURDEN_COST_JOURNAL_FLAG,

PJF_PROJECT_TYPES_B.TOTAL_BURDENED_JOURNAL_FLAG TOTAL_BURDENED_JOURNAL_FLAG,

PJF_PROJECT_TYPES_B.CAPITAL_COST_TYPE_CODE CAPITAL_COST_TYPE_CODE,

PJF_PROJECT_TYPES_B.INTERFACE_COMPLETE_ASSET_FLAG INTERFACE_COMPLETE_ASSET_FLAG,

PJF_PROJECT_TYPES_B.OVERRIDE_ASSET_ASSIGNMENT_FLAG OVERRIDE_ASSET_ASSIGNMENT_FLAG,

PJF_PROJECT_TYPES_B.ASSET_ALLOCATION_METHOD ASSET_ALLOCATION_METHOD,

PJF_PROJECT_TYPES_B.CAPITAL_EVENT_PROCESSING CAPITAL_EVENT_PROCESSING,

PJF_PROJECT_TYPES_B.CIP_GROUPING_METHOD_CODE CIP_GROUPING_METHOD_CODE,

PJF_PROJECT_TYPES_B.VENDOR_INVOICE_GROUPING_CODE VENDOR_INVOICE_GROUPING_CODE,

PJF_PROJECT_TYPES_B.CINT_RATE_SCH_ID CINT_RATE_SCH_ID,

PJF_PROJECT_TYPES_B.CINT_SCH_OVERRIDE_FLAG CINT_SCH_OVERRIDE_FLAG,

PJF_PROJECT_TYPES_B.INTERFACE_ASSET_COST_CODE INTERFACE_ASSET_COST_CODE,

PJF_PROJECT_TYPES_B.LAST_UPDATE_DATE LAST_UPDATE_DATE,

PJF_PROJECT_TYPES_B.LAST_UPDATED_BY LAST_UPDATED_BY,

PJF_PROJECT_TYPES_B.CREATION_DATE CREATION_DATE,

PJF_PROJECT_TYPES_B.CREATED_BY CREATED_BY,

PJF_PROJECT_TYPES_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

PJF_PROJECT_TYPES_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

PJF_PROJECT_TYPES_B.SPONSORED_FLAG SPONSORED_FLAG

FROM

PJF_PROJECT_TYPES_B