eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BIX_DM_AGENT_CALL_SUMMARY_PKG dependencies on JTF_IH_ACTIVITIES

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 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 647: jtf_ih_activities act,

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
651: and int.resource_id = p_resource_id

Line 695: jtf_ih_activities act,

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
699: and act.media_id = p_media_id

Line 756: OR EXISTS (SELECT act.interaction_id from jtf_ih_activities act

752: WHERE resource_id = p_resource_id
753: AND
754: (
755: productive_time_amount = p_media_id
756: OR EXISTS (SELECT act.interaction_id from jtf_ih_activities act
757: WHERE act.media_id = p_media_id
758: AND act.interaction_id = int.interaction_id
759: )
760: );

Line 1071: opportunities are using the mdeia_id on jtf_ih_activities table.

1067: /**Change on 20-Mar-2002:
1068: Outcomes will be retrieved at interaction level not activities.
1069: Also, depending on whether it is a service request or lead etc
1070: change the join conditions. This is because right now, leads and
1071: opportunities are using the mdeia_id on jtf_ih_activities table.
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

Line 1073: However for service requests, the media_id of jtf_ih_activities

1069: Also, depending on whether it is a service request or lead etc
1070: change the join conditions. This is because right now, leads and
1071: opportunities are using the mdeia_id on jtf_ih_activities table.
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:

Line 1088: jtf_ih_activities a,

1084: a.doc_ref DOC_REF,
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

Line 1476: jtf_ih_activities act

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;
1480:

Line 2135: jtf_ih_activities act

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;
2139: IF (g_debug_flag = 'Y') THEN

Line 2577: jtf_ih_activities act

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;
2581: EXCEPTION