APPS.BIX_AGT_COLLECT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 20

  select sum((iss.end_date_time - iss.begin_date_time) * 24 * 3600) login_time,
         iss.resource_id,
         iss.begin_date_time ,
         iss.end_date_time
  from   ieu_sh_sessions iss
   where	 iss.begin_date_time between p_start_date and p_end_date
           and iss.active_flag is NULL
   group by iss.resource_id, iss.begin_date_time,iss.end_date_time;

Line: 30

  select sum((isa.end_date_time - isa.begin_date_time) * 24 * 3600) available_time
  from   ieu_sh_activities isa, ieu_sh_sessions iss
   where isa.session_id = iss.session_id
	    and isa.activity_type_code = 'WORK_REQUEST'
	    and iss.begin_date_time =  v_ses_start_date
	    and iss.ACTIVE_FLAG is NULL
	    and iss.resource_id = v_resource_id;

Line: 39

  SELECT interaction_center_id,
         sum(talk_time) talk_time,
         sum(wrap_time) wrap_time,
         SUM(DECODE(NVL(USER_ATTRIBUTE2,'F'),'T',1,NULL)) calls_answered
  FROM   bix_interactions
  WHERE  resource_id = v_resource_id
  AND    start_ts BETWEEN  v_ses_start_date AND v_ses_end_date
  group by interaction_center_id;

Line: 51

  SELECT sum((act.end_date_time - act.start_date_time) * 24 * 3600) wrap_time
  FROM   jtf_ih_activities act, ieu_sh_activities isa, jtf_ih_interactions int,  jtf_ih_action_items_vl actitems
  WHERE  act.media_id = isa.media_id
  AND    act.interaction_id = int.interaction_id
  AND    int.resource_id = v_resource_id
  AND    (act.start_date_time, 'DD/MON/YYYY') = v_day
  AND    act.action_item_id = actitems.action_item_id
  AND    actitems.action_item = 'Wrapup';

Line: 63

  SELECT sum((int.end_date_time - seg.end_date_time) * 24 * 3600) wrap_time
  FROM   jtf_ih_interactions int, jtf_ih_media_item_lc_segs seg, jtf_ih_media_itm_lc_seg_tys tys, ieu_sh_activities isa, ieu_sh_sessions iss
  WHERE  iss.resource_id = v_resource_id
  AND    iss.begin_date_time = v_day
  AND    iss.active_flag is null
  AND    isa.session_id = iss.session_id
  AND    int.productive_time_amount = isa.media_id
  AND    seg.media_id = int.productive_time_amount
  AND    seg.resource_id = int.resource_id
  AND    seg.milcs_type_id = tys.milcs_type_id
  AND    tys.milcs_code = 'WITH_AGENT'
  AND    int.end_date_time > seg.end_date_time;

Line: 79

  SELECT server_group_id center_id
  FROM   jtf_rs_resource_extns
  WHERE  resource_id = v_resource_id;

Line: 87

      DELETE from BIX_SUM_AGENT
      WHERE  day between p_start_date and p_end_date;

Line: 148

         INSERT INTO BIX_SUM_AGENT
      	(
          INTERACTION_CENTER_ID,
          RESOURCE_ID,
          TALK_TIME,
          AVAILABLE_TIME,
          WRAP_TIME,
          IDLE_TIME,
          LOGGED_IN_TIME,
          CALLS_ANSWERED,
	  DAY
          )
         VALUES
         (
	 v_center_id,
	 v_resource_id,
         v_talk_time,
         v_available_time,
	 v_wrap_time,
 	 v_idle_time,
	 v_logged_in_time,
	 v_calls_answered,
         v_ses_start_date
	);