APPS.BIM_EDW_IH_MEDIA_M_SIZE dependencies on EDW_LOCAL_INSTANCE

Line 17: EDW_LOCAL_INSTANCE INST

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
20: AND
21: LKP.SECURITY_GROUP_ID=FND_GLOBAL.LOOKUP_SECURITY_GROUP( LKP.LOOKUP_CODE,

Line 64: from EDW_LOCAL_INSTANCE ;

60:
61: CURSOR c_2 IS
62: select
63: avg(nvl(vsize(INSTANCE_CODE), 0))
64: from EDW_LOCAL_INSTANCE ;
65:
66:
67:
68: BEGIN