2571: AVG(bps.avg_workload) avg_workload,
2572: SUM(bps.calls) tot_calls, --note
2573: AVG(bps.call_length) call_length,
2574: AVG(bps.profitability) profitability
2575: FROM bic_party_summ bps,
2576: -- ams_dm_drv_stg drv
2577: ams_dm_drv_stg_gt drv -- nyostos - Sep 15, 2003 - Global Temp Table
2578: WHERE drv.party_id = bps.party_id(+)
2579: AND bps.period_start_date(+) > l_date - 365
2705: AVG(bps.avg_workload) avg_workload,
2706: SUM(bps.calls) tot_calls, --note
2707: AVG(bps.call_length) call_length,
2708: AVG(bps.profitability) profitability
2709: FROM bic_party_summ bps,
2710: -- ams_dm_drv_stg drv,
2711: ams_dm_drv_stg_gt drv, -- nyostos - Sep 15, 2003 - Global Temp Table
2712: hz_relationships hpr
2713: WHERE drv.party_id = hpr.party_id
2848: AVG(bps.avg_workload) avg_workload,
2849: SUM(bps.calls) tot_calls, --note
2850: AVG(bps.call_length) call_length,
2851: AVG(bps.profitability) profitability
2852: FROM bic_party_summ bps,
2853: -- ams_dm_drv_stg drv
2854: ams_dm_drv_stg_gt drv -- nyostos - Sep 15, 2003 - Global Temp Table
2855: WHERE bps.period_start_date(+) > l_date - 365
2856: AND bps.party_id(+) = drv.party_id