PJF_PROJECT_TYPES

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 PROJECT_TYPE DESCRIPTION LANGUAGE 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

Name

PROJECT_TYPE_ID

SET_ID

START_DATE_ACTIVE

END_DATE_ACTIVE

WORK_TYPE_ID

ENABLE_BILLING_FLAG

ENABLE_CAPITALIZATION_FLAG

PROJECT_TYPE

DESCRIPTION

LANGUAGE

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 B.PROJECT_TYPE_ID PROJECT_TYPE_ID, B.SET_ID SET_ID, B.START_DATE_ACTIVE START_DATE_ACTIVE, B.END_DATE_ACTIVE END_DATE_ACTIVE, B.WORK_TYPE_ID WORK_TYPE_ID, B.ENABLE_BILLING_FLAG ENABLE_BILLING_FLAG, B.ENABLE_CAPITALIZATION_FLAG ENABLE_CAPITALIZATION_FLAG, T.PROJECT_TYPE PROJECT_TYPE, T.DESCRIPTION DESCRIPTION, T.LANGUAGE LANGUAGE, B.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, B.ATTRIBUTE1 ATTRIBUTE1, B.ATTRIBUTE2 ATTRIBUTE2, B.ATTRIBUTE3 ATTRIBUTE3, B.ATTRIBUTE4 ATTRIBUTE4, B.ATTRIBUTE5 ATTRIBUTE5, B.ATTRIBUTE6 ATTRIBUTE6, B.ATTRIBUTE7 ATTRIBUTE7, B.ATTRIBUTE8 ATTRIBUTE8, B.ATTRIBUTE9 ATTRIBUTE9, B.ATTRIBUTE10 ATTRIBUTE10, B.BURDEN_COST_FLAG BURDEN_COST_FLAG, B.COST_IND_RATE_SCH_ID COST_IND_RATE_SCH_ID, B.COST_SCH_OVERRIDE_FLAG COST_SCH_OVERRIDE_FLAG, B.BURDEN_AMT_DISPLAY_METHOD BURDEN_AMT_DISPLAY_METHOD, B.BURDEN_ACCOUNT_FLAG BURDEN_ACCOUNT_FLAG, B.BURDEN_SUM_DEST_PROJECT_ID BURDEN_SUM_DEST_PROJECT_ID, B.BURDEN_SUM_DEST_TASK_ID BURDEN_SUM_DEST_TASK_ID, B.BURDEN_COST_JOURNAL_FLAG BURDEN_COST_JOURNAL_FLAG, B.TOTAL_BURDENED_JOURNAL_FLAG TOTAL_BURDENED_JOURNAL_FLAG, B.CAPITAL_COST_TYPE_CODE CAPITAL_COST_TYPE_CODE, B.INTERFACE_COMPLETE_ASSET_FLAG INTERFACE_COMPLETE_ASSET_FLAG, B.OVERRIDE_ASSET_ASSIGNMENT_FLAG OVERRIDE_ASSET_ASSIGNMENT_FLAG, B.ASSET_ALLOCATION_METHOD ASSET_ALLOCATION_METHOD, B.CAPITAL_EVENT_PROCESSING CAPITAL_EVENT_PROCESSING, B.CIP_GROUPING_METHOD_CODE CIP_GROUPING_METHOD_CODE, B.VENDOR_INVOICE_GROUPING_CODE VENDOR_INVOICE_GROUPING_CODE, B.CINT_RATE_SCH_ID CINT_RATE_SCH_ID, B.CINT_SCH_OVERRIDE_FLAG CINT_SCH_OVERRIDE_FLAG, B.INTERFACE_ASSET_COST_CODE INTERFACE_ASSET_COST_CODE, B.LAST_UPDATE_DATE LAST_UPDATE_DATE, B.LAST_UPDATED_BY LAST_UPDATED_BY, B.CREATION_DATE CREATION_DATE, B.CREATED_BY CREATED_BY, B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, B.SPONSORED_FLAG SPONSORED_FLAG FROM PJF_PROJECT_TYPES_B B, PJF_PROJECT_TYPES_TL T WHERE B.PROJECT_TYPE_ID = T.PROJECT_TYPE_ID AND T.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT

