View: PAFV_KEY_MEMBERS

Product:	PA - Projects
Description:	Business view to show information about the employees involved with the project.
Implementation/DBA Data:	APPS.PAFV_KEY_MEMBERS

View Text

SELECT PPA.PROJECT_ID
, PPA.NAME
, PPA.SEGMENT1
, PAP.PERSON_ID
, PAP.FULL_NAME
, PRT.PROJECT_ROLE_TYPE
, PRT.MEANING
, PPP.START_DATE_ACTIVE
, PPP.END_DATE_ACTIVE
, PPP.LAST_UPDATE_DATE
, PPP.LAST_UPDATED_BY
, PPP.CREATION_DATE
, PPP.CREATED_BY
FROM PA_PROJECT_PLAYERS PPP
, PA_PROJECT_ROLE_TYPES PRT
, PA_PROJECTS_ALL PPA
, PER_ALL_PEOPLE_F PAP
WHERE PPP.PROJECT_ID = PPA.PROJECT_ID
AND PPP.PROJECT_ROLE_TYPE = PRT.PROJECT_ROLE_TYPE
AND PPP.PERSON_ID = PAP.PERSON_ID
AND TRUNC(SYSDATE) BETWEEN PAP.EFFECTIVE_START_DATE
AND PAP.EFFECTIVE_END_DATE
AND '_SEC:PPA.ORG_ID' IS NOT NULL WITH READ ONLY

Columns