View: PA_PROJECT_MANAGERS_V

Product:	PA - Projects
Description:	10SC Only
Implementation/DBA Data:	APPS.PA_PROJECT_MANAGERS_V

View Text

SELECT DISTINCT P.PERSON_ID
, P.FULL_NAME
, DECODE(P.CURRENT_EMPLOYEE_FLAG
, 'Y'
, P.EMPLOYEE_NUMBER
, P.NPW_NUMBER)
FROM PER_PEOPLE_F P
, PA_PROJECT_PLAYERS PP
, PA_PROJECTS PR
WHERE PP.PERSON_ID = P.PERSON_ID
AND TRUNC(SYSDATE) BETWEEN P.EFFECTIVE_START_DATE
AND P.EFFECTIVE_END_DATE
AND (P.EMPLOYEE_NUMBER IS NOT NULL OR P.NPW_NUMBER IS NOT NULL)
AND PP.PROJECT_ID= PR.PROJECT_ID
AND PP.PROJECT_ROLE_TYPE = 'PROJECT MANAGER'

Columns