View: PA_PROJ_MEMBERS_VIEW

Product:	PA - Projects
Description:	View of project information for projects for use in reporting projects by project member
Implementation/DBA Data:	APPS.PA_PROJ_MEMBERS_VIEW

View Text

SELECT PROJ.ORG_ID
, PROJ.PROJECT_ID
, PROJ.NAME
, PROJ.SEGMENT1
, PROJ.START_DATE
, PROJ.COMPLETION_DATE
, PS.PROJECT_STATUS_NAME
, PROJ.PROJECT_STATUS_CODE
, FND.MEANING
, PROJ.PROJECT_TYPE
, PROJ.DESCRIPTION
, ORG.ORGANIZATION_ID
, ORG.NAME
, PLAYER.PERSON_ID
, PEOPLE.FULL_NAME
, PROJ.DISTRIBUTION_RULE
, ROLES.PROJECT_ROLE_TYPE
, ROLES.MEANING
FROM PA_PROJECTS PROJ
, HR_ORGANIZATION_UNITS ORG
, PER_PEOPLE_F PEOPLE
, PA_PROJECT_PLAYERS PLAYER
, PA_PROJECT_ROLE_TYPES ROLES
, PA_PROJECT_STATUSES PS
, FND_LOOKUPS FND
WHERE PROJ.CARRYING_OUT_ORGANIZATION_ID = ORG.ORGANIZATION_ID
AND PROJ.PROJECT_ID = PLAYER.PROJECT_ID
AND PLAYER.PERSON_ID = PEOPLE.PERSON_ID
AND TRUNC(SYSDATE) <= PEOPLE.EFFECTIVE_END_DATE
AND ((PEOPLE.EMPLOYEE_NUMBER IS NOT NULL
AND PEOPLE.CURRENT_EMPLOYEE_FLAG = 'Y') OR (PEOPLE.NPW_NUMBER IS NOT NULL
AND PEOPLE.CURRENT_NPW_FLAG = 'Y'))
AND PLAYER.PROJECT_ROLE_TYPE = ROLES.PROJECT_ROLE_TYPE
AND SYSDATE <= NVL(PLAYER.END_DATE_ACTIVE
, SYSDATE+1)
AND PS.PROJECT_STATUS_CODE = PROJ.PROJECT_STATUS_CODE
AND FND.LOOKUP_TYPE = 'YES_NO'
AND FND.LOOKUP_CODE = PROJ.PUBLIC_SECTOR_FLAG
AND PS.STATUS_TYPE = 'PROJECT'
AND TRUNC(SYSDATE) BETWEEN TRUNC(PEOPLE.EFFECTIVE_START_DATE)
AND TRUNC(PEOPLE.EFFECTIVE_END_DATE)

Columns