VIEW: APPS.PA_PROJECT_MANAGERS_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'