PJT_PRJ_ENTERPRISE_RESOURCE_VL

Details

• Schema: FUSION

• Object owner: PJT

• Object type: VIEW

Columns

Name

RESOURCE_ID FIRST_NAME LAST_NAME DISPLAY_NAME RESOURCE_CLASS RESOURCE_TYPE PROJECT_ID SCHEDULE_ID RESOURCE_SCOPE UNIT_OF_MEASURE CURRENCY_CODE RATE PROJECT_ROLE_ID START_DATE_ACTIVE END_DATE_ACTIVE PERSON_ID PARTY_ID EXPENDITURE_TYPE_ID LAST_UPDATED_BY LAST_UPDATE_DATE CREATED_BY CREATION_DATE LAST_UPDATE_LOGIN LANGUAGE DESCRIPTION EMAIL PHONE EXPENDITURE_AMOUNT OBJECT_VERSION_NUMBER RES_MGMT_FLAG RESOURCE_MANAGER_ID USER_DEFINED_FLAG COST_RATE BILL_RATE COST_RATE_CURRENCY_CODE BILL_RATE_CURRENCY_CODE EXTERNAL_ID IS_SEEDED PRJ_CNT_WKR_FLAG DATA_SOURCE RESUME_CONTENT RESUME_LATEST_VERSION ENTERPRISE_ID

Query

SQL_Statement

SELECT B.RESOURCE_ID, B.FIRST_NAME, B.LAST_NAME, T.DISPLAY_NAME, B.RESOURCE_CLASS, B.RESOURCE_TYPE, B.PROJECT_ID, B.SCHEDULE_ID, B.RESOURCE_SCOPE, B.UNIT_OF_MEASURE, B.CURRENCY_CODE, B.RATE, B.PROJECT_ROLE_ID, B.START_DATE_ACTIVE, B.END_DATE_ACTIVE, B.PERSON_ID, B.PARTY_ID, B.EXPENDITURE_TYPE_ID, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATE_LOGIN, T.LANGUAGE, T.DESCRIPTION, B.EMAIL EMAIL, B.PHONE PHONE, B.EXPENDITURE_AMOUNT, B.OBJECT_VERSION_NUMBER, B.RES_MGMT_FLAG, B.RESOURCE_MANAGER_ID, B.USER_DEFINED_FLAG, B.COST_RATE, B.BILL_RATE, B.COST_RATE_CURRENCY_CODE, B.BILL_RATE_CURRENCY_CODE, B.EXTERNAL_ID, B.IS_SEEDED, B.PRJ_CNT_WKR_FLAG, B.DATA_SOURCE, B.RESUME_CONTENT, B.RESUME_LATEST_VERSION, B.ENTERPRISE_ID FROM PJT_PRJ_ENTERPRISE_RESOURCE_B B, PJT_PRJ_ENTERPRISE_RESOURCE_TL T WHERE B.RESOURCE_ID = T.RESOURCE_ID AND T.LANGUAGE = USERENV('LANG')