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 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, ...