PJF_PROJECT_MEMBERS_V

Details

• Schema: FUSION

• Object owner: PJF

• Object type: VIEW

Columns

Name
PROJECT_PARTY_ID PROJECT_ID RESOURCE_ID PERSON_ID PROJECT_ROLE_ID PROJECT_PARTY_TYPE START_DATE_ACTIVE END_DATE_ACTIVE SCHEDULED_FLAG LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER

Query

SQL_Statement

SELECT PPP.PROJECT_PARTY_ID, PPP.PROJECT_ID, PPP.RESOURCE_ID, PPP.RESOURCE_SOURCE_ID PERSON_ID, PPP.PROJECT_ROLE_ID, PPP.PROJECT_PARTY_TYPE, PPP.START_DATE_ACTIVE, PPP.END_DATE_ACTIVE, PPP.SCHEDULED_FLAG, PPP.LAST_UPDATE_DATE, PPP.LAST_UPDATED_BY, PPP.CREATION_DATE, PPP.CREATED_BY, PPP.LAST_UPDATE_LOGIN, PPP.OBJECT_VERSION_NUMBER FROM PJF_PROJECT_PARTIES PPP WHERE PPP.OBJECT_TYPE = 'PA_PROJECTS' AND PPP.PROJECT_PARTY_TYPE= 'IN'