ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223EEE63869E053B46B63588994Y Select 'Name:' || b.full_name FULL_NAME, a.person_id person_id_Master1, 'SSN:' || a.national_identifier NATIONAL_IDENTIFIER, 'Summary Action:' || substr(a.TEXT,1,360) Summary_actn, 'Person Type:' || ppt.user_person_type person_type, 'Life Event:' || e.name Lf_ev_name, --'Occurred on date:' || d.lf_evt_ocrd_dt lf_ev_dt 'Occurred on date:' || to_char(d.lf_evt_ocrd_dt,'DD-MON-YY') lf_ev_dt From ben_reporting a, ben_benefit_actions c, per_all_people_f b, ben_per_in_ler d, per_person_types ppt, ben_ler_f e Where c.request_id = :P_CONCURRENT_REQUEST_ID and c.benefit_action_id = a.benefit_action_id and a.rep_typ_cd in ( 'ERROR', 'ERROR_C', 'CLSNNOACTN', 'CLSNODEF', 'CLSNDEFNOCHG', 'CLSNDEFWCHG', 'CLSDEFNOCHG', 'CLSDEFWCHG') and a.person_id = b.person_id and b.person_type_id = ppt.person_type_id and ppt.business_group_id = b.business_group_id and c.process_date between b.effective_start_date and b.effective_end_date and c.process_date between e.effective_start_date and e.effective_end_date and d.person_id = a.person_id and nvl(d.procd_dt, c.process_date) = nvl(c.process_date, d.procd_dt) and d.ler_id = nvl(c.ler_id, d.ler_id) and d.lf_evt_ocrd_dt = nvl(c.lf_evt_ocrd_dt, d.lf_evt_ocrd_dt) and d.ler_id = e.ler_id and e.typ_cd not in ('GSP','COMP','SCHEDDU','ABS') and d.per_in_Ler_stat_cd not in ( 'BCKDT' , 'VOIDD') order by a.national_identifier asc BEN BENCLAUD_XML AR BEN أرشيف مراجعة إغلاق التسجيلات (بتنسيق XML) Application: المزايا المتقدمة Source: أرشيف مراجعة إغلاق التسجيلات (بتنسيق XML) Short Name: BENCLAUD_XML DB package: BEN_BENCLAUD_XMLP_PKG D BEN Prüfprotokoll "Anmeldungen schließen" Application: Advanced Benefits Source: Prüfprotokoll "Anmeldungen schließen" (XML) Short Name: BENCLAUD_XML DB package: BEN_BENCLAUD_XMLP_PKG F BEN Journal d'audit des souscriptions clôturées Application: Advanced Benefits Source: Journal d'audit des souscriptions clôturées (XML) Short Name: BENCLAUD_XML DB package: BEN_BENCLAUD_XMLP_PKG US BEN Close Enrollments Audit Log Application: Advanced Benefits Source: Close Enrollments Audit Log (XML) Short Name: BENCLAUD_XML DB package: BEN_BENCLAUD_XMLP_PKG ZHS BEN 关闭登记跟踪日志 Application: 高级福利 Source: 关闭登记跟踪日志 (XML) Short Name: BENCLAUD_XML DB package: BEN_BENCLAUD_XMLP_PKG BI Publisher :cp_action_item_effective_date :cp_assigned_life_event_date :cp_audit_log :cp_business_group :cp_close_action_items_flag :cp_close_mode :cp_clsdefnochg :cp_clsdefwchg :cp_clsndefnochg :cp_clsndefwchg :cp_clsnnoactn :cp_clsnodef :cp_concurrent_program_name :cp_elapsed_time :cp_end_date :cp_end_time :cp_life_event_reason :cp_location :cp_person :cp_person_selection_rule :cp_persons_errored :cp_persons_processed :cp_persons_processed_succ :cp_persons_selected :cp_persons_unprocessed :cp_plan :cp_process_date :cp_program :cp_start_date :cp_start_time :cp_status :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 并发请求编号