Query to find PERSON_NUMBER, TITLE, FIRST_NAME, MIDDLE_NAMES, LAST_NAME, DISPLAY_NAME,FULL_NAME, LIST_NAME, ORDER_NAME OF EMPLOYEE of Employee - Oracle Fusion HCM

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 

papf.person_number,          

ppnf.title,                  -- Its code. Use hcm_lookups for meaning          

ppnf.first_name,         

ppnf.middle_names,          

ppnf.last_name,          

ppnf.display_name,         

ppnf.full_name,         

 ppnf.list_name,          

ppnf.order_name     

FROM 

per_all_people_f papf, 

per_person_names_f ppnf    

WHERE 

papf.person_id = ppnf.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          

AND TRUNC (SYSDATE) BETWEEN ppnf.effective_start_date  AND ppnf.effective_end_date -- To get latest updated data          

AND ppnf.name_type = 'GLOBAL'          -- Depending uppon requirement 

ORDER BY person_number