APPS.IEX_PROFILE dependencies on JTF_IH_ACTIVITIES

Line 283: -- JTF_IH_ACTIVITIES_VL JIA

279: --JTF_IH_RESULTS_VL JIRV,
280: -- JTF_IH_RESULTS_B JIRB,
281: -- JTF_IH_RESULTS_TL JIRV,
282: --END BUG 4930386 jsanju 01/10/06
283: -- JTF_IH_ACTIVITIES_VL JIA
284: -- WHERE JII.resource_id = JRREV.resource_id
285: -- AND jii.interaction_id = jia.interaction_id
286: -- AND JIOV.Outcome_id = JII.outcome_id
287:

Line 298: -- jtf_ih_activities a

294: -- AND jia.cust_account_id = cust_acct_id
295: -- AND JII.start_date_time =
296: -- (select Max(i.start_date_time)
297: -- from jtf_ih_interactions i,
298: -- jtf_ih_activities a
299: -- where a.cust_account_id = cust_acct_id
300: -- AND a.interaction_id = i.interaction_id) ;
301:
302: SELECT DISTINCT JIOV.short_description outcome,

Line 311: JTF_IH_ACTIVITIES JIA

307: JTF_RS_RESOURCE_EXTNS_TL JRREV,
308: JTF_IH_OUTCOMES_TL JIOV,
309: JTF_IH_RESULTS_B JIRB,
310: JTF_IH_RESULTS_TL JIRV,
311: JTF_IH_ACTIVITIES JIA
312: WHERE JII.resource_id = JRREV.resource_id
313: AND JRREV.LANGUAGE (+)= USERENV('LANG')
314: AND jii.interaction_id = jia.interaction_id
315: AND JIOV.Outcome_id = JII.outcome_id

Line 324: jtf_ih_activities a

320: AND jia.cust_account_id = cust_acct_id
321: AND JII.start_date_time =
322: (select Max(i.start_date_time)
323: from jtf_ih_interactions i,
324: jtf_ih_activities a
325: where a.cust_account_id = cust_acct_id
326: AND a.interaction_id = i.interaction_id);
327: -- END BUG 5187355 scherkas 07/27/2006
328: