1、select distinct papf.person_id, papf.effective_start_date -, papf.effective_end_date -, ppt.user_person_type , papf.last_name , papf.start_date , papf.employee_number , papf.middle_names , papf.date_of_birth , papf.email_address , papf.national_identifier , hl1.meaning , hl2.meaning , hl3.meaning ,
2、papf.region_of_birth , papf.attribute9 , papf.attribute1 , papf.attribute2 , papf.attribute10 , papf.attribute4 , papf.attribute8 , papf.attribute3 , papf.attribute11 , papf.attribute12 , papf.attribute30 , papf.last_update_date , s01.last_name from per_all_people_f papf, per_person_types ppt, per_p
3、erson_type_usages_f pptuf, hr_lookups hl1, hr_lookups hl2, hr_lookups hl3, (select distinct t.user_id ,tf.last_name from fnd_user t,per_all_people_f tf where t.employee_id=tf.person_id (+) AND trunc(sysdate) between tf.effective_start_date and tf.effective_end_date ) s01 where papf.person_id = pptuf
4、.person_id AND hl1.lookup_type (+) = SEX AND hl1.lookup_code (+) = papf.sex AND hl2.lookup_type (+) = MAR_STATUS AND hl2.lookup_code (+) = papf.marital_status AND hl3.lookup_type (+) = NATIONALITY AND hl3.lookup_code (+) = papf.nationality AND ppt.system_person_type = EMP AND trunc(sysdate) between papf.effective_start_date and papf.effective_end_date AND pptuf.person_type_id = ppt.person_type_id and pptuf.effective_end_date = papf.effective_end_date AND papf.last_updated_by=s01.user_id(+)
