xx_hr3

Description
Categories: BI Publisher
Columns: Organization Id, Person Id, Employee Number, Full Name, Sex, Position Id ...
    SELECT 
           PER_ASSIGNMENTS_X.ORGANIZATION_ID,
           PER_PEOPLE_X.PERSON_ID,
           EMPLOYEE_NUMBER,
           FULL_NAME,
           SEX,
           PER_ASSIGNMENTS_X.POSITION_ID
      FROM PER_PEOPLE_X, HR.PER_IMAGES, PER_ASSIGNMENTS_X
     WHERE     PER_PEOPLE_X.PERSON_ID = PER_ASSIGNMENTS_X.PERSON_ID
           AND PER_PEOPLE_X.PERSON_ID = PARENT_ID
           AND IMAGE IS NOT NULL