ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223EEFE3869E053B46B63588994 SELECT b.ext_file_id "File Id", f.seq_num, 'Record ' || to_char(f.seq_num) || ':' || c.name "Record Name", g.seq_num "Data Element Seq", d.ext_data_elmt_id "Ext Data Element", d.name "Data Element Name", g.strt_pos "Start Position", g.dlmtr_val "Delimiter", g.rqd_flag "Required", nvl(d.just_cd, 'L') "Just", h.meaning "Format Mask", d.data_elmt_typ_cd "Data Element Type", d.string_val "String Value", decode(d.data_elmt_typ_cd, 'D', ' ' || d.dflt_val) "Default Value", d.ttl_fnctn_cd "Total Function", d.ttl_cond_oper_cd "Operator", d.ttl_cond_val "Condition Value", d.ttl_sum_ext_data_elmt_id "Sum Data Element", d.ttl_cond_ext_data_elmt_id "Condition Data Element", ' ' || e.dcd_val "Decode Value", BEN_BENXLAYT_XMLP_PKG.commentsformula(d.ttl_fnctn_cd, d.data_elmt_typ_cd, d.string_val, d.ttl_cond_ext_data_elmt_id, d.ext_data_elmt_id, d.ttl_sum_ext_data_elmt_id) Comments FROM ben_ext_file b, ben_ext_rcd c, ben_ext_data_elmt d, ben_ext_data_elmt_decd e, ben_ext_rcd_in_file f, ben_ext_data_elmt_in_rcd g, hr_lookups h WHERE b.ext_file_id = f.ext_file_id AND f.ext_rcd_id = c.ext_rcd_id AND f.hide_flag <> 'Y' AND c.ext_rcd_id = g.ext_rcd_id AND g.hide_flag <> 'Y' AND g.ext_data_elmt_id = d.ext_data_elmt_id AND d.ext_data_elmt_id = e.ext_data_elmt_id (+) AND d.frmt_mask_cd = h.lookup_code (+) AND h.lookup_type (+) = 'BEN_EXT_FRMT_MASK' and b.ext_file_id=:Dfn_File_Id --ORDER BY f.seq_num,3 ORDER BY f.seq_num, d.ext_data_elmt_id, g.seq_num,3 Y BEN BENXLAYT_XML AR BEN تقرير نسق الاستخراج (بتنسيق XML) Application: المزايا المتقدمة Source: تقرير نسق الاستخراج (بتنسيق XML) Short Name: BENXLAYT_XML DB package: BEN_BENXLAYT_XMLP_PKG D BEN Leistungsexport - Layout Application: Advanced Benefits Source: Leistungsexport - Layout (XML) Short Name: BENXLAYT_XML DB package: BEN_BENXLAYT_XMLP_PKG F BEN Etat de présentation d'extraction Application: Advanced Benefits Source: Etat de présentation d'extraction (XML) Short Name: BENXLAYT_XML DB package: BEN_BENXLAYT_XMLP_PKG US BEN Extract Layout Application: Advanced Benefits Source: Extract Layout Report (XML) Short Name: BENXLAYT_XML DB package: BEN_BENXLAYT_XMLP_PKG ZHS BEN 提取布局报表 Application: 高级福利 Source: 提取布局报表 (XML) Short Name: BENXLAYT_XML DB package: BEN_BENXLAYT_XMLP_PKG BI Publisher :dfn_file_id :p_conc_request_id :p_ext_dfn_id 1 10 :p_ext_dfn_id LOV Oracle BEN_EXT_DFN Y select ed.ext_dfn_id id, ed.name value, null description from ben_ext_dfn ed,hr_lookups hrl,per_business_groups bg where ((bg.business_group_id=ed.business_group_id) or (bg.legislation_code=ed.legislation_code) or (ed.business_group_id is null and ed.legislation_code is null)) and bg.business_group_id=fnd_global.per_business_group_id and ed.data_typ_cd=hrl.lookup_code and hrl.lookup_type='BEN_EXT_DATA_TYP' order by ed.name Y AR اسم الاستخراج D Exportbezeichnung F Nom de l'extraction US Extract Name ZHS 提取名称