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.IEX_CALL_HISTORY dependencies on JTF_IH_INTERACTIONS

Line 56: v_interaction_id JTF_IH_INTERACTIONS.Interaction_Id%TYPE ;

52: l_cnt Number ;
53: v_interaction_cur Interaction_cursor ;
54: v_interaction_sql Varchar2(1000) ;
55: v_activity_status Varchar2(1000) ;
56: v_interaction_id JTF_IH_INTERACTIONS.Interaction_Id%TYPE ;
57:
58: CURSOR Interaction_party_cur
59: (p_party_id Number,
60: p_from_date Date,

Line 66: From JTF_IH_INTERACTIONS JIIN ,

62: IS
63: Select JIIN.interaction_id ,
64: JIIN.start_date_time ,
65: JREV.resource_name
66: From JTF_IH_INTERACTIONS JIIN ,
67: JTF_RS_RESOURCE_EXTNS_VL JREV
68: where JIIN.party_id = p_party_id
69: AND JIIN.start_date_time
70: BETWEEN p_from_date and (p_to_date + 1)

Line 82: From JTF_IH_INTERACTIONS JIIN ,

78: IS
79: Select JIIN.interaction_id ,
80: JIIN.start_date_time ,
81: JREV.resource_name
82: From JTF_IH_INTERACTIONS JIIN ,
83: JTF_RS_RESOURCE_EXTNS_VL JREV,
84: JTF_IH_ACTIVITIES JIA
85: where JIA.cust_account_id = p_cust_account_id
86: AND JIA.Interaction_Id = JIIN.Interaction_Id