ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223EEE53869E053B46B63588994 select ppf.full_name person_full_name, ler.name||'('||ler.ler_id||')' life_event_name, ppf.person_id person_id_Master, ppf.national_identifier, ppf.date_of_birth, hr_general.decode_lookup('SEX',ppf.sex) gender, hr_general.decode_lookup('MAR_STATUS',ppf.marital_status) marital_status, ppt.user_person_type person_type, pps.date_start hire_date, pad.postal_code postal_code, job.name job_name, pos.name position_name, gra.name grade_name, pap.payroll_name, loc.location_code, org.name org_name, org2.name legal_entity_name, bng.name benefit_group_name from per_all_people_f ppf, ben_benfts_grp bng, per_periods_of_service pps, per_addresses pad, per_all_assignments_f paf, per_jobs_vl job, hr_all_positions_f_vl pos, per_grades_vl gra, pay_all_payrolls_f pap, hr_all_organization_units_vl org, hr_all_organization_units_vl org2, hr_soft_coding_keyflex soft, hr_locations loc, per_person_types ppt, ben_ler_f ler, ben_person_actions pac, ben_benefit_actions bac where bac.request_id = :p_concurrent_request_id and bac.benefit_action_id = pac.benefit_action_id and bac.business_group_id = nvl(ler.business_group_id,bac.business_group_id) and pac.action_status_cd = 'P' and ler.ler_id(+) = pac.ler_id and paf.person_id(+) = ppf.person_id and nvl(paf.primary_flag,'Y') = 'Y' and paf.assignment_type <> 'C' and bac.process_date between nvl(paf.effective_start_date,bac.process_date) and nvl(paf.effective_end_date,bac.process_date) and paf.job_id = job.job_id(+) and bac.process_date between nvl(job.date_from,bac.process_date) and nvl(job.date_to,bac.process_date) and paf.position_id = pos.position_id(+) and bac.process_date between nvl(pos.effective_start_date,bac.process_date) and nvl(pos.effective_end_date,bac.process_date) and bac.process_date between nvl(pos.date_effective,bac.process_date) and nvl(pos.date_end,bac.process_date) and paf.grade_id = gra.grade_id(+) and bac.process_date between nvl(gra.date_from,bac.process_date) and nvl(gra.date_to,bac.process_date) and paf.payroll_id = pap.payroll_id(+) and bac.process_date between nvl(pap.effective_start_date,bac.process_date) and nvl(pap.effective_end_date,bac.process_date) and paf.location_id = loc.location_id(+) and paf.organization_id = org.organization_id(+) and bac.process_date between nvl(org.date_from,bac.process_date) and nvl(org.date_to,bac.process_date) and paf.soft_coding_keyflex_id = soft.soft_coding_keyflex_id(+) and org2.organization_id(+) = soft.segment1 and bac.process_date between nvl(ler.effective_start_date,bac.process_date) and nvl(ler.effective_end_date,bac.process_date) and pac.person_id = ppf.person_id and bac.business_group_id = ppf.business_group_id +0 and bac.process_date between ppf.effective_start_date and ppf.effective_end_date and ppf.benefit_group_id = bng.benfts_grp_id(+) and ppf.person_type_id = ppt.person_type_id and ppt.business_group_id = ppf.business_group_id and pps.person_id(+) = ppf.person_id and ppf.business_group_id = nvl(pps.business_group_id, ppf.business_group_id) and pad.person_id(+) = ppf.person_id and nvl(pad.primary_flag,'Y') = 'Y' and bac.process_date between nvl(pad.date_from,bac.process_date) and nvl(pad.date_to,bac.process_date) order by ppf.full_name Y BEN BENBOSUM_XML AR BEN تقرير إجمالي التراجع عن أحداث العمر (بتنسيق XML) Application: المزايا المتقدمة Source: تقرير إجمالي التراجع عن أحداث العمر (بتنسيق XML) Short Name: BENBOSUM_XML DB package: BEN_BENBOSUM_XMLP_PKG D BEN Veränderungen zurücksetzen - Übersicht Application: Advanced Benefits Source: Veränderungen zurücksetzen - Übersicht (XML) Short Name: BENBOSUM_XML DB package: BEN_BENBOSUM_XMLP_PKG F BEN Etat de synthèse de l'annulation d'événements personnels Application: Advanced Benefits Source: Etat de synthèse de l'annulation d'événements personnels (XML) Short Name: BENBOSUM_XML DB package: BEN_BENBOSUM_XMLP_PKG US BEN Back-out Life Events Summary Application: Advanced Benefits Source: Back-out Life Events Summary Report (XML) Short Name: BENBOSUM_XML DB package: BEN_BENBOSUM_XMLP_PKG ZHS BEN 取消人生事件汇总报表 Application: 高级福利 Source: 取消人生事件汇总报表 (XML) Short Name: BENBOSUM_XML DB package: BEN_BENBOSUM_XMLP_PKG BI Publisher :cp_business_group :cp_concurrent_program_name :cp_elapsed_time :cp_end_date :cp_end_time :cp_from_ocrd_dt :cp_legal_entity :cp_lf_evt_bo :cp_lf_evt_bo_cls :cp_lf_evt_bo_ip_we :cp_lf_evt_bo_ip_woe :cp_life_event_reason :cp_location :cp_organization :cp_people_lf_evt_bo :cp_person_bnft_grp :cp_person_selection_rule :cp_persons_errored :cp_persons_processed :cp_persons_processed_succ :cp_persons_selected :cp_persons_unprocessed :cp_process_date :cp_resulting_status :cp_start_date :cp_start_time :cp_to_ocrd_dt :cp_validate :p_conc_request_id :p_concurrent_request_id 1 10 :p_concurrent_request_id LOV Oracle BEN_BATCH_REQUESTS Y select request_id id, request_id value, null description from ben_benefit_actions where business_group_id= fnd_global.per_business_group_id order by request_id Y AR معرف طلب التزامن D Hintergrundprozess-Nr. F Numéro du traitement simultané US Concurrent Request ID ZHS 并发请求编号