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_IH_MEDIA_M_SIZE dependencies on JTF_IH_MEDIA_ITEMS

Line 15: FROM JTF_IH_MEDIA_ITEMS JMI ,

11: CURSOR c_cnt_rows IS
12: select sum(cnt)
13: from (
14: select count(*) cnt
15: FROM JTF_IH_MEDIA_ITEMS JMI ,
16: FND_LOOKUP_VALUES_VL LKP ,
17: EDW_LOCAL_INSTANCE INST
18: WHERE JMI.MEDIA_ITEM_TYPE = LKP.LOOKUP_CODE AND
19: LKP.LOOKUP_TYPE = 'JTF_MEDIA_TYPE' AND LKP.VIEW_APPLICATION_ID = 0

Line 56: FROM JTF_IH_MEDIA_ITEMS JMI

52:
53: CURSOR c_1 IS
54: SELECT
55: avg(nvl(vsize(JMI.DIRECTION ), 0))
56: FROM JTF_IH_MEDIA_ITEMS JMI
57: where jmi.last_update_date between
58: p_from_date and p_to_date;
59:
60: