set pagesize 100;
--SET MARKUP HTML ON;

select 'OOL-CHARGES', f_vndr_c, f_fypd, to_char(sum(f_txn_a), '999,999,990.99'), count(*)
from commbill_dbo.t204_cb_ool_charges
group by f_fypd, f_vndr_c
union
select 'OOL-DETAILS', f_vndr_c, f_fypd, ' ', count(*)
from commbill_dbo.t204_cb_ool_details
group by f_fypd, f_vndr_c
union
select 'LDAP-CHARGES', f_vndr_c, f_fypd, to_char(sum(f_txn_a), '999,999,990.99'), count(*)
from commbill_dbo.t204_cb_ldap_charges
group by f_fypd, f_vndr_c
union
select 'LDAP-DETAILS', f_vndr_c, f_fypd, ' ', count(*)
from commbill_dbo.t204_cb_ldap_details
group by f_fypd, f_vndr_c
order by 1, 2, 3
/

exit;