B.PROJECT_TYPE_ID PROJECT_TYPE_ID,

B.SET_ID SET_ID,

B.START_DATE_ACTIVE START_DATE_ACTIVE,

B.END_DATE_ACTIVE END_DATE_ACTIVE,

B.WORK_TYPE_ID WORK_TYPE_ID,

B.ENABLE_BILLING_FLAG ENABLE_BILLING_FLAG,

B.ENABLE_CAPITALIZATION_FLAG ENABLE_CAPITALIZATION_FLAG,

T.PROJECT_TYPE PROJECT_TYPE,

T.DESCRIPTION DESCRIPTION,

T.LANGUAGE LANGUAGE,

B.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY,

B.ATTRIBUTE1 ATTRIBUTE1,

B.ATTRIBUTE2 ATTRIBUTE2,

B.ATTRIBUTE3 ATTRIBUTE3,

B.ATTRIBUTE4 ATTRIBUTE4,

B.ATTRIBUTE5 ATTRIBUTE5,

B.ATTRIBUTE6 ATTRIBUTE6,

B.ATTRIBUTE7 ATTRIBUTE7,

B.ATTRIBUTE8 ATTRIBUTE8,

B.ATTRIBUTE9 ATTRIBUTE9,

B.ATTRIBUTE10 ATTRIBUTE10,

B.BURDEN_COST_FLAG BURDEN_COST_FLAG,

B.COST_IND_RATE_SCH_ID COST_IND_RATE_SCH_ID,

B.COST_SCH_OVERRIDE_FLAG COST_SCH_OVERRIDE_FLAG,

B.BURDEN_AMT_DISPLAY_METHOD BURDEN_AMT_DISPLAY_METHOD,

B.BURDEN_ACCOUNT_FLAG BURDEN_ACCOUNT_FLAG,

B.BURDEN_SUM_DEST_PROJECT_ID BURDEN_SUM_DEST_PROJECT_ID,

B.BURDEN_SUM_DEST_TASK_ID BURDEN_SUM_DEST_TASK_ID,

B.BURDEN_COST_JOURNAL_FLAG BURDEN_COST_JOURNAL_FLAG,

B.TOTAL_BURDENED_JOURNAL_FLAG TOTAL_BURDENED_JOURNAL_FLAG,

B.CAPITAL_COST_TYPE_CODE CAPITAL_COST_TYPE_CODE,

B.INTERFACE_COMPLETE_ASSET_FLAG INTERFACE_COMPLETE_ASSET_FLAG,

B.OVERRIDE_ASSET_ASSIGNMENT_FLAG OVERRIDE_ASSET_ASSIGNMENT_FLAG,

B.ASSET_ALLOCATION_METHOD ASSET_ALLOCATION_METHOD,

B.CAPITAL_EVENT_PROCESSING CAPITAL_EVENT_PROCESSING,

B.CIP_GROUPING_METHOD_CODE CIP_GROUPING_METHOD_CODE,

B.VENDOR_INVOICE_GROUPING_CODE VENDOR_INVOICE_GROUPING_CODE,

B.CINT_RATE_SCH_ID CINT_RATE_SCH_ID,

B.CINT_SCH_OVERRIDE_FLAG CINT_SCH_OVERRIDE_FLAG,

B.INTERFACE_ASSET_COST_CODE INTERFACE_ASSET_COST_CODE,

B.LAST_UPDATE_DATE LAST_UPDATE_DATE,

B.LAST_UPDATED_BY LAST_UPDATED_BY,

B.CREATION_DATE CREATION_DATE,

B.CREATED_BY CREATED_BY,

B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

B.SPONSORED_FLAG SPONSORED_FLAG

FROM

PJF_PROJECT_TYPES_B B,

PJF_PROJECT_TYPES_TL T

WHERE

B.PROJECT_TYPE_ID = T.PROJECT_TYPE_ID AND T.LANGUAGE = USERENV('LANG')