APPS.BIX_AGT_COLLECT dependencies on BIX_INTERACTIONS

Line 43: FROM bix_interactions

39: SELECT interaction_center_id,
40: sum(talk_time) talk_time,
41: sum(wrap_time) wrap_time,
42: SUM(DECODE(NVL(USER_ATTRIBUTE2,'F'),'T',1,NULL)) calls_answered
43: FROM bix_interactions
44: WHERE resource_id = v_resource_id
45: AND start_ts BETWEEN v_ses_start_date AND v_ses_end_date
46: group by interaction_center_id;
47: