APPS.BIX_DM_AGENT_CALL_SUMMARY_PKG dependencies on JTF_IH_INTERACTIONS

Line 411: from jtf_ih_interactions

407: BEGIN
408:
409: select SOURCE_CODE
410: into v_source_code
411: from jtf_ih_interactions
412: where productive_time_amount = p_media_id
413: and SOURCE_CODE is not null
414: and rownum = 1;
415:

Line 421: from jtf_ih_interactions int, jtf_ih_activities act

417: WHEN NO_DATA_FOUND
418: THEN
419: select int.SOURCE_CODE
420: into v_source_code
421: from jtf_ih_interactions int, jtf_ih_activities act
422: where int.interaction_id = act.interaction_id
423: AND act.media_id = p_media_id
424: and int.SOURCE_CODE is not null
425: and rownum = 1;

Line 510: from jtf_ih_interactions

506: BEGIN
507:
508: select max(end_date_time)
509: into int_end_date_time
510: from jtf_ih_interactions
511: where resource_id = p_resource_id
512: and productive_time_amount = p_media_id;
513:
514: IF int_end_date_time IS NULL

Line 519: from jtf_ih_interactions int, jtf_ih_activities act

515: THEN
516:
517: select max(int.end_date_time)
518: into int_end_date_time
519: from jtf_ih_interactions int, jtf_ih_activities act
520: where int.resource_id = p_resource_id
521: and int.interaction_id = act.interaction_id
522: AND act.media_id = p_media_id;
523:

Line 566: from jtf_ih_interactions int1, jtf_ih_activities act1

562:
563: --select earliest agent who made/took the call
564: select resource_id
565: into v_resource_id
566: from jtf_ih_interactions int1, jtf_ih_activities act1
567: where int1.start_date_time =
568: (select min(int2.start_date_time)
569: from jtf_ih_interactions int2, jtf_ih_activities act2
570: where act2.media_id = p_media_id

Line 569: from jtf_ih_interactions int2, jtf_ih_activities act2

565: into v_resource_id
566: from jtf_ih_interactions int1, jtf_ih_activities act1
567: where int1.start_date_time =
568: (select min(int2.start_date_time)
569: from jtf_ih_interactions int2, jtf_ih_activities act2
570: where act2.media_id = p_media_id
571: and act2.interaction_id = int2.interaction_id
572: and int2.resource_id <> 0 --avoid PREVIEW calls have resourceid of 0
573: and int2.resource_id <> g_ao_dummy_resource

Line 646: from jtf_ih_interactions int,

642: g_pr_count,
643: g_connect_count,
644: g_nonconnect_count,
645: g_other_count
646: from jtf_ih_interactions int,
647: jtf_ih_activities act,
648: bix_dm_connect_lookups clook,
649: bix_dm_response_lookups rlook
650: where int.interaction_id = act.interaction_id

Line 694: from jtf_ih_interactions int,

690: g_pr_count,
691: g_connect_count,
692: g_nonconnect_count,
693: g_other_count
694: from jtf_ih_interactions int,
695: jtf_ih_activities act,
696: bix_dm_connect_lookups clook,
697: bix_dm_response_lookups rlook
698: where int.interaction_id = act.interaction_id

Line 751: FROM jtf_ih_interactions int

747: AND resource_id = p_resource_id;
748:
749: SELECT min(start_date_time), max(end_date_time)
750: INTO l_int_start_time, l_int_end_time
751: FROM jtf_ih_interactions int
752: WHERE resource_id = p_resource_id
753: AND
754: (
755: productive_time_amount = p_media_id

Line 1076: column of jtf_ih_interactions is populated with the media_id.

1072: So we can join with this.
1073: However for service requests, the media_id of jtf_ih_activities
1074: is populated only for the "CALL ANSWERED" activity. For other actvities
1075: media_id is null on activites table. The productive_time_amount
1076: column of jtf_ih_interactions is populated with the media_id.
1077:
1078: ***/
1079:
1080: CURSOR activity_info (p_media_id NUMBER, p_resource_id NUMBER) is

Line 1089: jtf_ih_interactions b

1085: a.doc_id DOC_ID,
1086: a.start_date_time ACT_START_TIME
1087: from
1088: jtf_ih_activities a,
1089: jtf_ih_interactions b
1090: where
1091: (
1092: a.media_id = p_media_id
1093: OR b.productive_time_amount = p_media_id

Line 1475: from jtf_ih_interactions int,

1471: SELECT DISTINCT int.outcome_id,
1472: int.result_id,
1473: int.reason_id
1474: INTO l_outcome_id, l_result_id, l_reason_id
1475: from jtf_ih_interactions int,
1476: jtf_ih_activities act
1477: where int.interaction_id = act.interaction_id
1478: and int.resource_id = l_current_resource_id
1479: and act.media_id = call.media_id;

Line 2134: from jtf_ih_interactions int,

2130: SELECT DISTINCT int.outcome_id,
2131: int.result_id,
2132: int.reason_id
2133: INTO l_outcome_id, l_result_id, l_reason_id
2134: from jtf_ih_interactions int,
2135: jtf_ih_activities act
2136: where int.interaction_id = act.interaction_id
2137: and int.resource_id = l_current_resource_id
2138: and act.media_id = call.media_id;

Line 2576: from jtf_ih_interactions int,

2572: SELECT DISTINCT int.outcome_id,
2573: int.result_id,
2574: int.reason_id
2575: INTO l_outcome_id, l_result_id, l_reason_id
2576: from jtf_ih_interactions int,
2577: jtf_ih_activities act
2578: where int.interaction_id = act.interaction_id
2579: and act.media_id = call.media_id
2580: and rownum = 1;