View: PA_PARTIES_V

Product:	PA - Projects
Description:	PA_PARTIES_V shows all the users in the system including HR and TCA people
Implementation/DBA Data:	APPS.PA_PARTIES_V

View Text

SELECT 101
, P.PERSON_ID
, P.PARTY_ID
, P.FULL_NAME
, PAF.ORGANIZATION_ID
, ORG.NAME
FROM PER_ALL_PEOPLE_F P
, PER_ALL_ASSIGNMENTS_F PAF
, HR_ALL_ORGANIZATION_UNITS ORG
WHERE PAF.PERSON_ID = P.PERSON_ID
AND PAF.PRIMARY_FLAG = 'Y'
AND PAF.ASSIGNMENT_TYPE IN ('E'
, 'C')
AND PAF.JOB_ID IS NOT NULL
AND TRUNC(SYSDATE) BETWEEN TRUNC(PAF.EFFECTIVE_START_DATE)
AND TRUNC(PAF.EFFECTIVE_END_DATE)
AND ORG.ORGANIZATION_ID = PAF.ORGANIZATION_ID
AND ((P.CURRENT_EMPLOYEE_FLAG = 'Y'
AND P.EMPLOYEE_NUMBER IS NOT NULL) OR (P.CURRENT_NPW_FLAG = 'Y'
AND P.NPW_NUMBER IS NOT NULL))
AND PAF.EFFECTIVE_START_DATE BETWEEN P.EFFECTIVE_START_DATE
AND P.EFFECTIVE_END_DATE

Columns