ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4718851A9E05362FB09050512Y select a.*, PER_PERRPADD_XMLP_PKG.cf_addr_chkformula(gre_name, person_id, cnt, address_id, add_date_to, effective_start_date, effective_end_date, date_from, address_line1, location_address, town_or_city, address_line2, address_line3) CF_addr_chk, PER_PERRPADD_XMLP_PKG.CP_print_gre_p CP_print_gre, PER_PERRPADD_XMLP_PKG.CP_missing_flag_p CP_missing_flag, PER_PERRPADD_XMLP_PKG.CP_old_address_id_p CP_old_address_id, PER_PERRPADD_XMLP_PKG.CP_prev_person_id_p CP_prev_person_id, PER_PERRPADD_XMLP_PKG.CP_prev_name_p CP_prev_name, PER_PERRPADD_XMLP_PKG.CP_temp_id_p CP_temp_id, PER_PERRPADD_XMLP_PKG.CP_prev_gre_name_p CP_prev_gre_name, PER_PERRPADD_XMLP_PKG.CP_addr_count_p CP_addr_count, PER_PERRPADD_XMLP_PKG.CP_missing_st_p CP_missing_st, PER_PERRPADD_XMLP_PKG.CP_missing_end_p CP_missing_end, PER_PERRPADD_XMLP_PKG.CP_reason_p CP_reason, PER_PERRPADD_XMLP_PKG.CP_reason1_p CP_reason1, PER_PERRPADD_XMLP_PKG.CP_missing_st1_p CP_missing_st1, PER_PERRPADD_XMLP_PKG.CP_missing_end1_p CP_missing_end1, PER_PERRPADD_XMLP_PKG.CP_keep_count_p CP_keep_count, PER_PERRPADD_XMLP_PKG.CP_prev_date_to_p CP_prev_date_to from (select person_id, effective_start_date, effective_end_date, address_id, address_line1, location_address, address_line2, address_line3, town_or_city, add_date_to, date_from, employee_number, full_name, gre_name, count(address_id) over( partition by person_id,effective_start_date,effective_end_date,employee_number,full_name) cnt from (select people.person_id, people.effective_start_date, people.effective_end_date, addr.address_id, addr.address_line1, addr.address_line2 || address_line3 location_address, addr.address_line2, addr.address_line3, addr.town_or_city, nvl(addr.date_to, TO_DATE('31/12/4712','dd/mm/yyyy')) add_date_to , addr.date_from, people.employee_number, full_name, hou.name gre_name from hr_soft_coding_keyflex hr1, hr_organization_units hou, pay_us_zip_codes zip, pay_us_city_names city, pay_us_counties county, pay_us_states state, per_assignments_f asg, per_addresses addr, per_people_f people where to_char(hou.organization_id) = hr1.segment1 and hou.organization_id = nvl(:gre_id, hou.organization_id) and addr.region_2 = state.state_abbrev and addr.region_1 = county.county_name and addr.town_or_city = city.city_name and substr(addr.postal_code,1,5) between zip.zip_start and zip.zip_end and ((addr.add_information17 is null and addr.add_information18 is null and addr.add_information19 is null and addr.add_information20 is null) or exists (select null from pay_us_states st, pay_us_counties cou, pay_us_zip_codes zip, pay_us_city_names cty where cou.state_code = st.state_code and st.state_code = cty.state_code and zip.state_code = cty.state_code and zip.county_code = cty.county_code and zip.city_code = cty.city_code and substr(addr.add_information20,1,5) between zip.zip_start and zip.zip_end and st.state_abbrev = addr.add_information17 and cou.county_name = addr.add_information19 and cty.city_name = addr.add_information18)) and state.state_code = county.state_code and county.state_code = city.state_code and county.county_code = city.county_code and city.state_code = zip.state_code and city.county_code = zip.county_code and city.city_code = zip.city_code and hr1.soft_coding_keyflex_id = asg.soft_coding_keyflex_id and asg.person_id = people.person_id and addr.date_from <= :input_end_date and nvl(addr.date_to, TO_DATE('31/12/4712','dd/mm/yyyy')) >= :input_start_date and addr.date_from <= people.effective_end_date and nvl(addr.date_to, TO_DATE('31/12/4712','dd/mm/yyyy')) >= people.effective_start_date and addr.primary_flag = 'Y' and people.person_id = addr.person_id and people.effective_start_date <= :input_end_date and people.effective_end_date >= :input_start_date and people.business_group_id + 0 = :business_id and people.current_employee_flag = 'Y' UNION select people.person_id, people.effective_start_date, people.effective_end_date, TO_NUMBER(NULL), TO_CHAR(NULL), TO_CHAR(NULL), TO_CHAR(NULL), TO_CHAR(NULL), TO_CHAR(NULL), TO_DATE(NULL), TO_DATE(NULL), people.employee_number, full_name, hou.name gre_name from hr_soft_coding_keyflex hr1, hr_organization_units hou, per_assignments_f asg, per_people_f people where to_char(hou.organization_id) = hr1.segment1 and hou.organization_id = nvl(:gre_id,hou.organization_id) and hr1.soft_coding_keyflex_id = asg.soft_coding_keyflex_id and asg.person_id = people.person_id and people.effective_start_date <= :input_end_date and people.effective_end_date >= :input_start_date and people.business_group_id + 0 = :business_id and people.current_employee_flag = 'Y' and NOT EXISTS ( select addr_null.address_id from per_addresses addr_null where addr_null.person_id = people.person_id and addr_null.primary_flag = 'Y' ) )) a order by 14,1,2,3,11 PER PERRPADD_XML AR PER تقرير العناوين غير الصحيحة (بتنسيق XML) Imported from BI Publisher Application: الموارد البشرية Source: تقرير العناوين غير الصحيحة (بتنسيق XML) Short Name: PERRPADD_XML DB package: PER_PERRPADD_XMLP_PKG D PER Ungültige Adressen Imported from BI Publisher Application: Human Resources Source: Ungültige Adressen (XML) Short Name: PERRPADD_XML DB package: PER_PERRPADD_XMLP_PKG E PER Dirección No Válida Imported from BI Publisher Application: Human Resources Source: Dirección No Válida (XML) Short Name: PERRPADD_XML DB package: PER_PERRPADD_XMLP_PKG F PER Etat adresse invalide Imported from BI Publisher Application: Human Resources Source: Etat adresse invalide (XML) Short Name: PERRPADD_XML DB package: PER_PERRPADD_XMLP_PKG I PER Rapporto Indirizzo non valido Imported from BI Publisher Application: Human Resources Source: Rapporto Indirizzo non valido (XML) Short Name: PERRPADD_XML DB package: PER_PERRPADD_XMLP_PKG JA PER 無効な住所レポート Imported from BI Publisher Application: Human Resources Source: 無効な住所レポート(XML) Short Name: PERRPADD_XML DB package: PER_PERRPADD_XMLP_PKG KO PER 유효하지 않은 주소 보고서 Imported from BI Publisher Application: HR Source: 유효하지 않은 주소 보고서(XML) Short Name: PERRPADD_XML DB package: PER_PERRPADD_XMLP_PKG PTB PER Relatório de Endereço Inválido Imported from BI Publisher Application: Human Resources Source: Relatório de Endereço Inválido (XML) Short Name: PERRPADD_XML DB package: PER_PERRPADD_XMLP_PKG RU PER Отчет о недопустимых адресах Imported from BI Publisher Application: Персонал Source: Отчет о недопустимых адресах (XML) Short Name: PERRPADD_XML DB package: PER_PERRPADD_XMLP_PKG S PER Ogiltiga adresser - rapport Imported from BI Publisher Application: Human Resources Source: Ogiltiga adresser - rapport (XML) Short Name: PERRPADD_XML DB package: PER_PERRPADD_XMLP_PKG TR PER Geçersiz Adres Raporu Imported from BI Publisher Application: İnsan Kaynakları Source: Geçersiz Adres Raporu (XML) Short Name: PERRPADD_XML DB package: PER_PERRPADD_XMLP_PKG US PER Invalid Address Imported from BI Publisher Application: Human Resources Source: Invalid Address Report (XML) Short Name: PERRPADD_XML DB package: PER_PERRPADD_XMLP_PKG ZHS PER 无效地址报表 Imported from BI Publisher Application: 人力资源管理系统 Source: 无效地址报表 (XML) Short Name: PERRPADD_XML DB package: PER_PERRPADD_XMLP_PKG BI Publisher :additional_verification :business_id :cp_addr_count :cp_keep_count :cp_missing_end :cp_missing_end1 :cp_missing_flag :cp_missing_st :cp_missing_st1 :cp_old_address_id :cp_prev_date_to :cp_prev_gre_name :cp_prev_name :cp_prev_person_id :cp_print_gre :cp_reason :cp_reason1 :cp_temp_id :gre_id :input_end_date :input_start_date :line_length :lp_input_end_date :lp_input_start_date :p_conc_request_id :p_install 1 -20 :business_id Number fnd_profile.value('PER_BUSINESS_GROUP_ID') Y AR معرف الأعمال D Unternehmenskennung E Id Negocio F ID entité I Id azienda JA ビジネスID KO 업무 ID PTB Id de Negócios RU Код деятельности S Verksamhets-id TR İş No US Business Id ZHS 业务标识 2 10 :input_start_date Date Y AR تاريخ البداية D Startdatum E Fecha de Inicio F Date de début I Data inizio JA 開始日 KO 시작 일자 PTB Data Inicial RU Начальная дата S Startdatum TR Başlangıç Tarihi US Start Date ZHS 起始日期 3 20 :input_end_date Date Y AR تاريخ النهاية D Enddatum E Fecha de Finalización F Date de fin I Data fine JA 終了日 KO 종료 일자 PTB Data Final RU Конечная дата S Slutdatum TR Bitiş Tarihi US End Date ZHS 终止日期 4 30 :gre_id LOV Oracle HR_US_TAX_UNIT Y select txu.tax_unit_id id, txu.name value, null description from hr_tax_units_v txu where txu.business_group_id= fnd_global.per_business_group_id order by value,description AR الجهة الحكومية D Meldepflichtiger I Entità fiscale governativa (US) RU Юридическое лицо S Statlig rapp.enhet TR Tüzel Kişi US GRE