SELECT DISTINCT P.PERSON_ID , P.FULL_NAME , NVL(P.EMPLOYEE_NUMBER , P.NPW_NUMBER) , O.NAME , O.ORGANIZATION_ID , A.EFFECTIVE_START_DATE , A.EFFECTIVE_END_DATE , J.NAME , P.EFFECTIVE_START_DATE , P.EFFECTIVE_END_DATE FROM PER_PEOPLE_F P , PER_JOBS J , PER_ORGANIZATION_UNITS O , PER_ASSIGNMENTS_F A , PER_ASSIGNMENT_STATUS_TYPES AST1 WHERE A.ORGANIZATION_ID = O.ORGANIZATION_ID AND A.JOB_ID = J.JOB_ID AND A.JOB_ID IS NOT NULL AND A.ORGANIZATION_ID IS NOT NULL AND A.PRIMARY_FLAG = 'Y' AND A.ASSIGNMENT_TYPE IN ('E' , 'C') AND AST1.ASSIGNMENT_STATUS_TYPE_ID = A.ASSIGNMENT_STATUS_TYPE_ID AND AST1.PER_SYSTEM_STATUS IN ( 'ACTIVE_ASSIGN' , 'ACTIVE_CWK') AND P.PERSON_ID = A.PERSON_ID AND ( P.EMPLOYEE_NUMBER IS NOT NULL OR P.NPW_NUMBER IS NOT NULL )