BEN Extract Summary

Description

Application: Advanced Benefits
Source: Extract Summary Report (XML)
Short Name: BENXSMRY_XML
DB package: BEN_BENXSMRY_XMLP_PKG

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Copy

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