Fusion Query

Fusion Queries Employee Details in Fusion HCM Query to find Email details of an Employee Oracle Fusion HCM :  PERSON_NUMBER,  EMAIL_TYPE,  EMAIL_ADDRESS    SELECT     papf.person_number,   pea.email_type,   pea.email_address         FROM per_all_people_f papf,   per_email_addresses pea        WHERE     papf.person_id = pea.person_id(+) -- (+)to fetch if some data is not present in system        AND TRUNC (SYSDATE) BETWEEN papf.effective_start_date                                    AND papf.effective_end_date   ORDER BY person_number

Fusion Queries Employee Details in Fusion HCM Query to find Name details of an Employee Oracle Fusion HCM :  PERSON_NUMBER,           TITLE,               FIRST_NAME,          MIDDLE_NAMES,           LAST_NAME,           DISPLAY_NAME,          FULL_NAME,          LIST_NAME,           ORDER_NAME       SELECT  p apf.person_number,           ppnf.title,                  -- Its code. Use hcm_lookups for meaning           ppnf.first_name,          ppnf.middle_names,           ppnf.last_name,           ppnf.display_name,      ...

Fusion Queries Employee Details in Fusion HCM Oracle Fusion HCM :  PERSON_NUMBER , PHONE_TYPE,           PHONE_NUMBER,           AREA_CODE,           SEARCH_PHONE_NUMBER,           COUNTRY_CODE_NUMBER    SELECT  papf.person_number,          pp.PHONE_TYPE,           pp.PHONE_NUMBER,           pp.AREA_CODE,           pp.SEARCH_PHONE_NUMBER,           pp.COUNTRY_CODE_NUMBER      FROM  per_all_people_f papf,  per_phones pp     WHERE  papf.person_id = pp.person_id(+) --  to fetch if some data is not present in system           AND TRUNC (SYSDATE) BETWEEN papf.effective_start_date   AND papf.effective_end_date  ORDER BY...

Fusion Queries Employee Details in Fusion HCM Oracle Fusion HCM :  TOWN_OF_BIRTH, REGION_OF_BIRTH, COUNTRY_OF_BIRTH, PERSON_NUMBER, DATE_OF_DEATH, BLOOD_TYPE, D ATE_OF_BIRTH   SELECT  papf.person_number,           pp.blood_type,           pp.date_of_birth dob,           pp.date_of_death,           pp.country_of_birth,           pp.region_of_birth,           pp.town_of_birth       FROM  per_all_people_f papf,  per_persons pp     WHERE  papf.person_id = pp.person_id(+) -- (+)to fetch if some data is not present in system          AND TRUNC (SYSDATE) BETWEEN papf.effective_start_date   AND papf.effective_end_date  ORDER BY person_number

Fusion Queries Employee Number - Oracle Fusion HCM SELECT  person_number     FROM  per_all_people_f  papf     WHERE  TRUNC (SYSDATE) BETWEEN papf.effective_start_date  AND papf.effective_end_date ORDER BY person_number