ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223EEFF3869E053B46B63588994Y SELECT a. ext_rslt_id ext_rslt_id_mas, --SELECT a. ext_rslt_id, a.request_id request_id_mas, --a.request_id, to_char(a.run_strt_dt, 'DD-MON-YYYY') start_date, to_char(a.run_strt_dt, 'HH24:MI:SS') start_time, to_char(a.run_end_dt, 'HH24:MI:SS') end_time, c.meaning status, b.name "Extract Name", a.ext_strt_dt, a.ext_end_dt, a.eff_dt, a.output_name, a.drctry_name, a.business_group_id, BEN_BENXSMRY_XMLP_PKG.business_groupformula(a.business_group_id) Business_group, BEN_BENXSMRY_XMLP_PKG.total_peopleformula(:people_count_dummy, :error_count_dummy) total_people FROM ben_ext_rslt a, ben_ext_dfn b, hr_lookups c WHERE a.ext_dfn_id = b.ext_dfn_id AND a.ext_rslt_id = :p_ext_rslt_id AND a.ext_stat_cd = c.lookup_code AND c.lookup_type = 'BEN_EXT_STAT' order by a.business_group_id BEN BENXSMRY_XML AR BEN تقرير إجمالي الاستخراج (بتنسيق XML) Application: المزايا المتقدمة Source: تقرير إجمالي الاستخراج (بتنسيق XML) Short Name: BENXSMRY_XML DB package: BEN_BENXSMRY_XMLP_PKG D BEN Leistungsexport - Übersicht Application: Advanced Benefits Source: Leistungsexport - Übersicht (XML) Short Name: BENXSMRY_XML DB package: BEN_BENXSMRY_XMLP_PKG F BEN Etat de synthèse d'extraction Application: Advanced Benefits Source: Etat de synthèse d'extraction (XML) Short Name: BENXSMRY_XML DB package: BEN_BENXSMRY_XMLP_PKG US BEN Extract Summary Application: Advanced Benefits Source: Extract Summary Report (XML) Short Name: BENXSMRY_XML DB package: BEN_BENXSMRY_XMLP_PKG ZHS BEN 提取汇总报表 Application: 高级福利 Source: 提取汇总报表 (XML) Short Name: BENXSMRY_XML DB package: BEN_BENXSMRY_XMLP_PKG BI Publisher :error_count_dummy :p_conc_request_id :p_ext_rslt_id :people_count_dummy 1 10 :p_ext_rslt_id LOV Oracle BEN_EXT_RSLT Y select a.ext_rslt_id id, a.request_id value, null description from ben_ext_rslt a,ben_ext_dfn b where a.business_group_id=fnd_global.per_business_group_id and a.ext_dfn_id=b.ext_dfn_id order by a.run_strt_dt desc Y AR معرف الطلب D Prozess-Nr. F Numéro de traitement US Request ID ZHS 请求编号