ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D471A551A9E05362FB09050512 select 'HR' source, 'HR' source2, ppf.national_identifier, ppf2.national_identifier national_identifier2, ppf.party_id, ppf2.party_id party_id2, hr_reports.get_party_number(ppf.party_id) party_number, hr_reports.get_party_number(ppf2.party_id) party_number2, ppf.full_name, ppf2.full_name full_name2, ppf.order_name, ppf2.order_name order_name2, pbg.name bg_name, pbg2.name bg_name2, loc.location_code, loc2.location_code location_code2, org.name org_name, org2.name org_name2, add1.postal_code, add2.postal_code postal_code2, ppf.employee_number, ppf2.employee_number employee_number2, ppf.applicant_number, ppf2.applicant_number applicant_number2, ppf.npw_number npw_number, ppf2.npw_number npw_number2 from per_all_people_f ppf, per_business_groups pbg, per_addresses add1, per_all_assignments_f ass, hr_all_organization_units org, hr_locations_all loc, per_all_people_f ppf2, per_business_groups pbg2, per_addresses add2, per_all_assignments_f ass2, hr_all_organization_units org2, hr_locations_all loc2 where ppf.business_group_id = :p_business_group_id and ppf.person_id = nvl(:p_person_id, ppf.person_id) and :c_effective_date between ppf2.effective_start_date and ppf2.effective_end_date and ppf2.business_group_id <> :p_business_group_id and add1.person_id(+) = ppf.person_id and nvl(add1.primary_flag,'Y') = 'Y' and :c_effective_date between nvl(add1.date_from,:c_effective_date) and nvl(add1.date_to,:c_effective_date) and add2.person_id(+) = ppf2.person_id and nvl(add2.primary_flag,'Y') = 'Y' and :c_effective_date between nvl(add2.date_from,:c_effective_date) and nvl(add2.date_to,:c_effective_date) and pbg.business_group_id = ppf.business_group_id and pbg2.business_group_id = ppf2.business_group_id and ass.person_id(+) = ppf.person_id and :c_effective_date between nvl(ass.effective_start_date,:c_effective_date) and nvl(ass.effective_end_date,:c_effective_date) and ( (ass.assignment_type in ('E','C') -- nvl(ass.assignment_type,'E') = 'E' and nvl(ass.primary_flag,'Y') = 'Y') or ((ass.assignment_type='A' ) and ass.assignment_id=(select min(assignment_id) from per_all_assignments_f ass3 where ass3.person_id=ass.person_id and ass3.assignment_type='A')) ) and ass2.person_id(+) = ppf2.person_id and :c_effective_date between nvl(ass2.effective_start_date,:c_effective_date) and nvl(ass2.effective_end_date,:c_effective_date) and ( (ass2.assignment_type in ('E','C') and nvl(ass2.primary_flag,'Y') = 'Y') or( (ass2.assignment_type='A') and ass2.assignment_id=(select min(assignment_id) from per_all_assignments_f ass4 where ass4.person_id=ass2.person_id and ass4.assignment_type='A' )) ) and org.organization_id(+) = ass.organization_id and org2.organization_id(+) = ass2.organization_id and loc.location_id(+) = ass.location_id and loc2.location_id(+) = ass2.location_id and ppf.party_id <> ppf2.party_id and (ppf.national_identifier = ppf2.national_identifier or upper(ppf.last_name) = upper(ppf2.last_name) and (upper(ppf.first_name) = upper(ppf2.first_name) or ppf.first_name is null or ppf2.first_name is null) and (ppf.date_of_birth = ppf2.date_of_birth or ppf.date_of_birth is null or ppf2.date_of_birth is null) ) union select 'HR' source, 'TCA' source2, ppf.national_identifier, null national_identifier2, ppf.party_id, hzp.party_id party_id2, hr_reports.get_party_number(ppf.party_id) party_number, hr_reports.get_party_number(hzp.party_id) party_number2, ppf.full_name, hzp.person_name full_name2, ppf.order_name, hzp.person_name order_name2, pbg.name bg_name, null bg_name2, loc.location_code, null location_code2, org.name org_name, null org_name2, add1.postal_code, null postal_code2, ppf.employee_number, null employee_number2, ppf.applicant_number, null applicant_number2, ppf.npw_number, null npw_number2 from per_all_people_f ppf, per_business_groups pbg, per_addresses add1, per_all_assignments_f ass, hr_all_organization_units org, hr_locations_all loc, hz_person_profiles hzp where ppf.business_group_id = :p_business_group_id and ppf.person_id = nvl(:p_person_id, ppf.person_id) and add1.person_id(+) = ppf.person_id and nvl(add1.primary_flag,'Y') = 'Y' and :c_effective_date between nvl(add1.date_from,:c_effective_date) and nvl(add1.date_to,:c_effective_date) and pbg.business_group_id = ppf.business_group_id and ass.person_id(+) = ppf.person_id --and nvl(ass.primary_flag,'Y') = 'Y' and :c_effective_date between nvl(ass.effective_start_date,:c_effective_date) and nvl(ass.effective_end_date,:c_effective_date) and ( (ass.assignment_type in ('E','C') and nvl(ass.primary_flag,'Y') = 'Y') or (( ass.assignment_type = 'A') and ass.assignment_id = ( select min(assignment_id) from per_all_assignments_f ass5 where ass5.person_id = ass.person_id and ass5.assignment_type = 'A'))) and org.organization_id(+) = ass.organization_id and loc.location_id(+) = ass.location_id and not exists (select null from per_all_people_f ppf2 where ppf2.party_id = hzp.party_id) and hzp.last_update_date = (select max(last_update_date) from hz_person_profiles where party_id = hzp.party_id) and (upper(ppf.last_name) = upper(hzp.person_last_name) and (upper(ppf.first_name) = upper(hzp.person_first_name) or hzp.person_first_name is null or ppf.first_name is null) and (ppf.date_of_birth = hzp.date_of_birth or ppf.date_of_birth is null or hzp.date_of_birth is null)) order by 7,5,6 Y PER PERWSDUP_XML AR PER تقرير الشخص المكرر (بتنسيق XML) Imported from BI Publisher Application: الموارد البشرية Source: تقرير الشخص المكرر (بتنسيق XML) Short Name: PERWSDUP_XML DB package: PER_PERWSDUP_XMLP_PKG D PER Doppelte Personen Imported from BI Publisher Application: Human Resources Source: Doppelte Personen (XML) Short Name: PERWSDUP_XML DB package: PER_PERWSDUP_XMLP_PKG E PER Persona Duplicada Imported from BI Publisher Application: Human Resources Source: Persona Duplicada (XML) Short Name: PERWSDUP_XML DB package: PER_PERWSDUP_XMLP_PKG F PER Etat des personnes en double Imported from BI Publisher Application: Human Resources Source: Etat des personnes en double (XML) Short Name: PERWSDUP_XML DB package: PER_PERWSDUP_XMLP_PKG I PER Rapporto Persona duplicata Imported from BI Publisher Application: Human Resources Source: Rapporto Persona duplicata (XML) Short Name: PERWSDUP_XML DB package: PER_PERWSDUP_XMLP_PKG JA PER 重複個人レポート Imported from BI Publisher Application: Human Resources Source: 重複個人レポート(XML) Short Name: PERWSDUP_XML DB package: PER_PERWSDUP_XMLP_PKG KO PER 중복 개인 보고서 Imported from BI Publisher Application: HR Source: 중복 개인 보고서(XML) Short Name: PERWSDUP_XML DB package: PER_PERWSDUP_XMLP_PKG PTB PER Relatório de Pessoa Duplicada Imported from BI Publisher Application: Human Resources Source: Relatório de Pessoa Duplicada (XML) Short Name: PERWSDUP_XML DB package: PER_PERWSDUP_XMLP_PKG RU PER Отчет о дубликатах лиц Imported from BI Publisher Application: Персонал Source: Отчет о дубликатах лиц (XML) Short Name: PERWSDUP_XML DB package: PER_PERWSDUP_XMLP_PKG S PER Dubblerade personer - rapport Imported from BI Publisher Application: Human Resources Source: Dubblerade personer - rapport (XML) Short Name: PERWSDUP_XML DB package: PER_PERWSDUP_XMLP_PKG TR PER Mükerrer Kişi Raporu Imported from BI Publisher Application: İnsan Kaynakları Source: Mükerrer Kişi Raporu (XML) Short Name: PERWSDUP_XML DB package: PER_PERWSDUP_XMLP_PKG US PER Duplicate Person Imported from BI Publisher Application: Human Resources Source: Duplicate Person Report (XML) Short Name: PERWSDUP_XML DB package: PER_PERWSDUP_XMLP_PKG ZHS PER 重复人员报表 Imported from BI Publisher Application: 人力资源管理系统 Source: 重复人员报表 (XML) Short Name: PERWSDUP_XML DB package: PER_PERWSDUP_XMLP_PKG BI Publisher :c_business_group_name :c_effective_date :c_person_name :p_business_group_id :p_conc_request_id :p_effective_date :p_person_id 1 -20 :p_business_group_id Char fnd_profile.value('PER_BUSINESS_GROUP_ID') Y AR مجموعة الأعمال D Unternehmensgruppe E Grupo de Trabajo F Entité professionnelle I Business group JA ビジネス・グループ KO 업무 그룹 PTB Grupo Funcional RU Бизнес-группа S Verksamhetsgrupp TR İş Grubu US Business Group ZHS 业务组 2 10 :p_effective_date Date select fnd_date.date_to_displaydate(sysdate) from dual Y US PER_DATES_STANDARD 3 20 :p_person_id LOV Oracle PER_DUP_PERSON_LIST Y select person_id id, full_name value, null description from per_people_f where fnd_date.canonical_to_date(:$flex$.per_dates_standard) between effective_start_date and effective_end_date and business_group_id=fnd_global.per_business_group_id order by nvl(order_name,full_name) AR اسم الشخص D Personenname E Nombre de la Persona F Nom de la personne I Nome persona JA 個人名 KO 개인명 PTB Nome da Pessoa RU Полное имя S Namn TR Kişi Adı US Person Name ZHS 人员姓名 :$flex$.per_dates_standard PER_DATES_STANDARD Y Person Name