APPS.BIX_DM_AGENT_CALL_SUMMARY_PKG dependencies on BIX_DM_RESPONSE_LOOKUPS

Line 649: bix_dm_response_lookups rlook

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

Line 697: bix_dm_response_lookups rlook

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

Line 3932: bix_dm_response_lookups rlook

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
3936: AND call_stage.row_type IN ('C', 'A') --ignore activity type rows