APPS.BIM_EDW_IH_MEDIA_M_SIZE dependencies on FND_LOOKUP_VALUES_VL

Line 16: FND_LOOKUP_VALUES_VL LKP ,

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
20: AND