ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223EEE23869E053B46B63588994 select count(*) LER_CLOSED_AMOUNT, ler.name LER_CLOSED_NAME from ben_batch_ler_info bli, ben_benefit_actions bft, ben_ler_f ler, ben_person_actions bpa where bft.benefit_action_id = bli.benefit_action_id and bft.request_id = :P_CONCURRENT_REQUEST_ID and bli.ler_id=ler.ler_id and bft.process_date between ler.effective_start_date and ler.effective_end_date and (bli.open_and_clsd_flag='Y' or bli.clsd_flag='Y') and bpa.benefit_action_id = bli.benefit_action_id and bpa.person_id = bli.person_id and bpa.action_status_cd <> 'E' group by ler.name Y BEN BENACTIV_XML AR BEN تقرير إجمالي المشاركة (بتنسيق XML) Application: المزايا المتقدمة Source: تقرير إجمالي المشاركة (بتنسيق XML) Short Name: BENACTIV_XML DB package: BEN_BENACTIV_XMLP_PKG D BEN Teilnahme - Übersicht Application: Advanced Benefits Source: Teilnahme - Übersicht (XML) Short Name: BENACTIV_XML DB package: BEN_BENACTIV_XMLP_PKG F BEN Etat de synthèse des participations Application: Advanced Benefits Source: Etat de synthèse des participations (XML) Short Name: BENACTIV_XML DB package: BEN_BENACTIV_XMLP_PKG US BEN Participation Summary Application: Advanced Benefits Source: Participation Summary Report (XML) Short Name: BENACTIV_XML DB package: BEN_BENACTIV_XMLP_PKG ZHS BEN 参与汇总报表 Application: 高级福利 Source: 参与汇总报表 (XML) Short Name: BENACTIV_XML DB package: BEN_BENACTIV_XMLP_PKG BI Publisher :cp_age_changed :cp_audit_flag :cp_business_group :cp_comb_age_los_changed :cp_comp_lvl_changed :cp_comp_object_selection_rule :cp_concurrent_program_name :cp_cr_opn_cls :cp_derivable_factors :cp_elapsed_time :cp_eligibility_profile :cp_end_date :cp_end_time :cp_enrollment_type_cycle :cp_hrs_wkd_changed :cp_just_programs :cp_late_payment :cp_legal_entity :cp_life_event_choices :cp_life_event_closed :cp_life_event_collapsed :cp_life_event_collision :cp_life_event_created :cp_life_event_dsgn_only :cp_life_event_no_effect :cp_life_event_open_and_closed :cp_life_event_reason :cp_life_event_replaced :cp_life_event_rt_pr_chg :cp_life_event_still_active :cp_lmt_by_org_flag :cp_location :cp_los_changed :cp_loss_of_eligibility :cp_max_enrollment_rchd :cp_mode :cp_no_change_to_life :cp_no_life_event_created :cp_number_of_events_created :cp_option :cp_organization :cp_payroll :cp_period_enroll_changed :cp_person :cp_person_bnft_grp :cp_person_selection_rule :cp_person_type :cp_persons_errored :cp_persons_no_potential :cp_persons_processed :cp_persons_processed_succ :cp_persons_selected :cp_persons_unprocessed :cp_persons_with_potential :cp_pft_changed :cp_plan :cp_plan_type :cp_plans_not_in_programs :cp_postal_zip_range :cp_process_date :cp_program :cp_reporting_group :cp_start_date :cp_start_time :cp_status :cp_total_closed :cp_validate :cp_variable_rate_profile :cp_voulntary_end_cvg :cp_waiting_satisfied :cp_with_active_life_event :cp_without_active_life_event :p_conc_request_id :p_concurrent_request_id :run_mode 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 并发请求编号