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 BIX_DM_CONNECT_LOOKUPS

Line 648: bix_dm_connect_lookups clook,

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

Line 696: bix_dm_connect_lookups clook,

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
700: AND int.outcome_id = clook.outcome_id (+)

Line 3931: bix_dm_connect_lookups clook,

3927: clook.contact_flag CONTACT_FLAG,
3928: rlook.positive_response_flag POSITIVE_RESPONSE_FLAG,
3929: sum(call_stage.OUT_CALLS_DIALED) NUMBER_OF_CALLS
3930: FROM bix_dm_interface call_stage,
3931: bix_dm_connect_lookups clook,
3932: bix_dm_response_lookups rlook
3933: WHERE clook.outcome_id (+) = call_stage.outcome_id
3934: --AND rlook.outcome_id (+) = call_stage.outcome_id
3935: AND rlook.result_id (+) = call_stage.result_id