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_ACTIVITIES

Line 84: JTF_IH_ACTIVITIES JIA

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
87: AND JIIN.Resource_Id = JREV.resource_id
88: AND JIIN.start_date_time

Line 179: -- JTF_IH_ACTIVITIES table. This returns a table of records which is

175: ---------------------------------------------------------------------
176: -- PROCEDURE QUERY_ACTIVITY_RECORDS
177: ---------------------------------------------------------------------
178: -- Queries activity records for the passed interaction_id from
179: -- JTF_IH_ACTIVITIES table. This returns a table of records which is
180: -- used as the source for detail block in the call history form.
181: ---------------------------------------------------------------------
182: PROCEDURE QUERY_ACTIVITY_RECORDS
183: (P_Interaction_id IN OUT NOCOPY Number ,

Line 210: From JTF_IH_ACTIVITIES JIA

206: JIA.object_id ,
207: JIA.object_type ,
208: JIA.source_code_id ,
209: JIA.source_code
210: From JTF_IH_ACTIVITIES JIA
211: Where JIA.Interaction_id = :interaction_id' ;
212:
213: OPEN v_activity_cur FOR v_activity_sql USING p_interaction_id ;
214:

Line 302: from jtf_ih_activities

298: v_ret Number ;
299: Begin
300: v_sql :=
301: 'Select Count(*)
302: from jtf_ih_activities
303: where Interaction_id = :Interaction_Id
304: AND doc_ref = :doc_ref' ;
305:
306: EXECUTE IMMEDIATE v_sql