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.BIM_EDW_INTRCTNS_F_SIZE dependencies on JTF_IH_ACTIVITIES

Line 15: FROM JTF_IH_ACTIVITIES JIA,

11: CURSOR c_cnt_rows IS
12: select sum(cnt)
13: from (
14: select count(*) cnt
15: FROM JTF_IH_ACTIVITIES JIA,
16: JTF_IH_INTERACTIONS JII,
17: HZ_PARTY_SITES HPS,
18: EDW_BIM_SOURCE_CODE_DETAILS BSCD,
19: BIM_EDW_INTRCTNS_INC INC,

Line 70: FROM JTF_IH_ACTIVITIES

66: avg(nvl(vsize( ACTIVITY_ID ), 0)),
67: avg(nvl(vsize( INTERACTION_ID), 0)),
68: avg(nvl(vsize( DURATION), 0)),
69: avg(nvl(vsize( SOURCE_CODE), 0))
70: FROM JTF_IH_ACTIVITIES
71: where last_update_date between
72: p_from_date and p_to_date;
73:
74: