PJF_LATESTPROJECTMANAGER_V

Details

• Schema: FUSION

• Object owner: PJF

• Object type: VIEW

Columns

Name
PROJECT_PARTY_ID OBJECT_ID OBJECT_TYPE PROJECT_ID RESOURCE_ID RESOURCE_SOURCE_ID PROJECT_PARTY_TYPE PROJECT_ROLE_ID START_DATE_ACTIVE END_DATE_ACTIVE PJS_TRACK_TIME SCHEDULED_FLAG CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER RELATIONSHIP_ID

Query

SQL_Statement

SELECT * FROM ( SELECT PROJECT_PARTY_ID, OBJECT_ID, OBJECT_TYPE, PROJECT_ID, RESOURCE_ID, RESOURCE_SOURCE_ID, PROJECT_PARTY_TYPE, PROJECT_ROLE_ID, CASE WHEN START_DATE_ACTIVE = MAX(START_DATE_ACTIVE) OVER (PARTITION BY PROJECT_ID, PROJECT_ROLE_ID) THEN START_DATE_ACTIVE ELSE NULL END AS START_DATE_ACTIVE, END_DATE_ACTIVE, PJS_TRACK_TIME, SCHEDULED_FLAG, CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER, RELATIONSHIP_ID FROM PJF_PROJECT_PARTIES pp1 WHERE pp1.PROJECT_ROLE_ID = 1) WHERE START_DATE_ACTIVE IS NOT NULL