BEN Extract Layout
Description
Categories: BI Publisher
Application: Advanced Benefits
Source: Extract Layout Report (XML)
Short Name: BENXLAYT_XML
DB package: BEN_BENXLAYT_XMLP_PKG
Source: Extract Layout Report (XML)
Short Name: BENXLAYT_XML
DB package: BEN_BENXLAYT_XMLP_PKG
Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS
Contact us to schedule a demo or if you need help with the installation
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 |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Extract Name |
|
LOV Oracle |